Qlik Sense Rest API Connector for Jira/Getting custom fields with their names from jira to Qlik

[Qlik-Developer]

Hi Everyone,

Good Evening,

My source is jira, Loaded data from Jira through REST API into qlik sense, while loading Issue table custom fields are loading into Qlik like Custom filed ids as lable, so its difficult to identify what is the actual filed name from jira.

Due to requirement in project few field were added in Jira by Jira developer those fields called custom fields. These newly added fields by Jira developer are coming into qlik as custom filed with id (ex: custom field 250,custom filed 340).

While creating the REST connection defined the filed names in the parameters, even though custom filed with ids are loading.

Do i missed something while loading,please help on this.

Thanks in Advance!!!!!!!!!!!

Varsha.

[stevedark]

Unfortunately this is not straight forward. If there is no data in a particular bucket it will not exist in the datamodel and therefore can not show.

The only way around this is to concatenate dummy rows onto the dataset with include zero values in each of the buckets you wish to show.

You then need to add to the expression a calculation that uses set analysis {1} multiplied by zero to return zero in every bucket, then you need to ensure that show zeros is switched on for the chart. So, you would end up with something like:

sum(Defects) + (sum({1}Defects)*0)

It's a bit of a nasty kludge, but it should work.

Steve

[chrisbrain]

This is a long thread and I have not read it all but it might be useful for some viewers to know that a new 'Custom Field IDs' parameter has been added to the Issues table in the JIRA Qlik Web Connector which also makes these custom fields a little easier to access.

[Qlik-Developer]

Hi Chrisbrain,

How can i extract only selective Columns from jira instead of 78 columns,in custom filed ids i have mentioned "Id " but extracted 78 columns instead of" id'.

[Qlik-Developer]

Hi,

I have installed web connectors on my desktop and qliksense is in server,i was trying to add the Qlik Web Connectors as a Windows service but when i try to run the batch files throwing this error.

How can i run as backend service.

[stevedark]

It's likely that all the information you need is on that screenshot.

Most likely that the batch file needs updating to have the correct paths put in. 

Typically I run QWC on the same server as Sense, as otherwise you will hit other configuration and access snags. 

Good luck. 

[chrisbrain]

@Qlik-Developer The format of the entries here is as per the pop up notes:

So your ID looks wrong.

[Qlik-Developer]

Hi @chrisbrain ,

My question is How can i extract only selective Columns from jira instead of 78 columns(when i select project nd  jql query) 78 columns were extracting how can i extract only selected syatem fileds?

[chrisbrain]

@Qlik-Developer  - The Issues tables has the 78 columns built into it - if you don't want them in your app you can just comment out the ones you don't want or use 'drop field'.

You can use the 'Custom field IDs' parameter to add additional columns to this default set by entering a comma separated list.

[Qlik-Developer]

HI @chrisbrain ,

No way to extract only choosed fields from jira itself?instead of loading all the fileds and commenting or dropping off in qlik?

one more thing is how to create connection in qlik?

i tried like created connection  connection url:  https://servername:5555 and connection name:Testconnector in web file.

after that i created variable at top of script :  let vQwcConnectionName= 'lib://Testconnector' not connecting

                                                                                            let vQwcConnectionName='https://servername:5555' not connecting can u suggest how can i create connection?

[Qlik-Developer]

HI @stevedark ,

we have installed on server but with out using license key  we can see jira web connector under standard connectors is this correct? but we are having free license for one month from client how i can check whether its working or not, no were asked for license key even while installing or after installation