workdayr

Query Workday with R!

Installation

# install.packages('devtools')
devtools::install_github('blakiseskream/workdayr')

Functions

There is only one!

Query a Workday report via the Workday Report as a Service API.

Have a Workday report you want to query easily? Read up on the Workday RaaS via this documentation here. You can pull down Workday reports in a variety of formats including csv, json, xml (why would you do that), Excel, etc.

Function works like this

# Get report raw data
report_path <- get_workday_report(
  report_name = 'report_owner/workday_headcount_report', 
  username = 'api_user', 
  password = 'api_password', 
  params = list(Effective_as_of_Date='2018-10-01-07:00',format='csv'), 
  organization = 'my_organization',
  filepath = tempfile(),
  overwrite = TRUE
)

# read it in as a tibble
report <- readr::read_csv(report_path)

There is an option parameter added for endpoint if you have a custom end point for the Workday RaaS,

# Get report raw data
report_path <- get_workday_report(
  report_name = 'report_owner/workday_headcount_report', 
  username = 'api_user', 
  password = 'api_password', 
  params = list(Effective_as_of_Date='2018-10-01-07:00',format='csv'), 
  organization = 'my_organization',
  filepath = tempfile(),
  overwrite = TRUE,
  endpoint = 'https://services1.myworkday.com/ccx/service/customreport2/'
)

Ta da!

Have fun.