https://community.qlik.com/t5/App-Development/Override-auto-parsing-of-JSON-from-REST-API/m-p/1730879#M55758 <P>Hi, I'm calling an API which returns a JSON string.&nbsp; The Qliksense auto parser doesn't handle the JSON in the way intended.&nbsp; The structure of the JSON is such that Qlik creates a new table for each object in the json array instead of creating one big table.</P><P>So I will need to manually parse the JSON in the scripting.&nbsp; I've written VBA in MS Access to manually parse the JSON so I know what needs to be done, I just need to work out how to do the same in Qliksense.</P><P>My first problem, is how do I override Qliksense so it just pulls the JSON in as string without parsing?&nbsp; Once I have it as one big string in the script I will hopefully be able to work out how to manually parse it.</P><P>Thanks for any guidance.</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:18:43 GMT reddwarfcrew 2024-11-16T18:18:43Z https://community.qlik.com/t5/App-Development/Override-auto-parsing-of-JSON-from-REST-API/m-p/1730879#M55758 <P>Hi, I'm calling an API which returns a JSON string.&nbsp; The Qliksense auto parser doesn't handle the JSON in the way intended.&nbsp; The structure of the JSON is such that Qlik creates a new table for each object in the json array instead of creating one big table.</P><P>So I will need to manually parse the JSON in the scripting.&nbsp; I've written VBA in MS Access to manually parse the JSON so I know what needs to be done, I just need to work out how to do the same in Qliksense.</P><P>My first problem, is how do I override Qliksense so it just pulls the JSON in as string without parsing?&nbsp; Once I have it as one big string in the script I will hopefully be able to work out how to manually parse it.</P><P>Thanks for any guidance.</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:18:43 GMT https://community.qlik.com/t5/App-Development/Override-auto-parsing-of-JSON-from-REST-API/m-p/1730879#M55758 reddwarfcrew 2024-11-16T18:18:43Z