How to fill in relationship field in Notion by sending data from Pabbly?

[filipeosilva]

Hi everyone!

I'm using Pabbly to send information to a database I have in Notion.

For most columns, the values I'm sending are being received well in Notion (Date, Checkbox, Text, Numbers...)

But in Notion there is a type of field where we can relate other pages as the field value, and in this case the value that I send is not populated in Notion.

Example:

In the "Banco" column, the value to be filled in would be "Hotmart":

But in Pabbly, sending the value "Hotmart" in this field, nothing is populated in Notion:

I've already tried sending the name of the page, url, but nothing has worked so far.

Can you help me please?

 

[Himesh]

Before this step you need to use Get Databse Details action step. Or try to Fetch the ID of HotMart and map that Id in the field.

If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call. FYI I'm not from Pabbly Connect team, just a freelancer who helps other Pabbly users.

 

[Pabblymember11]

Hey @filipeosilva

As of now, we are not supporting the relationship field in Notion's action step. So, I am afraid data wouldn't pass in the Relationship field.

 

[filipeosilva]

Hey @filipeosilva

As of now, we are not supporting the relationship field in Notion's action step. So, I am afraid data wouldn't pass in the Relationship field.

Hello Suport!!

And is there any alternative for these cases?

 

[filipeosilva]

Before this step you need to use Get Databse Details action step. Or try to Fetch the ID of HotMart and map that Id in the field.

If you are still not able to solve this on your own feel free to DM me and we can do a free zoom call. FYI I'm not from Pabbly Connect team, just a freelancer who helps other Pabbly users.

Hello Himesh.

Thanks for the comment.

I couldn't do it as you suggested, could you help me with a practical example?

 

[Pabblymember11]

And is there any alternative for these cases?

I couldn't discover any additional solution, but if Himesh has an alternative, then we can work on it.

 

[PerformancePPC]

There's any update here? The relationship field remain "not supported" on Notion?

 

[Preeti Paryani]

Hello @PerformancePPC

Unfortunately, we do not support the relationship field in Notion.

 

[PerformancePPC]

I found a way to resolve the problem via a custom script.
Using this code I find the way to interrogate the column "Contatto" of the DB "xxxx" and the check the relation of the element of previous "yyyyyy" DB.

Hope this work even for you.

let requestURL = 'https://api.notion.com/v1/pages/4. Id : xxx';

let bodyJSON = JSON.stringify({
"properties": {
"Contatto": {
"relation": [
{ "id": "3. Id : yyyyyy" }
]
}
}
});

fetch(requestURL, {
method: 'PATCH',
headers: {
'Authorization': 'Bearer insert_bearer_here',
'Content-Type': 'application/json',
'Notion-Version': '2022-06-28'
},
body: bodyJSON
})
.then(response => response.json())
.then(response => {
callback(null, response);
});