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!
