Skip to content

Working with Report Metadata for a specific report

Overview

The following operations allow you to retrieve meta data for a report

Operation Description
GET Report Metadata for a specific report Get detailed information about a specific report including its column metadata, the list of its filter parameters and the different values that can populate these parameters.

Operation details

This section provides more details on each of the operations.

Retrieving Report Metadata for a specific report

We can use GET Employee addresses operation with required parameters to find meta data for a report

GET Report Metadata for a specific report

<ceridiandayforce.getReportMetadataDetails>
    <xRefCode>{$ctx:xRefCode}</xRefCode>
</ceridiandayforce.getReportMetadataDetails>

Properties

  • xRefCode (Mandatory): The unique identifier (external reference code) of the report to be retrieved. The value provided must be the exact match for an report; otherwise, a bad request (400) error will be returned.

Sample request

Following is a sample request that can be handled by this operation.

{
  "username": "DFWSTest",
  "password": "DFWSTest",
  "clientNamespace": "usconfigr57.dayforcehcm.com/Api/ddn",
  "apiVersion": "V1",
  "xRefCode": "Payroll_Earning_Hours_Detail"
}

Sample response

Given below is a sample response for this operation.

{
    "Data": [
        {
            "Name": "API-Payroll Earning and hours Detail",
            "XRefCode": "Payroll_Earning_Hours_Detail",
            "MaxRows": 20000,
            "ColumnMetadata": [
                {
                    "CodeName": "Employee.DisplayName",
                    "DisplayName": "Employee",
                    "DataType": "String"
                },
                {
                    "CodeName": "PRPayRunResultPermanent.EmployeeNumber",
                    "DisplayName": "Employee Number",
                    "DataType": "String"
                },
                {
                    "CodeName": "OrgUnit.ShortName",
                    "DisplayName": "Location",
                    "DataType": "String"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.PayDate",
                    "DisplayName": "Pay Date",
                    "DataType": "Date"
                },
                {
                    "CodeName": "Job.ShortName",
                    "DisplayName": "Job Name",
                    "DataType": "String"
                },
                {
                    "CodeName": "PREarningCode.ShortName",
                    "DisplayName": "Earning Code Name",
                    "DataType": "String"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.Rate",
                    "DisplayName": "Earning Rate",
                    "DataType": "Decimal"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.Units",
                    "DisplayName": "Earning Hours",
                    "DataType": "Decimal"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.Amount",
                    "DisplayName": "Earning Earning",
                    "DataType": "Decimal"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.WeekStartDate",
                    "DisplayName": "Week Start Date",
                    "DataType": "Date"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.WeekEndDate",
                    "DisplayName": "Week End Date",
                    "DataType": "Date"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.WeekNumber",
                    "DisplayName": "Week Number",
                    "DataType": "Integer"
                }
            ],
            "Parameters": [
                {
                    "Name": "@EffectiveStart",
                    "DisplayName": "@EffectiveStart",
                    "ReportParameterMetadataId": "32683c04-2d51-4407-ba11-6634f1ae6038",
                    "DataType": "DateTime",
                    "DefaultValue": "2/7/2020 12:00:00 AM",
                    "IsRequired": true
                },
                {
                    "Name": "@EffectiveEnd",
                    "DisplayName": "@EffectiveEnd",
                    "ReportParameterMetadataId": "32683c04-2d51-4407-ba11-6634f1ae6039",
                    "DataType": "DateTime",
                    "IsRequired": false
                }
            ]
        }
    ]
}

Related Dayforce documentation

https://developers.dayforce.com/Build/API-Explorer/Reporting/GET-Report-Metadata-for-one-reports.aspx

Sample configuration

Following example illustrates how to connect to Dayforce with the init operation and query operation.

1.Create a sample proxy as below :

<?xml version="1.0" encoding="UTF-8"?>
<proxy xmlns="http://ws.apache.org/ns/synapse"
       name="query"
       startOnLoad="true"
       statistics="disable"
       trace="disable"
       transports="http,https">
   <target>
      <inSequence>
         <log level="full" separator=","/>
         <property expression="json-eval($.username)" name="username"/>
         <property expression="json-eval($.password)" name="password"/>
         <property expression="json-eval($.clientNamespace)" name="clientNamespace"/>
         <property expression="json-eval($.apiVersion)" name="apiVersion"/>
         <property expression="json-eval($.xRefCode)" name="xRefCode"/>
         <ceridiandayforce.init>
            <username>{$ctx:username}</username>
            <password>{$ctx:password}</password>
            <clientNamespace>{$ctx:clientNamespace}</clientNamespace>
            <apiVersion>{$ctx:apiVersion}</apiVersion>
         </ceridiandayforce.init>
         <ceridiandayforce.getReportMetadataDetails>
            <xRefCode>{$ctx:xRefCode}</xRefCode>
         </ceridiandayforce.getReportMetadataDetails>
         <send/>
      </inSequence>
   </target>
   <description/>
</proxy>

2.Create a json file named query.json and copy the configurations given below to it:

{
  "username": "DFWSTest",
  "password": "DFWSTest",
  "clientNamespace": "usconfigr57.dayforcehcm.com/Api/ddn",
  "apiVersion": "V1",
  "xRefCode": "Payroll_Earning_Hours_Detail"
}
3.Replace the credentials with your values.

4.Execute the following curl command:

curl http://localhost:8280/services/query -H "Content-Type: application/json" -d @query.json
5.Dayforce returns HTTP Code 200 with the following response body

{
    "Data": [
        {
            "Name": "API-Payroll Earning and hours Detail",
            "XRefCode": "Payroll_Earning_Hours_Detail",
            "MaxRows": 20000,
            "ColumnMetadata": [
                {
                    "CodeName": "Employee.DisplayName",
                    "DisplayName": "Employee",
                    "DataType": "String"
                },
                {
                    "CodeName": "PRPayRunResultPermanent.EmployeeNumber",
                    "DisplayName": "Employee Number",
                    "DataType": "String"
                },
                {
                    "CodeName": "OrgUnit.ShortName",
                    "DisplayName": "Location",
                    "DataType": "String"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.PayDate",
                    "DisplayName": "Pay Date",
                    "DataType": "Date"
                },
                {
                    "CodeName": "Job.ShortName",
                    "DisplayName": "Job Name",
                    "DataType": "String"
                },
                {
                    "CodeName": "PREarningCode.ShortName",
                    "DisplayName": "Earning Code Name",
                    "DataType": "String"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.Rate",
                    "DisplayName": "Earning Rate",
                    "DataType": "Decimal"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.Units",
                    "DisplayName": "Earning Hours",
                    "DataType": "Decimal"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.Amount",
                    "DisplayName": "Earning Earning",
                    "DataType": "Decimal"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.WeekStartDate",
                    "DisplayName": "Week Start Date",
                    "DataType": "Date"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.WeekEndDate",
                    "DisplayName": "Week End Date",
                    "DataType": "Date"
                },
                {
                    "CodeName": "PRPayRunEarningPermanent.WeekNumber",
                    "DisplayName": "Week Number",
                    "DataType": "Integer"
                }
            ],
            "Parameters": [
                {
                    "Name": "@EffectiveStart",
                    "DisplayName": "@EffectiveStart",
                    "ReportParameterMetadataId": "32683c04-2d51-4407-ba11-6634f1ae6038",
                    "DataType": "DateTime",
                    "DefaultValue": "2/7/2020 12:00:00 AM",
                    "IsRequired": true
                },
                {
                    "Name": "@EffectiveEnd",
                    "DisplayName": "@EffectiveEnd",
                    "ReportParameterMetadataId": "32683c04-2d51-4407-ba11-6634f1ae6039",
                    "DataType": "DateTime",
                    "IsRequired": false
                }
            ]
        }
    ]
}