I try all step from here.
But I got this error.
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.
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"
}
}
}
}
}
}
}
}
}
}
}
}
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.
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional