Create a confluence page having the JIRA macro or JIRA filter.

Question

Hi Team, I am able to create the blank page in confluence using rest api. If I try to create a page having JIRA macro I am not getting succeeded . Below is the snippet for creating a page. createPage = "{"type":"page","title":"new page","space":{"key":"OMS"}," + ""body":{"storage":{"value":""

Display the Sprint -Sprint 5 which is closed issues.

" + """ + ""System JIRA20" + ""key,summary,type,created,assignee,reporter,priority,status,resolution" + ""Sprint = "OMS Sprint 5" and status=close and project = OMS " + ""3f701a8d-470a-3309-8926-3b7be06fa653

" + "","representation":"storage"}}}"; Please any one can help me on this.

naveenkumar_dp · Answer

Hi Davin,

Thanks for your reply,

I am using java code to achieve this. After changing the JSON escape format also no luck.

I got the "500 Internal Server Error".

Can you please help me on this.

naveenkumar_dp · Answer

Hi,

is there any api's are available for creating a template instead of page in confluence?

Davin Studer · Answer

My hunch is there is something off in the raw post. Probably something is not escaped properly. I would first mock it up in Confluence and get the storage format for the page. Then run that storage format through a tool to escape out the string for JSON such as below ...

https://www.freeformatter.com/json-escape.html

https://codebeautify.org/json-escape-unescape

Then craft your JSON using the escaped string. Next, you will need to escape the JSON to work within a string. So take that JSON with the escaped storage format and escape that whole thing out again. Not sure what language you are using but here is one for JavaScript.

https://codebeautify.org/javascript-escape-unescape

Then take that out put and put it back into your project to see if it works.