Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
wcer
Contributor
Contributor

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

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,field...",
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?

 

 

 

 

 

 

 

 

Labels (5)
0 Replies