qeet

Something like this should do the trick: `=IMPORTJSONAPI(, "$..*[?(@property === 'ProductsId')]^", "OrdersId, ProductsId, ProductsTotal")`

There is currently not a syntax that will work for both. The only way I can think of to do this is to have two columns that handles each case:...

In theory you should just be able to call IMPORTJSONAPI from the onOpen trigger so that the import is run everytime you open the sheet: ``` function onOpen(e) { //...

Try this: `=importJSONAPI("https://data.ripple.com/v2/accounts/rNJYAGgWCn6PcpNAaMnXWikn9eGbUkkMu5/balances", "$...balances[[?(@property==='currency' && @.match('ELS'))]^", "@`

Sorry but there is no support for wildcards in column paths.

Thanks for the feedback! As to your question you can't do this at the moment but it is something that could be added. I'll need a few days to think...

You need to have all blank cells below and to the right of the formula where the results will go. See here: https://webapps.stackexchange.com/questions/108918/importxml-shows-array-result-was-not-expanded-because-it-would-overwrite-data-i This is not an issue with IMPORTJSONAPI...

To match only part of a property name you need to use the match function. Hopefully this should work for you: `=ImportJSONAPI("https://www.alphavantage.co/query?function=TIME_SERIES_MONTHLY_ADJUSTED&symbol=IBM&apikey=demo", "$[Monthly Adjusted Time Series][?(@property.match(/2019/))].[7. dividend amount]", "^~, @")`

I think the best thing to do is first retrieve all the raw data in one tab: `=IMPORTJSONAPI("https://api.huobi.pro/v2/reference/currencies","$.data[*].chains[*]", "^^currency, depositStatus,^^instStatus")` Now in another tab use the QUERY function to filter...

Actually you can do it all with a single statement: `=QUERY(IMPORTJSONAPI("https://api.huobi.pro/v2/reference/currencies","$.data[*].chains[*]", "^^currency, depositStatus,^^instStatus"), "select Col1, Col2 where Col3 = 'normal' and Col2 != 'prohibited'")`