Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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