I've tried so many things... yet I'm still stuck trying to connect to an API that has authentication so here I am. I have some experience with power query, power pivot and data models, but when it comes to APIs and connecting to other external data sources I'm unfortunately a total noob :'(
I'm trying to connect to this API using a query:
I go to "Get data" on Excel's data tab, I click From Other Sources, From Web, Advanced, then I enter the following information (for example):
URL parts: https://www.bitmex.com/api/v1/user
HTTP request header parameters (optional):
(left box | right box)
Accept | application/json
api-expires | 60
api-Key | (my key)
api-signature | (my signature)
this obviously does not work because of my noobness. maybe someone can share some basic guidance?
All I wish for is to access my account's data so I can start transforming and building a data model. Thank you in advanced.
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest