Is it possible to paste Multi-Line Long text into HTTP Response?

Question

I am trying to pass text like

"Video Transmission & internal Recording

No Filters

1x 11 Handheld Monitor 1x 19 Monitor"

--> so 5 and more likes with several empty line inbetween as a single text from make(integromat).com to Lexoffice via HTTP request as ... "description": "ItemDescription" ... with "ItemDescription" being the multi-line long text and I get an error from HTTP Module saying "Error: 400 Bad Request, The request body could not be parsed due to malformed json syntax."

But I need the multi-line item to appear in Lexoffice on the invoice.

Is there a workaround for it?

I expect the long multiline text to appear on the invoice where I try to paste it with the http module

My Lexoffice-API HTTP code for URL https://api.lexware.io/v1/quotations, POST:

{
  "voucherDate": "{{formatDate(now; "YYYY-MM-DDTHH:mm:ss.SSSZ")}}",
  "expirationDate": "{{formatDate(addDays(now; 14); "YYYY-MM-DDTHH:mm:ss.SSSZ")}}",

"address": 
{
    "contactId": "{{48.data.content[].id}}"
  },

"lineItems": {{108.LineItems}},

  "totalPrice": { "currency": "EUR" },
  "taxConditions": { "taxType": "net" },
  "shippingConditions": {
    "shippingType": "service",
    "shippingDate": "{{formatDate(now; "YYYY-MM-DDTHH:mm:ss.SSSZ")}}"
  }
}

LineItems are being set as variable {"type":"material", "id":"{{69.data.id}}", "name":"{{69.data.title}}", "description":"{{69.data.description}}"}. After that I do {{map(66.array; "LineItems")}} and after that "108.LineItems" = [{{join(104.LineItems_v0; ", ")}}]. Error is due to description length as if I delete/shorten it (to single line), all works.

Evert · Accepted Answer · 2025-10-02 19:05:13Z

0

The correct way to escape newlines in JSON is to replace them with the string \n

Example below is using \n\n for double lines (this is like pressing Enter key two times):

"Video Transmission & internal Recording\n\nNo Filters\n\n1x 11 Handheld Monitor 1x 19 Monitor"

edited Oct 2 at 19:05

Evert

101k18 gold badges136 silver badges221 bronze badges

answered Oct 2 at 18:17

VC.One

16.2k4 gold badges27 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Maryna_HI Oct 3 at 12:31

OMG that's great, I was looking for a solution for a looong time!! that helps a lot!! One question through - if my Description is a variable, how can i look in make for the empty lines in it and replace them with \n\n?

VC.One Oct 17 at 15:59

Sorry I don't use Make so not sure how variables are used there (is it Javascript??). If you've now got a solution about that, then post it as a new Answer to help others. If not solved, then I'm not sure what to suggest because a variable exists in the code editor and there is no real "new line" concept inside code editors. If the variable loads text from outside (lexample: a text file) then it can be done (eg: a text file has new lines added automatically)

Collectives™ on Stack Overflow

Is it possible to paste Multi-Line Long text into HTTP Response?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related