web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / json data turn to arra...
Power Automate
Unanswered

json data turn to array got error

(0) ShareShare
ReportReport
Posted on by

I try all step from here.

 

But I got this error.

CleanShot 2022-08-16 at 13.32.52@2x.png

 

I want to do is call api  https://ftx.com/api/markets

 

Filter all crypto name from json data and then turn it to array.

 

Below is my all step.

CleanShot 2022-08-16 at 13.40.43@2x.png

 

CleanShot 2022-08-16 at 13.40.58@2x.png

Schema

 

{
 "type": "object",
 "properties": {
 "content": {
 "type": "object",
 "properties": {
 "success": {
 "type": "boolean"
 },
 "result": {
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "name": {
 "type": "string"
 },
 "enabled": {
 "type": "boolean"
 },
 "postOnly": {
 "type": "boolean"
 },
 "priceIncrement": {
 "type": "number"
 },
 "sizeIncrement": {
 "type": "integer"
 },
 "minProvideSize": {
 "type": "integer"
 },
 "last": {
 "type": "number"
 },
 "bid": {
 "type": "number"
 },
 "ask": {
 "type": "number"
 },
 "price": {
 "type": "number"
 },
 "type": {
 "type": "string"
 },
 "futureType": {
 "type": "string"
 },
 "baseCurrency": {},
 "isEtfMarket": {
 "type": "boolean"
 },
 "quoteCurrency": {},
 "underlying": {
 "type": "string"
 },
 "restricted": {
 "type": "boolean"
 },
 "highLeverageFeeExempt": {
 "type": "boolean"
 },
 "largeOrderThreshold": {
 "type": "integer"
 },
 "change1h": {
 "type": "number"
 },
 "change24h": {
 "type": "number"
 },
 "changeBod": {
 "type": "number"
 },
 "quoteVolume24h": {
 "type": "number"
 },
 "volumeUsd24h": {
 "type": "number"
 },
 "priceHigh24h": {
 "type": "number"
 },
 "priceLow24h": {
 "type": "number"
 },
 "tokenizedEquity": {
 "type": "boolean"
 }
 },
 "required": [
 "name",
 "enabled",
 "postOnly",
 "priceIncrement",
 "sizeIncrement",
 "minProvideSize",
 "last",
 "bid",
 "ask",
 "price",
 "type",
 "futureType",
 "baseCurrency",
 "isEtfMarket",
 "quoteCurrency",
 "underlying",
 "restricted",
 "highLeverageFeeExempt",
 "largeOrderThreshold",
 "change1h",
 "change24h",
 "changeBod",
 "quoteVolume24h",
 "volumeUsd24h",
 "priceHigh24h",
 "priceLow24h"
 ]
 }
 }
 }
 },
 "schema": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 },
 "properties": {
 "type": "object",
 "properties": {
 "success": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "result": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 },
 "items": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 },
 "properties": {
 "type": "object",
 "properties": {
 "name": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "enabled": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "postOnly": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "priceIncrement": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "sizeIncrement": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "minProvideSize": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "last": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "bid": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "ask": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "price": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "type": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "futureType": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "baseCurrency": {
 "type": "object",
 "properties": {}
 },
 "isEtfMarket": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "quoteCurrency": {
 "type": "object",
 "properties": {}
 },
 "underlying": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "restricted": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "highLeverageFeeExempt": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "largeOrderThreshold": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "change1h": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "change24h": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "changeBod": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "quoteVolume24h": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "volumeUsd24h": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "priceHigh24h": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "priceLow24h": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 },
 "tokenizedEquity": {
 "type": "object",
 "properties": {
 "type": {
 "type": "string"
 }
 }
 }
 }
 },
 "required": {
 "type": "array",
 "items": {
 "type": "string"
 }
 }
 }
 }
 }
 }
 }
 }
 }
 }
 }
}

 

 

CleanShot 2022-08-16 at 13.41.08@2x.png

CleanShot 2022-08-16 at 13.41.15@2x.png

CleanShot 2022-08-16 at 13.41.31@2x.png

 

 

In select output of Apply to each, I chose two "result" that appeared in the list respectively.

 

But all return Null.

 

json data is complicated.

 

I don't know how to filter data that I want.

 

Categories:
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    on at

    Hi @s1021542 ,

     

    I've made a test for  your reference:

     

    1\My Flow

    vbofengmsft_0-1660793039960.png

    2\Result

    vbofengmsft_0-1660873108159.png

     

     

    Best Regards,

    bof

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard