1 Reply Latest reply: Sep 21, 2017 8:44 AM by Fabiano Nascimento Leite RSS

    QLIK Desktop doesn't map json field correctly from JIRA

    Fabiano Nascimento Leite

      Hello,

      I'm studying Qlik Sense Desktop and I'm generating charts from JIRA cloud (REST). The basic datas such as issues, priorities, status, etc are working. However there is a field (customfield type select list) that didn't map.

      See below.

       

      The following Json code was extracted using JSON Viewer from Chrome, accessing link:

       

      "https://xxxxxxxxxxxxxxxxxxx.atlassian.net/rest/api/2/search?fields=*all,-comment,-description,-avatarUrls,-iconUrl,-avatarId&startAt=3000&maxResults=1000&jql="

       

      The customfield values, almost all them are null, but when I change the page the datas from field appears. (I using offset configuration for pagination and this config it's works).

       

      (...)

      "customfield_11001": {

                "self": "https://xxxxxxxxxxxxxxxxxx.atlassian.net/rest/api/2/customFieldOption/10622",

                "value": "Homologação",

                "id": "10622"

              },

      (...)

       

      The Qlik should be shows that field with three columns, but anyway it didn't get mapping all of datas.

       

      See the imagem below.

      Qlik - print - customfield.PNG

       

      Note: I using the option "no limit" from field "preload symbols count"

       

      Thank you in advanced

       

      Mensagem editada por: Fabiano Nascimento Leite