How To Deal With Nested JSON Responses With A Custom Connector?

(0) Share

Report

Posted on by Tman915

I have a custom collector that connects to a REST API. The results of this query have nested JSON in them:

"timeseries": [
 {
 "metadatavalues": [],
 "data": [
 {
 "timeStamp": "2020-07-29T07:00:00Z",
 "total": 905.0
 },
 {
 "timeStamp": "2020-07-29T07:05:00Z",
 "total": 213084.0
 },
 ]
 }
 ],

This is not the full query but when I add this as a response the "timeStamp" and "total" are not being added as tokens so when I try and run the query I am getting this error:

Error details: 'The API operation 'Test' requires the property 'body/value/0/timeseries/0/data/0/total' to be of type 'Integer' but is of type 'Float'.'

As you can see in the image these nested tokens are not here.