JSON key repeating in iteration

darroyo_telcomu — Wed, 18 May 2022 09:08:26 GMT

Hi. I'm trying to get data from json with the following script. Basically, this is about get tasks data and the tags associated to that tasks.

RestConnectorMasterTable:
SQL SELECT
"__KEY_root",
(SELECT
"id",
"name",
"tagIds",
"__KEY_task",
"__FK_task",
(SELECT
"@Value",
"__FK_tagIds"
FROM "tagIds" FK "__FK_tagIds" ArrayValueAlias "@Value")

FROM "task" PK "__KEY_task" FK "__FK_task")

FROM JSON (wrap on) "root" PK "__KEY_root"

WITH CONNECTION(
URL "$(url)",
QUERY "status" "ALL");

This code is in an iteration loop, and every time the query runs, the field "__KEY_task" begins with value 1. I would need that value be unique. Does anybody know how can I make that value unique?

Thanks for your attention.

topic JSON key repeating in iteration in Connectivity & Data Prep

JSON key repeating in iteration