How to query Salesforce and Adobe Analytics API and parse nested JSON resultsets?

wcer — Fri, 10 Apr 2026 16:57:06 GMT

In Qlik data load editor, I've succesfully obtained an OAuth Access Token to query a Salesforce and Adobe Analytics staging environment's objects (through a standard REST connection).

I'm then trying to do a GET query as such

SQL SELECT
"Id",
"field1",
"field2",
"field3",
"__FK_root"
FROM JSON (wrap on) "root_u_records_u_items"
WITH CONNECTION (
URL "https://mydomain.sandbox.my.salesforce.com/services/data/v62.0/query?q=SELECT+Id,field1,field2,field3+FROM+tablename+LIMIT+2000",
HTTPHEADER "Authorization" "Bearer $(vAccessToken)",
HTTPHEADER "Accept" "application/json"
);

But it only sees no rows--but in the output 1 can see 2000 items. I believe it's in nested JSON format.

How do you get Qlik to properly interpret the nested JSON into a table structure?

topic How to query Salesforce and Adobe Analytics API and parse nested JSON resultsets? in Integration, Extension & APIs

How to query Salesforce and Adobe Analytics API and parse nested JSON resultsets?