How to export forms data in bulk as JSON

[Zhenjun Hu]

Currently we can export forms as XLSX and PDF. Is there a way to download them in JSON format so I can edit and process them with more automatic way?

[Aaron Pavez _ServiceRocket_ · Accepted solution]

Hi @Zhenjun Hu 

It seems xlsx is the only option to export:

https://developer.atlassian.com/cloud/forms/guides/export-forms/

You will have to find a plugin for that or parse your own JSON from the xlsx.

Here is a handy guide on how to do it for Jira issues. It might be worth checking to create your script:

https://community.atlassian.com/t5/Jira-articles/How-to-export-all-issues-from-Jira-in-JSON-format/ba-p/2372688

Regards

[Zhenjun Hu]

Thanks @Aaron Pavez _ServiceRocket_ 

I've got another way to pull the form data as JSON by issue id using REST API:

/rest/api/2/issue/{issueIdOrKey}/properties/{propertyKey}

PropertyKey for forms are: 

proforma.forms.i1 (i2, i3, i4 etc, depends on how many forms you got in the issue)

However the limitation is that I have to loop through every single issue instead of getting them in bulk.

Just want to check out if there is such function. Seems like it's not yet available in Jira though.

[Aaron Pavez _ServiceRocket_]

Not in bulk. The only way it seems is as you mention. loop one by one.

Regards