Sending API Data to Zapier with Empty Columns | Clay

Sending API Data to Zapier with Empty Columns

What can I do so that I send the API to Zapier even if some columns are empty? https://app.clay.com/workspaces/228622/tables/t_sNyWjg39ydkz/views/gv_JwqasjNyhy3Z

22 comments

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Muhammad S.
·
·
it will still send, what is issue?
Theo K.
·
·
it doesn’t send as it says “Some inputs are missing”
Muhammad S.
·
·
when you are setting up inputs in the api there is a blue colored toggle button, you can turn it off to make that specific input NOT NECESSARY
Theo K.
·
·
i did that and still doesn’t work
Muhammad S.
·
·
it should work
Muhammad S.
·
·
can you share screenshot of the error + input
Theo K.
·
·
would you like to provide a screenshot of that button?
Muhammad S.
·
·
yes
Muhammad S.
·
·
this should be turned off
Theo K.
·
·
I see thanks
Theo K.
·
·
I now get “Failed to parse body input”
Muhammad S.
·
·
thats another error
Muhammad S.
·
·
create a text column
Muhammad S.
·
·
copy paste all the body from HTTP api body to that text column as is
Muhammad S.
·
·
then add that text column directly into the input of HTTP API
Muhammad S.
·
·
basically the input needs to be stringified.
Theo K.
·
·
I’ll wait for someone from the Clay team to help.
Theo K.
·
·
thanks though
LuisArturo
·
·
Hey there Theo thanks for reaching out and appreciate you jumping in Muhammad! Got this working for you Theo, made a loom to explaining what happened, but a quick recap on what was causing this, HTTP API's expects columns to have a value even if the column is empty and so we need to use a Javascript formula to get around this. https://www.loom.com/share/1615dbcd8f994382953dab6168ec7043?sid=41529892-a3c7-41e2-b80e-184a9f4ade29
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Theo K.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: