Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am loading data from Jira to Qlik Sense via Rest Connector. Basically, I use only one request, where I pull a specific jql search. It works like a charm for most of the extracted fields, but not for "issue links" field. Jira API returns issue links as a nested object in the response. This object is parsed correctly only if the response contains just a few issues (up to 13, not all of them have issue links). Once the response contains higher number of issues, issue links are not parsed by the connector and I only get a "@values" field, which is empty. I need to load thousands of issues.
Does anybody have any idea what could be a root cause for this and how could I load issue links for all relevant issues? Thank you!
When I load only a few issues:
When I load more issues:
Can you post a screen shot of your REST connector settings please juraj.misina
Hello David. Thanks for response, here's the screenshot:
By looking at the documentation more closely (SELECT statement syntax with the REST Connector ‒ Qlik Connectors) I think it has something to do with "ArrayValueAlias" setting, but I'm don't know what exactly. The select statement contains:
[...]
(SELECT
"@Value" AS "@Value_u0",
"__FK_issuelinks"
FROM "issuelinks" FK "__FK_issuelinks" ArrayValueAlias "@Value_u0"),
[...]
So maybe the problem is more with the data itself, possibly an issue containing more issue links so it confuses the connector. I managed to come up with a workaround by creating a connection which worked as I expected (so only a few issues), then I created a select statement and then I updated the connection to include all required issues. So now the select statements has proper select for issue links:
(SELECT
"id" AS "id_u12",
"self" AS "self_u12",
"__KEY_issuelinks",
"__FK_issuelinks",
[several subselects for link type, inward issues, outward issues, status, etc.]
FROM "issuelinks" PK "__KEY_issuelinks" FK "__FK_issuelinks"),
A bit clumsy to come up with but it works.
Qlik Web Connector for Jira works..
Hello Ralf,
yes, this was my first thought when starting the project. However, I've got confused because I did not see Jira connector among beta connectors in my installation. It was out for some time and it came back in later version and I did not check. So I thought, well, maybe Qlik is not developing Jira connector anymore. My bad.
Anyway, this is still not really an option for me until the connector comes out of beta, since beta connectors expire and there's no clear guidance from Qlik... I'd prefer not base production solution on beta connector.
Juraj
Hello, I use the following script for pagination and it works perfect
CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://jira.XXXXX.XX/rest/api/2/search;timeout=30;method=GET;sendExpect100Continue=True;autoDetectR...;
checkResponseTypeOnTestConnection=true;keyGenerationStrategy=0;authSchema=basic;skipServerCertificateValidation=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;
queryParameters=jql%2project%%2XXXXXXX and updated>%%22019-09-01;
PaginationType=Offset;OffsetStartField=startAt;IsOffsetStartFieldHeader=0;OffsetStartFieldValue=0;
OffsetCountFieldName=maxResults;IsOffsetCountFieldHeader=0;OffsetCountValue=1000;OffsetTotalPath=total;IsOffsetTotalPathHeader=0;OffsetDataPath=root/total;
allowResponseHeaders=1;allowHttpsOnly=false;XUserId=WBRXWQZFCLYEHadNTDaOO;XPassword=VQWDXSUEQLYGXZdOPTcIWSIGTabKXcEMTJMATSEGPB;";