Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samp
Contributor III
Contributor III

JIRA REST API in Qliksense

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_2.png

clipboard_image_3.png

clipboard_image_4.png

clipboard_image_5.png

I can see only blow while try to "Select Data"

clipboard_image_6.png

//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;

 

 

Labels (5)
0 Replies