I have been given API documentation to connect to one of the services we use with an API. I have managed to do this using the command prompt on Windows and CURL commands and can see the data that I need to.
To connect though I have to authenticate first and then use a token that lasts only an hour to query the data.
Ideally I need to be able to bring this data into Power BI so that we can present it, but have no idea how I could connect Power BI to the service using the same sort of CURL commands.
For example, this is the CURL command I am using to request the token,..
curl --request POST --url https://xxxxxxxx.xxxxxxxx --header "Content-Type: application/json" --header "Accept: */*" --data "{\"username\":\"xxxxxxxxxxxxxxx\",\"password\":\"xxxxxxxxxxxxxx\"}"This then returns the token which I then add to the other CURL commands to interogate the data.
Are there any resources out there which will help me turn what I have above into something that allows Power BI to interogate the data?
Haven't a clue where to start, so any help would be greatly appreciated.
