Workday get report action

Use the Workday - Get Report action to retrieve a report using the Report URL. Workday Reports-as-a-Service (RaaS) is a feature that makes reports available as web services. While you are creating these reports in Workday, you must configure them as Advanced type reports to be web-service enabled.

Prerequisites

Note: The examples and graphics provided on this page are for representation purposes only and may not accurately reflect your specific instance. We do not assume responsibility for their maintenance or accuracy.
Ensure that you are authenticated before initiating any Workday action. For more details, see Workday Authentication action. Below are the prerequisites for the Get Report event:
  • Log in to the Workday as an admin. For more information on logging in to a Workday instance, see Workday Login.
  • To find the report URL, click the horizontal three dots and navigate to Actions > Web Service > View URLs.

    Workday View RAAS URL

    The View URLs Web Service page appears.

  • Right-click Workday XML and select Copy URL.

    Workday Copy URL

Procedure

  1. In the Automation Anywhere Control Room, navigate to the Actions pane, select Workday > Get Report, and place it in the canvas.

    Workday Get Report
    1. Paste the Report URL copied from Workday. The copied report URL is the report you want to get from Workday in Automation 360.
    2. Select the Report Format. Automation 360 supports Simple Xml and Workday Xml formats. Workday Xml contains more data elements (for example, WID (Workday ID)) than the Simple Xml.
    3. Enter Default as the session name.
    4. Save the outcome to a variable. For example, you can store all the lines of the report in a list (listReportData)
  2. To verify that you can run the bot in Debug mode, set a breakpoint action next to Get Report. In the previous example, there is a Message box action. Open the listReportData variable to view the results.
    Note: The output is retrieved as a list of type Dictionary. To read an individual record (row) in this list, you need to loop through all the dictionary items using the Loop action and read or extract the records (rows) individually. For example, the output of get multiple records is saved in the variable list_of_records_any. If the variable contains five records, then each record is passed to the Loop action to be processed one at a time.Loop action for get multiple records