Workday Report Writer

APIs for Workday Report Writer - a tool for creating custom reports and data extracts from Workday HCM and Financial systems.

4 APIs 6 Features

AnalyticsEnterpriseErpFinancialsHrmsReportingSaas

APIs

Workday Report Writer API

SOAP web service API for creating, managing, and executing custom reports in Workday using Report Writer functionality. Provides programmatic access to report definitions, calcu...

Workday Report-as-a-Service (RaaS) REST API

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 JSO...

Workday WQL API

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, a...

Workday Prism Analytics API

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 report...

Collections

Workday Report Writer Workday Prism Analytics API

OPEN

Workday Report Writer Workday Report-as-a-Service (RaaS) REST API

OPEN

Workday Report Writer Workday WQL API

OPEN

Pricing Plans

Workday Report Writer Plans Pricing

1 plans

PLANS

Rate Limits

Workday Report Writer Rate Limits

2 limits

RATE LIMITS

FinOps

Workday Report Writer Finops

FINOPS

Features

Custom Report Authoring

Build custom reports using Report Writer with calculated fields, subfilters, and grouping across HCM and Financial Management data.

Report-as-a-Service Web Endpoints

Expose any advanced custom report as a REST or SOAP web service returning JSON, CSV, XML, or RSS for programmatic consumption.

SQL-Like Data Access via WQL

Query Workday data with SQL-like SELECT/FROM/WHERE/ORDER BY/LIMIT syntax against governed data sources for high-performance retrieval.

External Data Loading with Prism Analytics

Programmatically create tables, upload compressed files via buckets, and run data change tasks (insert, update, upsert, delete) in Prism.

OAuth 2.0 Authentication

Secure access to REST endpoints using OAuth 2.0 client credentials, refresh tokens, and bearer tokens managed through API client setup.

Multi-Format Output

Retrieve report data in JSON, CSV, XML, RSS, and other formats with query parameter control over filtering, prompts, and pagination.

Use Cases

HR Analytics and Workforce Reporting

Extract headcount, compensation, and turnover metrics from Workday HCM for downstream analytics, dashboards, and board reporting.

Financial Reporting and Close

Pull custom financial reports for general ledger, accounts payable, and budget variance analysis in support of period close processes.

Data Warehouse and Lake Hydration

Schedule RaaS or WQL extracts to feed Snowflake, BigQuery, Redshift, Databricks, or other downstream systems with Workday data.

External Data Blending in Prism

Load external CSV or Parquet datasets into Prism Analytics tables to combine with native Workday data for cross-source reporting.

Operational Integrations

Drive payroll vendors, benefits providers, and identity systems with scheduled report extracts derived from Workday source-of-truth data.

Compliance and Audit Reporting

Generate audit-ready extracts of personnel actions, journal entries, and security configurations for regulatory and SOX compliance.

Integrations

Snowflake

Land Workday RaaS and WQL extracts into Snowflake stages for use in enterprise data warehouse pipelines.

Databricks

Ingest Workday report data into Databricks for analytics, ML feature engineering, and lakehouse modeling.

Tableau

Connect Tableau to RaaS endpoints or downstream warehouses to build interactive dashboards on Workday HCM and financial data.

Power BI

Use RaaS JSON or CSV outputs as data sources for Microsoft Power BI reports and semantic models.

Workato

Orchestrate Workday API calls in iPaaS workflows that move data between Workday and third-party SaaS applications.

SnapLogic

Build integration pipelines using SnapLogic's Workday Snap Pack to read RaaS, WQL, and Prism endpoints.

Boomi

Connect Workday APIs to ERP, CRM, and HRIS systems through Boomi AtomSphere integration processes.

Solutions

HCM Reporting

End-to-end workforce and people analytics built on Report Writer, RaaS, and WQL across the Workday HCM suite.

Financial Management Reporting

Custom financial reporting and extracts spanning ledgers, projects, procurement, and revenue across Workday Financial Management.

Prism Analytics

Bring external data into Workday and combine with native data sets to deliver advanced analytics and self-service reporting.

Resources

TrustCenter

DomainSecurity

Authentication

GettingStarted

Documentation

Authentication

TermsOfService

PrivacyPolicy

GitHubOrganization

GitHubOrganization

APIReference

Sources

opencollection: 1.0.0
info:
  name: Workday Report Writer Workday WQL API
  version: v1
request:
  auth:
    type: bearer
    token: '{{bearerToken}}'
items:
- info:
    name: Data Sources
    type: folder
  items:
  - info:
      name: Workday Report Writer List Available Data Sources
      type: http
    http:
      method: GET
      url: https://{hostname}/ccx/api/wql/v1/{tenant}/dataSources
      params:
      - name: limit
        value: ''
        type: query
        description: Maximum number of results to return per page
      - name: offset
        value: ''
        type: query
        description: Number of results to skip for pagination
    docs: Retrieve a collection of data sources (tables) available for querying with WQL. Each data source represents a queryable
      entity in the Workday data model.
  - info:
      name: Workday Report Writer Get a Data Source
      type: http
    http:
      method: GET
      url: https://{hostname}/ccx/api/wql/v1/{tenant}/dataSources/:dataSourceId
      params:
      - name: dataSourceId
        value: ''
        type: path
        description: Unique identifier of the data source
    docs: Retrieve details about a specific data source including its description and available fields for use in WQL queries.
  - info:
      name: Workday Report Writer List Data Source Fields
      type: http
    http:
      method: GET
      url: https://{hostname}/ccx/api/wql/v1/{tenant}/dataSources/:dataSourceId/fields
      params:
      - name: dataSourceId
        value: ''
        type: path
        description: Unique identifier of the data source
      - name: limit
        value: ''
        type: query
        description: Maximum number of results to return per page
      - name: offset
        value: ''
        type: query
        description: Number of results to skip for pagination
    docs: Retrieve the fields (columns) available in a specific data source. These fields can be used in SELECT, WHERE, and
      ORDER BY clauses of WQL queries.
  - info:
      name: Workday Report Writer List Data Source Filters
      type: http
    http:
      method: GET
      url: https://{hostname}/ccx/api/wql/v1/{tenant}/dataSources/:dataSourceId/filters
      params:
      - name: dataSourceId
        value: ''
        type: path
        description: Unique identifier of the data source
      - name: limit
        value: ''
        type: query
        description: Maximum number of results to return per page
      - name: offset
        value: ''
        type: query
        description: Number of results to skip for pagination
    docs: Retrieve the filterable fields available for a specific data source. These filters can be used as parameters in
      WQL WHERE clauses with the dataSourceFilter syntax.
- info:
    name: Query Execution
    type: folder
  items:
  - info:
      name: Workday Report Writer Execute a WQL Query
      type: http
    http:
      method: GET
      url: https://{hostname}/ccx/api/wql/v1/{tenant}/data
      params:
      - name: query
        value: ''
        type: query
        description: 'WQL query string using SQL-like syntax. Example: SELECT workdayID, fullName FROM workers WHERE supervisoryOrganization
          = ''IT Department'' ORDER BY fullName LIMIT 100'
      - name: limit
        value: ''
        type: query
        description: Maximum number of results to return per page
      - name: offset
        value: ''
        type: query
        description: Number of results to skip for pagination
    docs: Execute a Workday Query Language (WQL) query and retrieve paginated results. Supports SQL-like syntax with SELECT,
      FROM, WHERE, ORDER BY, and LIMIT clauses. WQL also supports special operators such as startsWith, contains, and endsWith
      for text filtering.
bundled: true