Change Json Payload into Qlik sense readable table

[MartW]

I'm busy with automation and I got a lot of stuff working.

But one thing I can't get to work is converting the Json Playload it create to a csv or an inline table that Qlik can understand.

Right now I've got an small Google sheets that automation get's the data from. But the data is in Json.

Is there a way to convert this into a readable inline table or a csv file.

I tried with creating a dropbox file and read the data line by line but I only get Json output in the dropbox file (that is csv)

[PietMichielRappelet · Accepted solution]

Hi MartW.

Thanks for posting the questions.

Did you find the 'CSV' formula that can convert a json to a csv, often to be used with the 'get keys' formula for the columns. 

Some interesting articles:

• Create CSV file with cloud storage connector 
• Sync small Qlik Sense datasets with Excel

hope this helps! 

[MartW]

@PietMichielRappelet  I tried that but I get the following error

 array_values(): Argument #1 ($array) must be of type array, Blendr\ApiIterator given

[MartW · Accepted solution]

I got it fixed. I had to write a header line to the csv file before I put in the data. Now it works