topic Re: How to avoid sending fields to API or other plarform endpoints in Workato Pros Discussion Board

How to avoid sending fields to API or other plarform endpoints

sampath — Tue, 16 Apr 2024 03:27:50 GMT

I have noticed weird behavior recently. 🙂

I was building a recipe and when I add "blank" word under the formula fields, that field will not sending to the endpoints.

But with the latest updates, when I send the same content to different endpoints, it is sending empty "" value to the destination.

Is there anything changed recently or does anyone knows how to avoid sending the fields to the endpoint ( I cant not assign the value. this is dynamic and has to assign variable. if variable does not have value, I should not sending this to the endpoint )

Re: How to avoid sending fields to API or other plarform endpoints

csadler — Fri, 19 Apr 2024 18:04:43 GMT

For most connectors, you can use the formula keyword (in formula mode) skip in order to have the connector omit the key all together. In practice, if you are feeding in a data pill, this is frequently paired with a presence check on the data pill and double pipes, allowing you to send the skip only when the provided data pill is empty:

As for expected behavior for sending blank values: As far as I was aware most connectors will forward the key with an empty string or even a null value. Some API's require blank strings in order to clear fields that do not otherwise have a "DELETE" verb associated with the correct record.

Re: How to avoid sending fields to API or other plarform endpoints

sampath — Sun, 21 Apr 2024 22:20:42 GMT

I just dont need to send blank or empty string. I need to avoid sending that field when there are no value assigned.

this happened in the loop and dynamically. some instance it has values and some instances there are no value. in that cases, I need to avoid sending.

Re: How to avoid sending fields to API or other plarform endpoints

csadler — Tue, 23 Apr 2024 18:07:30 GMT

What I mentioned above will omit the field all together. This is a standard approach in most of our builds, as the need to omit key value pairings is common.

Re: How to avoid sending fields to API or other plarform endpoints

spencerstone — Thu, 03 Apr 2025 20:42:55 GMT

@csadler Unfortunately I have not observed the behavior you are proposing. When I have used the [skip] function, I have observed the exact same thing as @sampath . The key-value pair shows up in my payload as having a "null" value. I also need the key-value pair to disappear entirely, as the [skip] function seems to suggest. I am having to make distinct schemas for each "if present" scenario as a result and it is getting untenable.

Were either of you able to find a resolution to this?

Re: How to avoid sending fields to API or other plarform endpoints

shivakumara — Fri, 04 Apr 2025 13:00:48 GMT

Hi @sampath ,
Here I provided solution for the above mentioned issue.
How to omit empty key-value pairs from Payload - Systematic Community - 9513

Please let me know if you need further clarification. I am happy to help.

Thanks and Regards,
Shivakumara K A