Issue parsing nested JSON payload from SEO metric API via REST Connector
Hi everyone, I have been setting up a scheduled REST connection in Qlik Sense to pull domain and page authority metrics into our marketing dashboard. When querying the external tool endpoints for bulk URL analysis, the response returns nested arrays for historical scores, but Qlik's REST connector keeps flattening the response into multiple disconnected tables that separate the root domain identifiers from their respective score records.
I tried adjusting the pagination settings and data connection parameters, yet whenever the reload task executes, the resulting data model creates synthetic keys and null values across the metric fields. Has anyone encountered similar JSON transformation issues when pulling automated website metrics from this kind of tool into Qlik Sense, and what scripting approach would you recommend to keep the domain keys and metric history properly joined?
The rest connector does separate nodes into tables, but not without correct connections. Perhaps you have not selected all necessary data and therefore correct keys that link the tables are not generated? Let's say you have a treee like this in your json response: ROOT |---A |---B |------B2 |------B3
If you select to load only A and B2, then links between tables will be missing since B2 can only link to B. And the link between A and B will be through ROOT.
