BookmarkSubscribeRSS Feed
jkotek
Calcite | Level 5

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

Thanks,

Jeff

3 REPLIES 3
ballardw
Super User

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
Community Manager

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 ).

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
Reeza
Super User
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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1715 views
  • 0 likes
  • 4 in conversation