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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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