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?
