I am encountering a problem with setting a relation field in my NocoDB database using data from a webhook in Activepieces. While I can update other text fields in NocoDB, I’m having difficulty correctly populating the relation field.
Description of the Flow:
My flow involves the following steps:
- Catch Webhook: This step receives data, including a “Person ID.”
- Update a Record (NocoDB): This step is intended to update a “Company” record in NocoDB and set the relation field to the “Person ID” received from the webhook. This should create a link between the “Company” record and the corresponding “Person” record in NocoDB.
Observed Behavior:
- A new record in NocoDB is successfully updated.
- Other text fields in the NocoDB record are correctly populated with data from the webhook.
- The “Person ID” is correctly received by Activepieces from the webhook.
- However, the relation field in NocoDB is not being set correctly. The link between the “Company” record and the “Person” record is not being established.
- The relational fields do not even show in the UI sync from NoCoDB
Details about NocoDB Setup:
- I have two tables in NocoDB: “Company” and “Person.”
- The “Company” table has a relation field that links to the “Person” table.
- The relation field in NocoDB is configured to store the ID of the related “Person” record.
Troubleshooting Steps:
- I have verified that the “Person ID” being received by Activepieces is the correct ID of an existing record in the “Person” table in NocoDB.
- I have confirmed that the NocoDB connection in Activepieces is working correctly, as other text fields are being updated.
- I have reviewed the Activepieces documentation for the NocoDB connector, but I haven’t found specific guidance on handling relation fields.
The Problem:
The issue seems to be that Activepieces is not passing the “Person ID” to NocoDB in the format that NocoDB expects for setting a relation, or even showing the relational fields. Even though the correct ID is being received, it’s not being interpreted as the ID of the related record.
Could you please provide guidance on the correct way to set relation fields in NocoDB using Activepieces? Specifically, I need to know how to format the data from the webhook so that NocoDB can correctly establish the link between the records, or if Activepieces even allows updating relational fields as shown from this NoCoDB record.
