Jira Chart macro not working if inserted via API

[Farwa Shahid]

Hi,

I'm trying to add Jira Chart macro to my confluence page via API.

When I try to add manually it works fine and the chart displays as expected but via API, it shows com.atlassian.sal.api.net.ResponseException: Can not retrieve jira chart image.

Documentation says that jira charts can't be added via wiki markup.
below is my storage format

<ac:structured-macro ac:name="jirachart">

    <ac:parameter ac:name="chartType">pie</ac:parameter>

    <ac:parameter ac:name="statType">reporter</ac:parameter>

    <ac:parameter ac:name="showinfor">true</ac:parameter>

    <ac:parameter ac:name="jql">"project in (ENG1 , ENG2) AND resolution is EMPTY AND issuetype = Bug AND statusCategory != Done"</ac:parameter>

    <ac:parameter ac:name="serverId”>{server-id}/ac:parameter>

    <ac:parameter ac:name="isAuthenticated">true</ac:parameter>

</ac:structured-macro>

A widely applied and suggested solution on this platform is to check cache folder for JIRA, but my question is, if there's a problem with Jira Caches folder, why the macro is working manually ?

Can someone please provide me with urgent help.

[Pramodh M · Accepted solution]

Hi @Farwa Shahid 

Follow these methods

• Add the chart manually in the Confluence page
• Get the Storage format of the page
• Modify the page and update it to meet your needs via API

Let me know if it works

Thanks

[Farwa Shahid]

It worked. Thanks!
There was actually encoding error with my JQL.

[Stephen Ellwood]

How do you get the Python API to give you storage format output?  I seem to get html format??

[Luca Mingarelli]

Same here: any news on this?