not an issue, just asking for help !

qeet / IMPORTJSONAPI

Use JSONPath to selectively extract data from any JSON or GraphQL API directly into Google Sheets.

MIT License

252 stars 36 forks source link

not an issue, just asking for help ! #35

Open gadget78 opened 3 years ago

gadget78 commented 3 years ago

how can i retrieve the value of ELS from this query...

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

been trying so many different ways, nothing seems to work ! and im sure that it is possible ! i couldn't find a link to any documents on using the query function ? many thanks for ANY pointers !

qeet commented 3 years ago

Try this:

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

gadget78 commented 3 years ago

YES !!! thankyou... that worked .. i can see HOW and why now... easy when you shown hey ! Thank you so much, from the crypto world of XRP !