• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
Solution home App Resources Workday

Workday Report as a Service Setup

Modified on: Mon, Jun 5, 2017 at 11:52 PM

Report as a Service

Custom Reports

Custom Reports (advanced type) can be exposed as a Web Service to be used programmatically.


How to find JSON endpoint

Find URL in Actions > Web Service > View URLs > JSON (right click and choose "Copy URL")


Filter parameters

Prompts behave like request parameters. In the UI, it is presented as input fields before generating actual report. As a REST endpoint, these prompts are passed as request parameters.


Report User Interface



JSON Example

https://wd2-impl-services1.workday.com/ccx/service/customreport2/workato/workato/Investors?format=json&Worker_Type!WID=d588c41a446c11de98360015c5e6daf6&Base_Pay=0


Basic Setup

Report type

Switch to advanced type if not already. Only Advanced custom reports can be used in RaaS.


Add prompts

  • Add all default prompts that are required of web-service-enabled reports

  • Add additional prompts desired



In this example, Base Pay is assigned to Prompt Qualifier as Prompt #1, which will be used in filters.

Apply logic to filter prompt values

Use values from Prompt to compare against report column values. Example, assign Prompt parameter Base Pay as Prompt #1



When generating a report, Base Pay parameter will be checked. If a value if provided, only records with Base Pay greater than the provided value will be included in the report.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

Related Articles

    Still can't find your solution?

    Visit our forums to search for answers, or post your own questions.

    Documentation
    Developer's Library
    Tutorials
    eBooks
    Product Hour
    Product Blog
    Workato Blog
    Product updates
    Customer Stories
    © Workato 2022   Privacy   Terms   +1 (844) 469-6752
    • Documentation
    • Workato Blog
    • Product Blog
    • Solutions
    • Forums
    • Tickets
    • Log in
    • Return to Workato
    Article views count