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: support@workday.com 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: support@workday.com 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: support@workday.com 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: support@workday.com 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: kin@apievangelist.com url: https://apievangelist.com