Unable to display data returned from Jenkins

[grafana]

Unable to display data returned from Jenkins

[marcusolsson]

Oh! That's indeed something I can fix! 😅

[kalpik]

Here you go:

URL: https://my-jenkins-instance.com/job/Cloud/job/attempt_iqa_promotion/job/develop/api/json

Query Parameters actual (which broke): pretty=true&tree=builds[number,result,url]{0,10}
URL Encoded (which work): pretty=true&tree=builds%5Bnumber%2Cresult%2Curl%5D%7B0%2C10%7D

Note that if I also encode '=' and '&', it doesn't work again. So only some parts need to be URL encoded.

[kalpik]

Thank you :)

[kalpik]

If I only have $.builds[*].number, it shows the build numbers, but somehow I cannot display result.

$.builds[*].result shows an empty table.

[marcusolsson]

The JSON you posted seems to work for me:

The error you get tells me that the result of each query don't contain the same number of rows. I'm guessing that one of the number and result properties is sometimes missing from the builds.

[kalpik]

Thanks for your reply. That's what I thought as well, but I just cannot get any result to show! Even if I do $.builds[0].result, I get nothing. I can get $.builds.[0].number. So really not sure what's happening here. I checked the response from the Jenkins API, and it has both number and result for all elements, the JSON I posted above is directly from the Jenkins API. So kind of strange it works for you, but not for me!

[marcusolsson]

I'm not sure either why it's failing for you. Could you perhaps send me the result from the Query inspector. That way I can be sure we're looking at the same data.

1. Click the Query inspector button in the upper right corner of the query editor
2. Click Refresh to make a new request
3. Click Copy to clipboard
4. Paste it in this issue

Make sure that the request doesn't contain any sensitive information before pasting it

[kalpik]

Thanks. But that's the other thing. In query inspector, when I click refresh, it keeps loading, which I again found to be strange.

Keeps being stuck on this:

[kalpik]

Okay, figured it out. I need to pass the URL query parameters URL encoded, else it doesn't work. Maybe something you can fix? :)

[marcusolsson]

Can I ask you to provide the query parameters that broke things for you, what you had to put in there instead?

[jimbrzk]

Hey i have the same situation and my URL dose not need to be encoded (http://api.gios.gov.pl/pjp-api/rest/station/findAll)
Sample JSON (Not form Jenkins but same situation):

[
    {
        "id": 114,
        "stationName": "Wrocław - Bartnicza",
        "gegrLat": "51.115933",
        "gegrLon": "17.141125",
        "city": {
            "id": 1064,
            "name": "Wrocław",
            "commune": {
                "communeName": "Wrocław",
                "districtName": "Wrocław",
                "provinceName": "DOLNOŚLĄSKIE"
            }
        },
        "addressStreet": "ul. Bartnicza"
    },
    {
        "id": 117,
        "stationName": "Wrocław - Korzeniowskiego",
        "gegrLat": "51.129378",
        "gegrLon": "17.029250",
        "city": {
            "id": 1064,
            "name": "Wrocław",
            "commune": {
                "communeName": "Wrocław",
                "districtName": "Wrocław",
                "provinceName": "DOLNOŚLĄSKIE"
            }
        },
        "addressStreet": "ul. Wyb. J.Conrada-Korzeniowskiego 18"
    }
]

When I query for single value it's working fine, but when I add more there's "Fields have different lengths" error showing.
It is only appeared when I trying to querying multiple fields.

Working

Working

Not working

[marcusolsson]

@kubala156 I can reproduce it the JSON you've sent me. This is the result from the data source.

$.[*].id matches recursively (just learned this myself), which also adds the city ID to the id values. I fixed it by changing it to $.[:].id. We should document this in the README, but I need to read up on it a little more.

[
  {
    "name": "id",
    "type": "number",
    "values": [
      114,
      117,
      1064,
      1064
    ]
  },
  {
    "name": "stationName",
    "type": "string",
    "values": [
      "Wrocław - Bartnicza",
      "Wrocław - Korzeniowskiego"
    ]
  },
  {
    "name": "gegrLat",
    "type": "string",
    "values": [
      "51.115933",
      "51.129378"
    ]
  },
  {
    "name": "gegrLon",
    "type": "string",
    "values": [
      "17.141125",
      "17.029250"
    ]
  }
]

[marcusolsson]

Closing this with a fix for @kalpik's issue where query parameters aren't encoded properly.

[marcusolsson]

Fixed in v0.6.2.