Dynamic Field Names in Rest API JSON Response

[njhunjhun]

Hi!

We are doing some analysis on JIRA using Qlik Sense. The Api we are using returns sprint id's as fields in the JSON response. I Can not use the sprint ID's as fields in my script as those would always change.

I tried using Select * FROM "issueKeysAddedDuringSprint"  but looks like select * does not work on JSON Wrapper.

Is there a way I can select all the fields from the table in JSON Wrap without specifiying the field names or fetch the fieldnames itself?

[andoryuu]

No, the wrapper in Qlik Sense needs to have the field names specified. If you need dynamic field names to be loaded you'd be better off using PowerShell or some other external tool to query the API, land the data in a flat file, and import it from the files.