Azure Data Factory/Deputy Payroll Connection with permanent/anonymous token?

Question

First question - is it possible to access Deputy Payroll API with only the permanent/anonymous token? If not, probably don't need to read the rest.

I have been tasked with moving data from a Deputy Payroll API to an Azure SQL DW.

I am trying to accomplish this without OAuth2.0 or Azure/Deputy Integration

According to Deputy's documentation you can connect via Permanent Token.

I have used permanent tokens before and REST but I am getting different behavior.

When I ping the Subdomain for the base deputy URL (https://business.na.deputy.com/) it returns an object with 2 points that look like the following;

   "Noshido__LK":"Ad8f......yd78y="  

When I ping the payroll api (https://business.na.deputy.com/api/v1/resource/TimesheetPayReturn) using the token it, Data Factory tells me that I 'need to use Login, OAuth2.0, or Bearer'.

I am not familiar with these type of connections, and am hoping to work within the parameters.

Thank You!

Answer 1

This website has a nice little guide to using OAUTH2 with Azure Data Factory. It looks like they use a Web POST method to get the access token.

https://www.alexvolok.com/2019/adfv2-rest-api-part1-oauth2/