OpenAI action JSON error but JSON correct

[jpr]

Hi, Please see Loom video for context - https://www.loom.com/share/79db99dc19974f57bb8baef3e36407b3

OpenAI does not recognize the JSON dynamic data generated in Pabbly, yet the JSON data is correct when checking it in a JSON validator tool. In the Make automation tool, these JSON data sets are recognized by OpenAI so I don't understand why it won't do the same in Pabbly.

Workflow Name: Test - Professional Services
Workflow Url: https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZiMDYzMzA0Mzc1MjZlNTUzMzUxMzEi_pc

Can you please advise what I can do to help OpenAI recognize the dynamic JSON input fields.

Note, at the end of the prompt example json data is included but these are not input fields. They are only example json outputs we expect OpenAI to create. You'll also see that this is not the data that is highlighted in red. It's the input json data that is highlighted in red.

PS - I also see that there is a ": No Data" message at the end of the json string which is not in the dynamic json outputs. Maybe this is causing it but why would it be added?

UPDATE: The ": No Data" has got nothing to do with it. When I enter the actual JSON values (i.e. '6. Extract JSON - Post History JSON', '8. Extract JSON - Service Urls JSON', '10. Extract JSON - Image DB JSON') into the prompt (in other words, it's not selected dynamically. I copy pasted the output values of these extracted JSON's and pasted them directly into the prompt) and I select the gpt-4o-mini model, it works. The problem comes in when the values (i.e. '6. Extract JSON - Post History JSON', '8. Extract JSON - Service Urls JSON', '10. Extract JSON - Image DB JSON') are selected dynamically.

 

[ArshilAhmad]

Hi @jpr,

It seems that in your Google Sheets spreadsheet, you have entered the data in the first row, which is incorrect. The first row should contain the headers, as the keys depend on it. Since you've entered the data in the first row, any changes to it also change the keys, which disrupts the mapping in the subsequent steps—this is the issue you're currently encountering.


To fix this, you need to add proper headers in the first row, enter your data starting from the second row, and then click the 'Save & Send Test Request' button in the Google Sheets action step. This will fetch the data with the updated headers, and allow you to map it correctly to the next steps.

Example: In the screenshot shared below, the data marked in yellow are the keys, and they need to remain consistent. Since the keys rely on the headers of the sheet, the headers must also remain consistent.