Workday Report Writer

aid: workday-report-writer
name: Workday Report Writer
description: >-
  APIs for Workday Report Writer - a tool for creating custom reports and data extracts
  from Workday HCM and Financial systems.
image: https://kinlane-productions.s3.amazonaws.com/apis-json/apis-json-logo.jpg
url: >-
  https://raw.githubusercontent.com/api-evangelist/workday-report-writer/refs/heads/main/apis.yml
created: '2024-01-01'
modified: '2026-05-03'
specificationVersion: '0.19'
tags:
  - Analytics
  - Enterprise
  - Erp
  - Financials
  - Hrms
  - Reporting
  - Saas
apis:
  - name: Workday Report Writer API
    description: >-
      SOAP web service API for creating, managing, and executing custom reports in
      Workday using Report Writer functionality. Provides programmatic access to
      report definitions, calculated fields, and report output across HCM and
      Financial Management modules.
    image: https://www.workday.com/content/dam/web/images/logo.svg
    humanURL: https://www.workday.com/en-us/products/financial-management/reporting-analytics.html
    baseURL: https://wd2-impl-services1.workday.com/ccx/service
    tags:
      - Analytics
      - Custom Reports
      - Data Extraction
      - Reports
      - SOAP
    properties:
      - type: Documentation
        url: https://community.workday.com/sites/default/files/file-hosting/productionapi/index.html
      - type: APIReference
        url: https://community.workday.com/sites/default/files/file-hosting/productionapi/Report_as_a_Service/v41.0/Report_as_a_Service.html
      - type: Authentication
        url: https://doc.workday.com/admin-guide/en-us/workday-api/authentication/index.html
    contact:
      - FN: Workday Support
        email: [email protected]
        url: https://www.workday.com/en-us/company/contact-us.html
  - name: Workday Report-as-a-Service (RaaS) REST API
    description: >-
      REST API that exposes custom Workday reports as web service endpoints.
      Advanced-type reports enabled as web services can be consumed via RESTful
      endpoints, returning data in JSON, CSV, XML, and other formats. Supports
      query parameters for report prompts and filtering.
    image: https://www.workday.com/content/dam/web/images/logo.svg
    humanURL: https://community.workday.com/api
    baseURL: https://wd2-impl-services1.workday.com/ccx/service/customreport2
    tags:
      - Custom Reports
      - Data Export
      - Report as a Service
      - Reports
      - REST
    properties:
      - type: Documentation
        url: https://community.workday.com/api
      - type: OpenAPI
        url: openapi/workday-report-writer-raas-openapi.yml
      - type: Authentication
        url: https://doc.workday.com/admin-guide/en-us/workday-api/authentication/index.html
      - type: SDK
        url: https://github.com/Workday/raas-python
        title: Python SDK
      - type: CLI
        url: https://github.com/Workday/raas-python
        title: RaaS Python CLI
      - type: GitHubRepository
        url: https://github.com/Workday/raas-python
    contact:
      - FN: Workday Support
        email: [email protected]
        url: https://www.workday.com/en-us/company/contact-us.html
  - name: Workday WQL API
    description: >-
      Workday Query Language (WQL) API enabling SQL-like querying of Workday data
      through REST endpoints. Allows developers to construct queries using SELECT,
      FROM, WHERE, ORDER BY, and LIMIT syntax to retrieve report data with high
      performance, controlled via OAuth 2.0 tokens.
    image: https://www.workday.com/content/dam/web/images/logo.svg
    humanURL: https://community.workday.com/sites/default/files/file-hosting/restapi/index.html
    baseURL: https://wd2-impl-services1.workday.com/ccx/api/wql
    tags:
      - Analytics
      - Data Access
      - Query Language
      - Reporting
    properties:
      - type: Documentation
        url: https://community.workday.com/sites/default/files/file-hosting/restapi/index.html
      - type: OpenAPI
        url: openapi/workday-report-writer-wql-openapi.yml
      - type: Authentication
        url: https://doc.workday.com/admin-guide/en-us/workday-api/authentication/index.html
    contact:
      - FN: Workday Support
        email: [email protected]
        url: https://www.workday.com/en-us/company/contact-us.html
  - name: Workday Prism Analytics API
    description: >-
      REST API for working with Workday Prism Analytics tables, datasets, and data
      change tasks. Enables programmatic loading of external data into Prism
      Analytics for advanced reporting and analytics that combines internal Workday
      data with external sources.
    image: https://www.workday.com/content/dam/web/images/logo.svg
    humanURL: https://doc.workday.com/admin-guide/en-us/workday-prism-analytics/workday-prism-analytics-api.html
    baseURL: https://wd2-impl-services1.workday.com/ccx/api/prismAnalytics
    tags:
      - Analytics
      - Data Loading
      - Datasets
      - Prism Analytics
    properties:
      - type: Documentation
        url: https://doc.workday.com/admin-guide/en-us/workday-prism-analytics/workday-prism-analytics-api.html
      - type: OpenAPI
        url: openapi/workday-report-writer-prism-analytics-openapi.yml
      - type: JSONSchema
        url: json-schema/workday-report-writer-prism-table-schema.json
        title: Prism Table Schema Definition
      - type: Authentication
        url: https://doc.workday.com/admin-guide/en-us/workday-api/authentication/index.html
      - type: SDK
        url: https://github.com/Workday/prism-python
        title: Python SDK
      - type: CLI
        url: https://github.com/Workday/prism-python
        title: Prism Python CLI
      - type: GitHubRepository
        url: https://github.com/Workday/prism-python
    contact:
      - FN: Workday Support
        email: [email protected]
        url: https://www.workday.com/en-us/company/contact-us.html
common:
  - type: Portal
    url: https://developer.workday.com/about
  - type: GettingStarted
    url: https://doc.workday.com/reader/J1YvI9CYZUWl1U7_PSHyHA/KfHiRHLBJB0O63TxIyZCFA
  - type: Documentation
    url: https://community.workday.com/api
  - type: Authentication
    url: https://doc.workday.com/admin-guide/en-us/workday-api/authentication/index.html
  - type: Sandbox
    url: https://community.workday.com/articles/6394
  - type: Hub
    url: https://community.workday.com/
  - type: RateLimits
    url: https://doc.workday.com/reader/J1YvI9CYZUWl1U7_PSHyHA/a3a_TL5Tde61ZFJKLtycjg
  - type: TermsOfService
    url: https://www.workday.com/en-us/legal.html
  - type: PrivacyPolicy
    url: https://www.workday.com/en-us/privacy.html
  - type: StatusPage
    url: https://community.workday.com/trust/status
  - type: Support
    url: https://www.workday.com/en-us/services/support.html
  - type: Blog
    url: https://blog.workday.com/en-us/technology.html
  - type: SignUp
    url: https://resourcecenter.workday.com/
  - type: Console
    url: https://developer.workday.com/about
  - type: GitHubOrganization
    url: https://github.com/Workday
  - type: APIReference
    url: https://community.workday.com/sites/default/files/file-hosting/productionapi/index.html
  - type: Features
    data:
      - name: Custom Report Authoring
        description: >-
          Build custom reports using Report Writer with calculated fields,
          subfilters, and grouping across HCM and Financial Management data.
      - name: Report-as-a-Service Web Endpoints
        description: >-
          Expose any advanced custom report as a REST or SOAP web service
          returning JSON, CSV, XML, or RSS for programmatic consumption.
      - name: SQL-Like Data Access via WQL
        description: >-
          Query Workday data with SQL-like SELECT/FROM/WHERE/ORDER BY/LIMIT
          syntax against governed data sources for high-performance retrieval.
      - name: External Data Loading with Prism Analytics
        description: >-
          Programmatically create tables, upload compressed files via buckets,
          and run data change tasks (insert, update, upsert, delete) in Prism.
      - name: OAuth 2.0 Authentication
        description: >-
          Secure access to REST endpoints using OAuth 2.0 client credentials,
          refresh tokens, and bearer tokens managed through API client setup.
      - name: Multi-Format Output
        description: >-
          Retrieve report data in JSON, CSV, XML, RSS, and other formats with
          query parameter control over filtering, prompts, and pagination.
  - type: UseCases
    data:
      - name: HR Analytics and Workforce Reporting
        description: >-
          Extract headcount, compensation, and turnover metrics from Workday
          HCM for downstream analytics, dashboards, and board reporting.
      - name: Financial Reporting and Close
        description: >-
          Pull custom financial reports for general ledger, accounts payable,
          and budget variance analysis in support of period close processes.
      - name: Data Warehouse and Lake Hydration
        description: >-
          Schedule RaaS or WQL extracts to feed Snowflake, BigQuery, Redshift,
          Databricks, or other downstream systems with Workday data.
      - name: External Data Blending in Prism
        description: >-
          Load external CSV or Parquet datasets into Prism Analytics tables to
          combine with native Workday data for cross-source reporting.
      - name: Operational Integrations
        description: >-
          Drive payroll vendors, benefits providers, and identity systems with
          scheduled report extracts derived from Workday source-of-truth data.
      - name: Compliance and Audit Reporting
        description: >-
          Generate audit-ready extracts of personnel actions, journal entries,
          and security configurations for regulatory and SOX compliance.
  - type: Integrations
    data:
      - name: Snowflake
        description: >-
          Land Workday RaaS and WQL extracts into Snowflake stages for use in
          enterprise data warehouse pipelines.
      - name: Databricks
        description: >-
          Ingest Workday report data into Databricks for analytics, ML feature
          engineering, and lakehouse modeling.
      - name: Tableau
        description: >-
          Connect Tableau to RaaS endpoints or downstream warehouses to build
          interactive dashboards on Workday HCM and financial data.
      - name: Power BI
        description: >-
          Use RaaS JSON or CSV outputs as data sources for Microsoft Power BI
          reports and semantic models.
      - name: Workato
        description: >-
          Orchestrate Workday API calls in iPaaS workflows that move data
          between Workday and third-party SaaS applications.
      - name: SnapLogic
        description: >-
          Build integration pipelines using SnapLogic's Workday Snap Pack to
          read RaaS, WQL, and Prism endpoints.
      - name: Boomi
        description: >-
          Connect Workday APIs to ERP, CRM, and HRIS systems through Boomi
          AtomSphere integration processes.
  - type: Solutions
    data:
      - name: HCM Reporting
        description: >-
          End-to-end workforce and people analytics built on Report Writer,
          RaaS, and WQL across the Workday HCM suite.
      - name: Financial Management Reporting
        description: >-
          Custom financial reporting and extracts spanning ledgers, projects,
          procurement, and revenue across Workday Financial Management.
      - name: Prism Analytics
        description: >-
          Bring external data into Workday and combine with native data sets
          to deliver advanced analytics and self-service reporting.
maintainers:
  - FN: Kin Lane
    email: [email protected]
    url: https://apievangelist.com