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.
![clipboard_image_1.png clipboard_image_1.png](https://community.qlik.com/t5/image/serverpage/image-id/21312iA498C2A560739D30/image-size/medium?v=v2&px=400)
![clipboard_image_2.png clipboard_image_2.png](https://community.qlik.com/t5/image/serverpage/image-id/21313iF925331A39EB83E7/image-size/medium?v=v2&px=400)
![clipboard_image_3.png clipboard_image_3.png](https://community.qlik.com/t5/image/serverpage/image-id/21314i79B95FC7E30D175B/image-size/medium?v=v2&px=400)
![clipboard_image_4.png clipboard_image_4.png](https://community.qlik.com/t5/image/serverpage/image-id/21315i644FCBDF315979BD/image-size/medium?v=v2&px=400)
![clipboard_image_5.png clipboard_image_5.png](https://community.qlik.com/t5/image/serverpage/image-id/21316iF1E46AF62CE2D752/image-size/medium?v=v2&px=400)
I can see only blow while try to "Select Data"
![clipboard_image_6.png clipboard_image_6.png](https://community.qlik.com/t5/image/serverpage/image-id/21318i5BC861DE6977F250/image-size/medium?v=v2&px=400)
//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;