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]);