RaaS report for Workday

[CelesteGro]

We currently have a Workday Integration that uses the "Run Workday Integration Flow". This flow does not include the department manager from Workday. We created a RaaS report in Workday to retrieve this information. How do I retrieve the RaaS report in ServiceNow? 

[Jordan Vignoni]

You can setup the outbound EIB in Workday, and create a Scripted REST API in ServiceNow that sends the data to an import table that will transform the data into the destination table.  I have done this to send, for example, supplier and customer information from Workday to the core_company table in ServiceNow.

[CelesteGro]

Thanks! Do you happen to have an example of this solution? 

[Jordan Vignoni]

In my case, the data was sent from Workday as JSON and the information below references that solution.  Hopefully, this helps get you going in the right direction.

ServiceNow

1. Create a new inbound web service and select the target table.  You will need to specify the fields coming from Workday.  The “Name” is the XML Alias from the RaaS in Workday.
   • Add an extra field called “JSON Payload”.
2. Create a transform map from the web service and map to the fields on the target table.
3. Create a new Scripted REST API and enter the “Name” and “API ID”.  The “API Base Path” will be populated automatically.  These can be named whatever you want.
4. On the “Resources” related list, create a new “POST”, and enter a script to receive the incoming data and post it to the import table.
   • The script should parse the JSON, and then post it to the “JSON Payload” field on the web service created in Step #1.
5. Create a service account that will be used to process the API.

Workday

1. Create the outbound EIB using the RaaS and choose JSON as the output format.
2. Enter the API Path from ServiceNow into the HTTP Address of the outbound EIB and enter the credentials of the service account.
3. Create a schedule for when the outbound EIB should run (i.e., daily, weekly, etc.).

[CelesteGro]

Thank you so much! I will give this a try and let you know if I get it to work.