Accessing Workday Data with SAS

[jkotek]

Good morning, I'm looking for a way to access Workday data directly from SAS. Any help would be appreciated.

Thanks,

Jeff

[ballardw]

Since there really isn't any truly standard "workday" definition you will need to provide what your definition of "workday" is for your project.

Pieces likely to be involved: day of week can be retrieved from a SAS date value, specific holidays can also be determined from SAS date values though non-US holidays require additional work to set up.

[ChrisHemedinger]

I believe that Workday has APIs you can use. Using PROC HTTP you can call those APIs, similar to the way you might use cURL.

It looks like the Workday API documentation is restricted to verified customers/developers, so you may need to create a community account at 
https://community.workday.com and be approved for access. Since I cannot see the doc, I can't provide better guidance/examples.

I suspect one of the biggest initial challenges will be authentication. Most enterprise-style APIs will use OAuth2 or similar mechanism to get an access token and refresh that token for new access every time you use it. We have several examples of that type of interaction (ex: How to use SAS to access Microsoft 365 ).

[Reeza]

Workday data lives in the cloud and is relational IIRC. We're having our IT team build some data layers for us from the data to then surface on Azure.