Hi Dave, I don't know if you managed to set up your API but if you haven't or theirs anyone stumbling on this post, @Ian Brierley has produced some incredibly useful documentation videos on how to do it. (they have literally carried me though the set up process cause our business partner wanted to charge several hundred just to set up the API) but:
1. Onboarding:
2. Power BI (I personally did not use this video as it wasn't needed)
3. The most useful one in terms of actual API set up and sanity checking
Hope this helps either yourself or future people coming here 🙂
