Custom foreign key loading json

Anonymous — Sun, 10 Jun 2018 19:01:14 GMT

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!

Re: Custom foreign key loading json

André — Mon, 27 Mar 2023 08:31:22 GMT

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

topic Custom foreign key loading json in Connectivity & Data Prep

Custom foreign key loading json

Re: Custom foreign key loading json