Can't add paragraphs via Glide API

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.

3 Likes

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

4 Likes

Just adding a post besides for great replies provided by Darren and David! :raised_hands:

Faced this same issue on Adalo and found a solution with JavaScript! : SendGrid multiple lines - #3 by dilon_perera - Get Help - Adalo

2 Likes

I should have read my reply as posted. It looks like it garbled the syntax. Here is a screen-shot:

To paste codeblocks/pre-formatted text and have the formatting preserved, enclose the lot with 3 backticks on a separate line, before and after.
Screen Shot 2022-08-15 at 9.29.16 AM

results in:

this is a code block
blah blah blah
3 Likes

I understood this part. :crazy_face:

2 Likes