IMPORTJSONAPI icon indicating copy to clipboard operation
IMPORTJSONAPI copied to clipboard

Published 20 hours ago • verified publisher icon qeet

not an issue, just asking for help !

Open gadget78 opened this issue 4 years ago • 2 comments

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 !

gadget78 avatar Sep 04 '21 09:09 gadget78

Try this:

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

qeet avatar Sep 08 '21 12:09 qeet

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 !

gadget78 avatar Sep 08 '21 21:09 gadget78