Create REST Adapter Connection:
1. Select Connection Type: REST API Base URL
2. Connection URL: https://wd2-impl-services1.workday.com/ccx/api/v1/<tenant>
3. Select Security Policy as: OAuth Custom Two Legged Flow and provide below details:
- Access Token Request:
-X POST -H “Content-Type: application/x-www-form-urlencoded” -d “grant_type=refresh_token&refresh_token=<refresh_token>&client_id=<client_id>&client_secret=<client_secret>” https://wd2-impl-services1.workday.com/ccx/oauth2/<tenant>/token
Create Integration:
- Select Scheduled Orchestration Integration Pattern in OIC.
- Drag and drop Configured Rest Adapter Connection,
Steps to configure:
- Provide URI to Get the Custom Objects:
/workers/{workerID}/customObjects/highPerformerStatistics
- Select GET action.
- Select Add and review parameters for this endpoint from available options.
- Select Configure this endpoint to receive the response from available options.
- On Response Page, Select JSON response payload format and JSON media type and enter sample JSON.
- Provide WorkerID in the mapping.
- Drag and drop FTP adapter to write data to a file.
Steps to configure:
- On the Basic Info page, provide a name.
- On the Operations page, select Write File from the Select Operation list. Select ASCII from the Select a Transfer Mode list.
- Specify the output directory, file name pattern.
- On the Scheme page, select No for Do you want to specify the structure for the contents of the file?
- Review your selections on the Summary page.
- In the mapper, do required mapping.
- Specify the tracking variable.
- Click Tracking.
- Drag the required variable to use for the tracking reference (for this example, startTime is selected).
- Activate the Integration.
After successful activation, you can submit the integration and monitor the runtime in Oracle Integration.