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?
