Connecting from Excel to the SeaTable API with PowerQuery

Our Org is large and not always innovation friendly and we have quite a few edge cases where syncing data to Excel would be beneficial (think: Mail merge with Excel + Word). Therefore I am trying to connect MS Excel to our self-hosted Seatable-Instance with PowerQuery. I aim to create a template file file where users only enter the Server domain, AP Token and Name of the Table they want to connect to and then the data of that Table gets loaded into Excel. I have seen modest success up to access-token generation but I get stuck after that.

Does anyone maybe have an example file that I could build upon?