Importing into Google Sheets
ยท Test out the query at https://api.bogged.finance and when you are happy, copy the Request URL. It will look something like this:
https://api.bogged.finance/v1/top_exchanges?chain=bsc&api_key=<your api key>
ยท Create a new Google Sheet
ยท Select Extensions --> Apps Script
ยท Delete the existing content of the script
ยท Copy the code from this script on Github into the script editor
ยท File --> Save
ยท In cell A1, type the following and press enter:
=ImportJSON("<your request url>", "/data", "noInherit")
ยท You should see the query data returned as rows:
Last updated