When querying a datasource that returns the following structure, the JSON API give the “Fields have different lengths” when set the field JSONPath selectors to “.devices[*].name" and ".devices[*].swVersion” { “request”: { “url”: “api/datasources/proxy/6/topology/devices?detail=1&fields=name%2CswV…

Good to know. I bet that’s the problem. I only gave you the first returned object in the array. The second object does have a null value for the “swVersion”. { "devices": [ { "swVersion": "6.60A.274", "ipAddress": "192.168.200.30", "name": "MP114_v2", "id…

Would it be possible to put a check in the module to convert null to an empty string “”?

It’s a trickier problem than it may seem unfortunately. The problem is that if a property doesn’t exist, JSON Path ignores it. To illustrate the problem, here are three separate queries: Since name exists in each object, no problem. You get three strings back. [CleanShot 2021-02-11 at 19.08.08@2…

Actually, looking at your example again, I see that it does have a null value, meaning it should work. I’ll get back after I’ve tested it.

Just verified that it works if there are null values rather than missing values. [CleanShot 2021-02-11 at 19.28.33@2x]

It’s not working for me. Not sure what the problem is. I should be running the latest version.

I see the issue. There is an object in the returned array that is missing the parameter. I’ll see if i can create a query to filter that out. Many thanks for your responses. { "swVersion": null, "ipAddress": "172.16.1.5", "name": "Test_Device_5", "id": 3832, …

No worries at all. Thanks for using the plugin! If you run into any issues down the road though, I’m more responsive on the GitHub project page .

Perfect, thank you! I have it working now. I was able to apply a filter to the REST API server to remove the objects that have the missing parameter. The plugin is working very well. Thanks again.

JSON API datasource returning "Fields have different lengths" error

Grafana

marcusolsson February 11, 2021, 4:35pm 2

Hi, I’m the author of this plugin. I’m able to query the data you provided:

Most likely, the error you’re getting means that one of the devices are missing either the name or the swVersion. Detecting null values is currently not possible.

Topic		Replies	Views
JSON API Fields have different lengths Grafana api , json-api-datasource , json	3	1789	June 7, 2022
Getting error “fields have different lengths” Grafana plugins , json-api-datasource , dashboard	0	386	December 15, 2023
How to default a missing value in a JSON API call using JsonPath? Grafana stat-panel , json-api-datasource	3	3911	October 29, 2021
Getting error "fields have different lengths" Grafana Plugin Development	0	319	December 12, 2023
How can I get a field when I use JSON api whith more than one field? Grafana json-api-datasource , json , dashboard-variables	1	576	November 11, 2023

JSON API datasource returning "Fields have different lengths" error

Related topics