Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JeffQlik
Contributor II
Contributor II

SharePoint - Multi Level JSON to Table

Hello - 

I'm using the REST connector to retrieve List Data from Sharepoint.  In the REST call, $expand is used to get the value of a People Field and a Lookup Field for Status.

The JSON return becomes Multi-level when $expand ... well ... does the expansion of the fields...

Is there a way to have the additional level(s) placed into the table directly?

I reviewed some earlier posts around multi-level JSON from 2017-ish time frame ... Has there been any improvements or different options being now 2020?

Below / attached is the endpoint URL and the return data ... In this case, there is the main level and just one level below.  

Is it possible to get the second level into the main table directly?

SharePoint JSON Return ExpandSharePoint JSON Return Expand

 

Labels (4)
0 Replies