not an issue, just asking for help !

[gadget78]

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]

Try this:

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

[gadget78]

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 !