Hello!
When using Glide API, I can’t send data with paragraphs to text column.
This example works:
This is a text.
This also works:
This is a text. This is a text.
This is not working:
This is a text.
This is a text.
Please check.
Hello!
When using Glide API, I can’t send data with paragraphs to text column.
This example works:
This is a text.
This also works:
This is a text. This is a text.
This is not working:
This is a text.
This is a text.
Please check.
Do you get an error message?
If you’re sending multi-line strings without properly escaping the newlines, then you’re probably sending invalid JSON.
Hello @Darren_Murphy!
I can’t get a message with the tool I’m using.
Please check the example cited. Just a new line and the data can’t be sent.
You can try to see what I’m talking about.
Thanks.
Yes, I understand what the problem is. And as I mentioned, multi line strings in JSON must be properly escaped otherwise your JSON will be invalid.
That’s got to be difficult to code with! Must be a custom tool.
What @Darren_Murphy is stating is that you cannot embed a carriage-return/line-feed control character in your JSON. You have to replace it with \n\r
JSON can accept any Unicode character except " or \ or control-character
escapes for JSON:
" – Quotation Mark
\n – linefeed
\r – carriage return
\f – formfeed
\ – reverse solidus
/ – solidus
\b – backspace
\t – horizontal tab
\u four-hex-digits
Just adding a post besides for great replies provided by Darren and David!
Faced this same issue on Adalo and found a solution with JavaScript! : SendGrid multiple lines - #3 by dilon_perera - Get Help - Adalo
To paste codeblocks/pre-formatted text and have the formatting preserved, enclose the lot with 3 backticks on a separate line, before and after.
results in:
this is a code block
blah blah blah
I understood this part.