This type of question has been asked a number of times. Explanation in detail is not typical as this deals with creating macros specific to your needs and best done in Python. For further information, please see my answer in this post → link libre base to API on a website,. In the answer are links to other answers some containing code.
Have carried this one step further. Attached is a sample Calc file with the python macro embedded in the document. It utilizes the API in your question. It is executed by a push button on the sheet. This recalls the data and the results are placed in column B. I did not format any results. In some cases I don’t even know or care what they are.
Sample — BTCpython.ods
The python code is overly simplified so as to be somewhat readable for those unknowing. It accesses the data, converts it to a string which is then read in JSON format into data fields. The active sheet in Calc is used and one-by-one the data is moved into cells.
The actual Python code is just a text file named
JsonBTC3.py. The macro the push button is connected to is
json_btc. It was inserted into the document using APSO; see this post → Did you know that you could also use APSO to Organize your Python scripts within LibreOffice?. I have created a small manual for embedding the script in a document using APSO; it is in my answer here → Can I embed python script and integrate with basic? (solved)
Going beyond this creates too many ifs ands and where by’s.