Description: REST is far more popular than SOAP nowadays, and it's time to have a FILTERJSON function equivalent to FILTERXML. Steps to Reproduce: The vast majority of REST APIs return JSON data. Actual Results: FILTERJSON (or "PARSEJSON") could use dotted notation to extract object fields. Expected Results: A1: =WEBSERVICE("https://api.github.com/repos/DmytroBazunov/LibreOfficeGetRestPlugin/issues/6") B1: = PARSEJSON(A1, "user.login") // "dandv" Reproducible: Always User Profile Reset: No Additional Info: There's a poorly maintained plugin that attempts to do this, https://github.com/DmytroBazunov/LibreOfficeGetRestPlugin/issues/6 User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36
Implementing this will be possible with the nearly-ready dataprovider: https://cgit.freedesktop.org/libreoffice/core/tree/sc/source/ui/dataprovider
Nice, I see very recents commits. As extra motivation, I was trying to extract Bitcoin prices from this API, =SUBSTITUTE(WEBSERVICE("https://min-api.cryptocompare.com/data/pricemulti?fsyms=BTC,ETH,LTC&tsyms=USD"), """:{""USD""", "") The SUBSTITUTE above is just prep. After that, to get at a value, I came up with a formula looks like this: =VALUE(MID(A1, SEARCH("(?<=BTC:)\d", A1), FIND("}", A1, SEARCH("(?<=BTC:)\d", A1)) - SEARCH("(?<=BTC:)\d", A1))) A week later, that thing above looks more cryptic than elliptic curve cryptography :) I have no idea what it does at a glance and why it's so repetitive.