Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm obtaining a json from a API (Freshdesk) and automatically qlik creates this script:
RestConnectorMasterTable:
SQL SELECT
"id",
"survey_id",
"user_id",
"agent_id",
"feedback",
"group_id",
"ticket_id",
"created_at",
"updated_at",
"__KEY_root",
(SELECT
"default_question",
"__FK_ratings"
FROM "ratings" FK "__FK_ratings")
FROM JSON (wrap on) "root" PK "id";
Teh API limits to 100 rows for each call and I want to create a incremental load too. For this reason, the __Key_root doesn't wok for me, in the loop is creating autogenerated number from 1 to 100 in each iteration.
How can I associate in the load script another field? In this case the primary key is the ID field.
I want this:
survey |
---|
id |
Ticket_id |
feedback |
default_question |
... |
ratings |
---|
id |
default_question |
thanks!
I'm suffering the exact same issue, did you find a solution?