Hi, I'm calling an API which returns a JSON string. The Qliksense auto parser doesn't handle the JSON in the way intended. 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.
So I will need to manually parse the JSON in the scripting. 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.
My first problem, is how do I override Qliksense so it just pulls the JSON in as string without parsing? Once I have it as one big string in the script I will hopefully be able to work out how to manually parse it.
Thanks for any guidance.