Hey! Is there any way I can just get a bulk download of my roasts showing roast name, date and volume roasted? At the moment I just have to manually type each one in for the purpose of batch tracking and accounting etc and wondering if there’s an easier way!
Thanks!
You can in fact do that, but it is a bit convoluted, so you will have to fiddle a bit to make it work. In Excel in the Data tab you use Get Data and there pick From Other Sources and there From The Internet (paraphrasing here, sorry). Now you will get a dialogue saying From Web with a Basic and an Advanced option. Pick the Advanced one.
In the URL you enter “https://api.roast.world/api/v3/public/roasts” and in the Headers you enter “x-api-key”. Next to the Headers input box, there is another input field. There you enter you API key*) and possibly have to click Add Header (I don’t remember if that matters).
If you get a server error 500 or similar, you likely made a typo which is easy to do here.
Power Query (which is pretty much identical to what you have in Power BI), is a bit of a monster to master. So this is filled with little potholes you can stumble in. But what you talk about here is in fact doable this way. Be patient and don’t expect to get it the first time around.
See Aillio Public API for information on the API you are using here.
*) The API key is a personal secret you create in your Roast.World settings. Click you avatar in the top right and select Settings and from the menu you then get, pick API Keys and now you can create a key. This is basically a way to impersonate you, so keep it for yourself. If you think you have leaked it somewhere, just go in and delete it and create a new one.