Forum Discussion
Connecting to Paylocity
Hi, I am curious if anyone has connected PowerBI to Paylocity. I have been using PowerBI by connecting it to our erp system (using an ODBC) but have been struggling to find a way to connect Paylo...
I'd be interested as well, woud love to incorproate ADF into our processes if it expedites connectivity with Paylocity for Power BI
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.
