.png){kind=logo}
Troubleshooting JSON API Errors in Clay with N8N Integration
I"m creating a JSON HTTP API in Clay to post to N8N. I have "Remove empty values" checked and I still get an error citing that I have a blank field.
I"m creating a JSON HTTP API in Clay to post to N8N. I have "Remove empty values" checked and I still get an error citing that I have a blank field.
Even with "Remove empty values" checked, you might still encounter JSON parsing errors due to formatting issues rather than empty fields. Common causes include: 1. Missing quotes around keys or string values 2. Incorrect syntax (extra commas, mismatched brackets) 3. Wrong data types (numbers in quotes when they should be numeric) 4. Unescaped special characters Could you please copy and paste your JSON body into the chat so I can help troubleshoot the specific formatting issue? The "Remove empty values" option only removes null/undefined values but doesn't fix JSON syntax problems.
Talk to a person
Hi Matthew, thanks for your message - taking a closer look at this now!
It looks like you were able to make the SFDC call here, I'll go ahead and mark this as tentatively closed for now. But feel free to reach back out if any other issues pop up with this SFDC HTTP API connection you've set up here.
Have you tried checking for missing fields. Alternatively set the field to allow nulls or empty values
Hi Matthew, sorry about the delay here - I'm not seeing any records available in this table, is the issue persisting here? If yes, can you add some data to this table so we can take a closer look at what may be causing the issue here?
There are many times when I might have a BLANK column of data on a specific row, and I still want the API to write the rest of the existing data. Right now I have the following: 'no@searchresults.com') + "\",\n \"Alternate_Email_1\": \"" + Clay.formatForJSON({{Alternate Email 1}} || If an email doesn't exist, I don't want to be forced to write no@searchresults.com just to get the API to write. Does that make sense?
I'm seeing you build out the custom .js logic here - also seeing 200s across the board, are you able to push the data to zapier at the moment or still facing issues with this?
It works.. However, if there's a blank COLUMN in a particular row, I want the rest of the data to still be sent. The "Remove empty values" doesn't work as it's supposed to. I should be able to do normal JSON and if a work phone is missing, but I found a mobile phone, the API should still push to Zapier even with the work phone missing.
I have to force a value such as N/A or no@searchresults.com as an empty email address. I shouldn't have to do this with "Remove empty values" checked.
Makes sense Matthew, I just recorded this quick video to explain: https://www.loom.com/share/d89eeef1f3c94f3e9ecce90cfb58107a?sid=e3b5b886-c7ff-4a5c-840b-e8a19a78dfa9 Let me know if this makes sense!
WOW... I'll try this right now.
What do I select with the yellow caution triangles?
