Zapier Automation 400 Error on Longformfields

[byebb]

Hosting

• Self
  • Method: k8s
  • Budibase Version: 2.28.4

Bug Description
If I submit a text that contains line breaks such as

"""
My awesome

comment to submit
"""

and forward it to an automation the uses a Zapier webhook, then the json payload of my Longformfield for the comment is invalid, as JSON does not allow linebreaks inside the value strings.

I tried to find a solution to create temporary values cleaning up the string, but I think it would be good to find some way to submit the text including these line breaks.

What would be the way to go?

I want it to have it in a google docs sheet in the end.

Screenshots

Desktop:

• OS: Windows 11
• Browser Chrome

The issue should be quite clear. I wonder what the best solution is

[ConorWebb96]

Hey @byebb,

Please check what you are sending is valid JSON. The output error you are getting there isn't valid JSON.

[byebb]

Hey @byebb,Please check what you are sending is valid JSON. The output error you are getting there isn't valid JSON.

That is exactly my issue. I know the JSON is not valid, but that is exactly my issue. I don't know how to solve this and would rather expect that the Longformfield would deal with itself.

I'd love to create a custom variable based on that field to replace all line breaks with another character, but I just can't get into the variable.. since the payload field of the Zapier automation does not allow me to manipulate the variable before I create the JSON payload via Javascript.

[byebb]

BUDI-8350 Zapier Automation 400 Error on Longformfields

Unfortunately, I cannot open this:

Can you put the relevant information you are referring to here?

[ConorWebb96]

You can use a combination of a few different steps e.g. JS scripting block (to format the JSON however its needed for Zapier to accept.) + backend log (can view whatever you are outputting that has been created via the js scripting step)

If you are simply applying Zapier with string on its own, its likely not going to accept it.

Going to convert this to a discussion as it isn't a bug.