New line in desc in Trello API (VBA)

Question

Hello, I'm trying to create a card from API call with my VBA application. The problem is I can't find how I can add new line / new paragraph to my description. Here is the body I send in my POST route: {"idList":"65a7a1axxxxxxxxxxxx", "name":"7 - test test", "desc": "020-T1_DEB - Part 0210000-PAT \n \n **Issue : **\nThis is a text to explain the issue.", "key":MYKEY,"token":MYTOKEN} Route: "POST", "https://api.trello.com/1/cards" I tried with: \n, , ,
In most of the case, I got the symbol (\n, ...), but I never got the carriage return / new line feed: 020-T1_DEB - Part 0210000-PAT \n \n **Issue : **\nThis is a text to explain the issue. How can I add new lines to my card's description ? Thanks!

Damien Lohier · Answer

I didn't know we can call with JSON Payload !

Thanks, it works fine.

I didn't need to convert the name and the description of the card before sending it:

Dim payload As String
payload = "{" & _
"""idList"":" & ConvertToJson(list) & "," & _
"""name"":" & name & "," & _
"""desc"":" & desc & "," & _
"""key"":" & ConvertToJson(APIKey) & "," & _
"""token"":" & ConvertToJson(token) & _
"}"
http.SendRequest("POST", "https://api.trello.com/1/cards", payload, False)

I may create a new ticket for attachment upload. I tried with your code but it does not work me (I receive Status 400: Bad request).

Thanks again for your help !

Dag Atle Stenstad · Answer

You don't need to parse to JSON when you send it in the URL. That's only necessary if you're sending it as a JSON object (which is recommended).

Here's an example of how I create a JSON object to create a new Jira issue

Dag Atle Stenstad · Answer

Ah, you pass the variables as parameters in the URL. You can try using %0A for a line break since it's in the URL (similar to how spaces are replaced with %20).