Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Custom foreign key loading json

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!

1 Reply
André
Contributor III
Contributor III

I'm suffering the exact same issue, did you find a solution?