Don't understand how to transform JSON response into table

[bonvin]

I have a JSON response that looks like this: 

{

  "data": {

    "field1": "value",

    "field2": "value",

    "field3": "value",

    "subtable1": {

      "field4": "value",

      "field5": "value"

    },

    "subtable2": {

      "field6": "value",

      "field7": "value"

    }

}

What's the statement that will let me turn all of that into one single table with 7 columns? 

[rbartley · Accepted solution]

Hi,

I assume you've tried looking for a different API that returns all employees (for the JIRA solution there are many different APIs depending on what you are trying to achieve). 

I had a similar issue with the keys when I had to start using pagination as I returned more than the maximum allowable number of records per GET request. I found that the solution was to change the key generation strategy in the connection properties to fully qualified record  in order to generate a unique ID (see below).

[bonvin]

No, this garbage API is what we've got. I've been nagging them about giving us access to the actual database, which would make everything a lot easier, but that's a hard no I'm afraid. 

But what do you know, changing the key generation strategy worked. Woohoo! 

I thank you so much for all your help and patience! I've certainly learned a lot about Qlik through this ordeal. Now to finally get started on this report...

[rbartley]

Glad it helped.  I found it very frustrating when I first started using the REST connector.  As usual, the help pages lack sufficient variety of examples to be really useful. In general, we have to rely on those who post on these Community pages, which is why I try to answer questions from time to time, to give something back.

Good luck with the rest.