I have Google Sheets functions that parse json and Import to Google Sheets, you can find the code for the function in IMPORTJSON file. The functions is pretty simple and self explanatory.
Following Formula using function in google sheets get the result as "[login to view URL]"
=IMPORTJSON("[login to view URL]","financials/0")
I Want to the results as displayed in [login to view URL]