• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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

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":

Captura de Tela 2024-02-08 às 21.42.45.png


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

Captura de Tela 2024-02-08 às 21.47.27.png


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

Can you help me please?
 

Himesh

Active member
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.
 
P

Pabblymember11

Guest
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.
 
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?
 

PPPC

Member
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.

Code:
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);
});

Screenshot 2024-11-27 alle 17.48.01.png
 
Top