Workday can create custom reports that can be accessed via URL and are provided as CSV, JSON, even RSS or XML.
I would like to build an import from such a report. Obviously I need the authenticate myself to Workday, as the data is not freely available.
Can this be done natively? Or do we need to write some scripts using Asset APIs?
We don't want to use marketplace apps.
Here is one option you can take a look:
1) Write a Workday EIB that points to your custom report and saves the results as CSV in a specific folder. You can then schedule the EIB to run on a specific interval.
2) Use the Data Manager Client to load the CSV output to the specified Assets schema.
3) Write a script to automate steps 2.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.