topic Re: Sage HR API usage in Developer

Sage HR API usage

PYarwood98 — Mon, 27 Jan 2025 16:19:00 GMT

Has anyone used the Sage HR API in Power BI, and if so can you let me know how I can upload this data into Power BI?

I have tried using the Web API using the API key provided by the software but it not working.

Regards

Re: Sage HR API usage

Anonymous — Tue, 28 Jan 2025 04:47:29 GMT

Hi,@PYarwood98 .I am glad to help you.

I recommend that you use the M-code Web.Contents provided in Power BI to connect to third-party API data sources.
Set the corresponding data source credentials (username &token) in the function
Solved: Using The RelativePath And Query Options With Web.... - Microsoft Fabric Community
Web.Contents - PowerQuery M | Microsoft Learn

Power BI Connector using web connectivity
Solved: Encountering SSL TLS error in web connection - Microsoft Fabric Community
API Reference | Sage Developer
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Sage HR API usage

PYarwood98 — Mon, 03 Feb 2025 16:04:02 GMT

I am struggling to get Web.Content to work as a source in Power BI M Code, I tried the example from the Web.Content learning link above and nothing has happened with the data, see the visual I have based on the example:

The example I used was below:

If I cannot get the examples to work on Desktop I will struggle to get the coding right for the Sage HR API process.

Any ideas?

Re: Sage HR API usage

PYarwood98 — Wed, 26 Feb 2025 11:49:19 GMT

The example I used was below:

If I cannot get the examples to work on Desktop I will struggle to get the coding right for the Sage HR API process.

Any ideas?