Skip to main content

Hi all,

I need to send JSON to an API where some fields must be with a number/text and some with null, for example:

 

"overnightStaysTotal": 83,

"taxFreeResidency": 0,

"taxFreeChildren16Years": null

 

Zapier always replaces empty values with “No data”, and the API returns Bad Request.

I already tried several suggestions from the Zapier community :

  • Code by Zapier (JS) returning taxFreeChildren16Years: null

  • Webhooks by Zapier – Custom Request with application/json

  • Different unflatten/raw options

But the Zap still sends “No data” or omits the key.


Question:
Is there any reliable way to make Zapier send a real null value in the JSON payload instead of “No data”?


Thanks!

Hey ​@NM-Apart,

I think it will work with Webhooks by Zapier – Custom Request with application/json. You have to give a JSON body in the data. 


Here is a helpful article about Webhooks in Zapier- https://help.zapier.com/hc/en-us/articles/8496326446989-Send-webhooks-in-Zaps. Hope it helps!


Hi ​@NM-Apart 

Help us have more info by posting screenshots showing how your Zap step is configured in EDIT mode.


Thanks everyone for the help!
The issue was solved by using a Custom Request. It probably failed before because I left some fields empty instead of setting them to null (as text). Or maybe it was another small detail I missed — but it’s working now, returning 201 Created.

Appreciate the support! 🙌