Skip to main content
Community site session details

Community site session details

Session Id : oM15CjF8WkWM4Gfh68/V1Z
Power Automate - Using Connectors
Answered

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

Like (0) ShareShare
ReportReport
Posted on 29 Jul 2020 09:17:59 by 24

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.

 

Response.jpg

 
  • Verified answer
    abm abm Profile Picture
    32,506 Most Valuable Professional on 29 Jul 2020 at 20:26:49
    Re: How To Deal With Nested JSON Responses With A Custom Connector?

    Hi @Tman915 

     

    Looks like you have duplicated the post

     

    https://powerusers.microsoft.com/t5/Connecting-To-Data/Dealing-With-Nested-JSON-Response-In-A-Custom-Connector/m-p/641700#M9525

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Featured topics

Loading complete