Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Community,
I don't have a lot of experience with API's and pulling in data so here is my current situation after researching on the internet.
System: Appointment Plus
API Documentation: https://s24400.pcdn.co/wp-content/uploads/2019/04/TechnicalGuide.pdf
I see that to pull in from an API I need to use the Web Connector in Power BI.
The URL I am pulling from: https://ws.appointment-plus.com/Locations/GetLocations
I see that I need to authenticate somehow. So I tried https://ws.appointment-plus.com/Locations/GetLocationsAuthorization:%20Basic%20USERNAME/PASSWORD
With my username and password in there but it is not working.
Would anyone be able to help me out with getting the https part to work?
after that I dont know how to connect it using PowerBI, how come support team didnt answer this?
you need a base64 encoder to encode the user id and pw, on their page:
All requests require a Basic Auth header that contains the Base64-encoded string representing your username (site_id) and password (api_key) values as explained below.
Authorization: Basic < Base64-encode(site_id:api_key) >
Note that some tools like Postman can do this Base64-encoding for you automatically.
Example:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |