Im getting Internal Server Error 500 when updating a confluence page via Curl

Question

The curl call im using is this one: curl --location --request PUT http://localhost.com:8090/rest/api/content/21169510 --header "Accept: application/json" --header "Content-Type: application/json" --user user:password --data "{\"id\": \"21169510\",\"type\": \"page\",\"title\": \"Test Doors\",\"space\": {\"key\": \"TOOL\"},\"body\": {\"storage\": {\"value\": \"

KPI	KPI	KPI
1	1	1
1	1	1

\",\"representation\": \"storage\"}},\"version\": {\"number\": \"13\"}}" Im getting problems when updating the content of a page with something more complex than a simple sentence (in this case it works perfectly). If i dont use the \" with the body-storage-value, it gets an error with the < character, and if i use it, it answers with 500 internal server error. in this case i was trying to create a table. Does anybody know what am I doing wrong?

unknown · Answer

Thank you for your answer. Using Postman I am able to do it, but i need  to use the curl commands so i can automate it later. Its just matter of knowing how do i need to introduce the data for the body content, and how do i need to put the \" characters. I am able to do it creating a Json from the command line and adding in there the variables but that is significantly more difficult. So if anyone knows how to solve my doubt it would be great.

Thomas Deiler_db00h3 · Answer

Dear @[deleted],

I know this kind of problems - made the same xp in the past. In most cases its a problem with encoding / escaping special chars.

I recommend to use first a browser extension for posting REST calls. There you can step by step debug you JSON payload.

Then I also recommend to call curl from a script. Python or PHP are pretty fine. They have both functions to encode the data to UTF-8.

So long

Thomas