Forum Discussion
Connecting to Paylocity
I was able to connect to paylocity using a web call in an ADF Azure pipeline that loads the data into a sql server db then I have power bi connected to sql server db. I used postman to test the authentication and api calls. I can post some steps later if anyone is interested.
I'd be interested as well, woud love to incorproate ADF into our processes if it expedites connectivity with Paylocity for Power BI
- We have successfully connected Paylocity to SQL Server / Power BI / MS Azure Analysis Services. Please let me know if you are interested in having us provide this integration effort. It was not easy but is now given we have done the effort a number of times.
I will need to create a blog post but here is the shortened version.
In my paylocity Pipeline I first call my RefreshToken pipeline
It has 4 web API calls, the first two web calls get the ClientId and ClientSecret from Azure Keyvaults. The third call Post to
https://api.paylocity.com/IdentityServer/connect/token passing in the clientID and ClientSecrets. The fourth web call updates the accesstoken in Keyvaults with the returned value of the third web call.Once the token is refreshed I get the updated Access token from Keyvaults and use it in my copy data activity to get Emloyee id's and save them in a SQL DB.I am not sure if this is the most efficient way but it is secure and i make sure to always check the Secure input and output. Once I have time to get this fully documented I wll add a link here.
