I’m encountering an issue with a flow where data from a ChatGPT step is not fully populating a NocoDB record, despite the UI showing correct field mapping.
Flow Overview:
- Trigger: Webhook receives a “Company Website URL.”
- Action 1 (ChatGPT): “Company Search ChatGPT 1” - Takes the URL and returns a JSON object with company details (e.g.,
companyName,companySynopsis,industry,yearEstablished,hqCity, etc.). - Action 2 (NocoDB): “Update a Record” - Intended to update an existing NocoDB record (identified correctly, as one field does update) with the various details retrieved from the ChatGPT step.
Observed Behavior:
- A new record is successfully created in NocoDB when the flow runs.
- The “Company Website URL” field in NocoDB is correctly populated using a variable from the “Catch Webhook” step.
- If I manually enter static text into other fields in the “Update a Record” step in Activepieces, that text is correctly written to NocoDB.
- The data retrieved from the “Company Search ChatGPT 1” step is accessible and can be successfully used in other actions (e.g., sending an email with the ChatGPT output).
- However, when I attempt to populate other NocoDB fields (e.g., “Industry,” “HQ City,” “Company Name”) using the corresponding variables from the “Company Search ChatGPT 1” step via the Activepieces UI selector, these fields remain empty in the NocoDB record after the flow runs.
It appears that the connection to NocoDB is working for writing the webhook ID, and static text can be written to other fields. The issue seems to be specifically with passing the variables from the ChatGPT step to the NocoDB “Update a Record” action for fields other than the URL.
Please help investigate why the data from the ChatGPT step, which is clearly available and mapped via the UI, is not being written to the corresponding NocoDB fields? It seems like there might be an issue with how these specific dynamic data points are being passed to or processed by the NocoDB “Update a Record” action.
,
