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.