Hi, Can anyone help on below JIRA connection using REST API, the TEST connection is success but when I try to load I can't see any rows. below are my parameters.
I can see only blow while try to "Select Data"
//Sample Script
LIB CONNECT TO 'JiraSamTest';
RestConnectorMasterTable:
SQL SELECT
"startAt",
"maxResults",
"total",
"__KEY_root",
(SELECT
"@Value",
"__FK_issues"
FROM "issues" FK "__FK_issues" ArrayValueAlias "@Value")
FROM JSON (wrap on) "root" PK "__KEY_root";
[issues]:
LOAD [@Value],
[__FK_issues] AS [__KEY_root]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_issues]);
[root]:
LOAD [startAt],
[maxResults],
[total],
[__KEY_root]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY_root]);
DROP TABLE RestConnectorMasterTable;