Retrieve Custom Reports in CSV Format Using RaaS

This section provides an overview of creating an integration that uses the Reports as a Service (Custom Reports) Workday API and its operations to retrieve custom reports in CSV format.

To perform this operation, you create Workday Adapter and FTP Adapter connections in Oracle Integration.

1. Create an application integration.

2. Drag a REST Adapter connection into the integration as a trigger connection.

3. Configure the REST endpoint.

4. Drag a Workday Adapter connection into the integration canvas.

5. Configure the Workday Adapter as follows:

   1. On the Basic Info page, provide a name.
   2. On the Action page, select Extract Bulk Data from Workday.
   3. On the RaaS Services page, select Reports as a Service (Custom Reports) as the type of Workday report, and select a report.
   4. On the Summary page, review your selections.
6. Perform the required mapping.
7. Drag a stage file action into the integration canvas below the Workday Adapter. The stage file action reads the CSV format data downloaded to Oracle Integration.
   1. On the Basic Info page, provide a name.
   2. On the Configure Operations page, select Read Entire File from the Choose Stage File Operation field.
   3. Specify the XPath for the file name in the Specify the File Name field.
   4. Specify the directory name in the Specify the Directory to read from field.
   5. On the Scheme Options page, select Yes in the Do you want to specify the structure for the contents of the file? field and select Sample delimited document (e.g. CSV) from the Which one of the following choices would be used to describe the structure of the file contents? list.
   6. On the Format Definition page, click Choose File and upload the CSV file to create a schema in the Select a New File field.
   7. Enter the record name, enter the recordset name, select the field delimiter (for example, Comma), and perform other required details.
   8. Review your selections on the Summary page.

   Note:

   To process the data, users should add the required headers in the CSV file.
8. Drag an FTP Adapter below the stage file action to write the file to a target FTP server.
9. Specify the following details in the Adapter Endpoint Configuration Wizard.
   1. On the Basic Info page, provide a name.
   2. On the Operations page, select Write File from the Select Operation list.
   3. Select Binary from the Select a Transfer Mode list.
   4. Specify the output directory (target FTP server location) and file name pattern.
   5. On the Scheme page, select Yes in the Do you want to specify the structure for the contents of the file? field and select Sample delimited document (e.g. CSV) from the Which one of the following choices would be used to describe the structure of the file contents? list.
   6. On the File Contents-Definition page, click Choose File and upload the schema source file in the Select a New File field.
   7. Enter the record name, enter the recordset name, select the field delimiter, and perform other required details.
   8. Review your selections on the Summary page.
10. Perform mapping between the stage file action and the FTP Adapter.

    The completed integration looks as follows.