Articles in this section

Available Workday DI objects

The following objects are available when using Workday as a source in Celigo Data Integration (DI).

Primary key: All Workday DI endpoints use a string id (Workday Identifier / WID) as the primary key. Workday assigns a stable WID string to each resource object.

Note

Workday hard deletes records where DELETE is supported (for example custom objects, quick expenses, payroll inputs, and scorecards). DELETE endpoints physically remove those resources and deleted records are not retrievable via the API. Many HR and finance objects are canceled or rescinded through business processes rather than DELETE and are not returned as deleted records. Celigo syncs all data returned by the source as-is.

Object API endpoint Available extract modes Delta field
Accounts Payable v1: Supplier Invoice Requests Retrieve a collection of supplier invoices Full, Incremental fromInvoiceDate
Common v1: Currencies Retrieve a collection of currencies Full —
Common v1: Organizations Retrieve a collection of organizations Full —
Common v1: Supervisory Organizations Retrieve a collection of supervisory organizations Full —
Common v1: Workers Retrieve a collection of workers Full —
Contract Compliance v1: Supplier Contracts Retrieve all supplier contracts Full —
Customer Accounts v1: Customers Retrieve a collection of customers Full —
Customer Accounts v1: Invoices Retrieve a collection of customer invoices and adjustments Full, Incremental fromInvoiceDate
Expense v1: Entries Retrieve a collection of quick expenses Full, Incremental fromDate
Expense v1: Reports Retrieve a collection of expense reports Full, Incremental fromDate
Projects v1: Ad Hoc Project Time Transactions Retrieve a collection of ad hoc project time transactions Full —
Projects v1: Plan Phases Retrieve a collection of project plan phases for a specified project Full —
Projects v1: Plan Tasks Retrieve a collection of project plan tasks for a specified project or project plan phase Full —
Projects v1: Projects Retrieve a collection of projects Full —
Projects v1: Resource Forecast Lines Retrieve a collection of resource forecast lines Full —
Projects v1: Resource Plan Lines Retrieve a collection of resource plan lines Full —
Projects v1: Task Resources Retrieve a collection of task resources Full —
Revenue v1: Billable Transactions Retrieve a collection of billable transactions Full, Incremental fromDate

Response schemas

Click an object below to view its response fields and delta configuration.

Accounts Payable v1: Supplier Invoice Requests — Retrieve a collection of supplier invoices

Delta configuration: use it to request incremental data.

Setting Value
Delta filter fromInvoiceDate = {{{lastExportDateTime}}}
Date format MM/DD/YYYY

Response schema:

Field Type
descriptor string
id string (Primary key)
currency object
currency.id string
currency.descriptor string
currency.href string
company object
company.id string
company.descriptor string
company.href string
taxAmount object
requester object
requester.id string
requester.descriptor string
requester.href string
controlTotalAmount object
referenceType object
referenceType.id string
referenceType.descriptor string
referenceType.href string
paymentTerms object
paymentTerms.id string
paymentTerms.descriptor string
paymentTerms.href string
lines objectarray
lines.unitCost object
lines.internalMemo string
lines.itemDescription string
lines.worktags objectarray
lines.worktags.descriptor string
lines.worktags.id string
lines.splits objectarray
lines.splits.percent number
lines.splits.billable boolean
lines.splits.memo string
lines.splits.quantity number
lines.splits.amount object
lines.splits.worktags objectarray
lines.splits.worktags.descriptor string
lines.splits.worktags.id string
lines.splits.id string
lines.splits.descriptor string
lines.order string
lines.billable boolean
lines.splitBy object
lines.splitBy.id string
lines.splitBy.descriptor string
lines.splitBy.href string
lines.quantity number
lines.extendedAmount object
lines.spendCategory object
lines.spendCategory.id string
lines.spendCategory.descriptor string
lines.spendCategory.href string
lines.unitOfMeasure object
lines.unitOfMeasure.id string
lines.unitOfMeasure.descriptor string
lines.unitOfMeasure.href string
lines.memo string
lines.serviceLine boolean
lines.item object
lines.item.id string
lines.item.descriptor string
lines.item.href string
lines.descriptor string
lines.id string
statutoryInvoiceType object
statutoryInvoiceType.id string
statutoryInvoiceType.descriptor string
statutoryInvoiceType.href string
suppliersInvoiceNumber string
referenceNumber string
invoiceReceivedDate string
freightAmount object
supplier object
supplier.id string
supplier.descriptor string
supplier.href string
handlingCode object
handlingCode.id string
handlingCode.descriptor string
handlingCode.href string
shipToAddress object
shipToAddress.id string
shipToAddress.descriptor string
shipToAddress.href string
invoiceDate string
memo string
remitToConnection object
remitToConnection.id string
remitToConnection.descriptor string
remitToConnection.href string
fileLength number
contentType object
contentType.id string
contentType.descriptor string
contentType.href string
fileName string
Common v1: Currencies — Retrieve a collection of currencies

Response schema:

Field Type
id string (Primary key)
descriptor string
href string
Common v1: Organizations — Retrieve a collection of organizations

Response schema:

Field Type
id string (Primary key)
descriptor string
href string
Common v1: Supervisory Organizations — Retrieve a collection of supervisory organizations

Response schema:

Field Type
id string (Primary key)
descriptor string
href string
Common v1: Workers — Retrieve a collection of workers

Response schema:

Field Type
proposedBusinessTitle string
descriptor string
href string
id string (Primary key)
supervisoryOrganization object
supervisoryOrganization.id string
supervisoryOrganization.descriptor string
supervisoryOrganization.href string
jobChangeReason object
jobChangeReason.id string
jobChangeReason.descriptor string
jobChangeReason.href string
moveManagersTeam boolean
effective string
proposedOrganizations objectarray
proposedOrganizations.href string
proposedOrganizations.descriptor string
proposedOrganizations.id string
Contract Compliance v1: Supplier Contracts — Retrieve all supplier contracts

Response schema:

Field Type
id string (Primary key)
descriptor string
href string
Customer Accounts v1: Customers — Retrieve a collection of customers

Response schema:

Field Type
id string (Primary key)
descriptor string
href string
name string
primaryPhone string
satisfactionScore number
compositeRiskScore number
commercialCreditScore number
creditLimit object
totalBalance object
groups objectarray
groups.id string
groups.descriptor string
groups.href string
Customer Accounts v1: Invoices — Retrieve a collection of customer invoices and adjustments

Delta configuration: use it to request incremental data.

Setting Value
Delta filter fromInvoiceDate = {{{lastExportDateTime}}}
Date format YYYY-MM-DD

Response schema:

Field Type
id string (Primary key)
invoiceNumber string
invoiceDate string
dueDate string
disputeDate string
transactionType string
poNumber string
memo string
inCollection boolean
inDispute boolean
billToCustomer object
billToCustomer.id string
billToCustomer.descriptor string
billToCustomer.href string
adjustmentReason object
adjustmentReason.id string
adjustmentReason.descriptor string
adjustmentReason.href string
currency object
currency.id string
currency.descriptor string
currency.href string
withholdingAmount object
netAmount object
disputeAmount object
dueAmount object
taxAmount object
retentionAmount object
totalAmount object
relatedAdjustments objectarray
relatedAdjustments.id string
relatedAdjustments.descriptor string
relatedAdjustments.href string
disputeReasons objectarray
disputeReasons.id string
disputeReasons.descriptor string
disputeReasons.href string
Expense v1: Entries — Retrieve a collection of quick expenses

Delta configuration: use it to request incremental data.

Setting Value
Delta filter fromDate = {{{lastExportDateTime}}}
Date format YYYY-MM-DD

Response schema:

Field Type
attachments objectarray
attachments.fileLength number
attachments.fileName string
attachments.contentType object
attachments.contentType.id string
attachments.contentType.descriptor string
attachments.contentType.href string
attachments.id string
attachments.href string
attachments.descriptor string
amount object
merchant string
expenseItem object
expenseItem.id string
expenseItem.descriptor string
expenseItem.href string
date string
memo string
image object
image.id string
image.descriptor string
image.href string
descriptor string
id string (Primary key)
href string
hasOCRReceipt boolean
scanStatus object
scanStatus.id string
scanStatus.descriptor string
scanStatus.href string
fileLength number
fileName string
contentType object
contentType.id string
contentType.descriptor string
contentType.href string
Expense v1: Reports — Retrieve a collection of expense reports

Delta configuration: use it to request incremental data.

Setting Value
Delta filter fromDate = {{{lastExportDateTime}}}
Date format YYYY-MM-DD

Response schema:

Field Type
payee object
payee.id string
payee.descriptor string
payee.href string
expenseReportMemo string
creationDate string
worktag object
worktag.id string
worktag.descriptor string
company object
company.id string
company.descriptor string
company.href string
descriptor string
id string (Primary key)
date string
expenseItem object
expenseItem.id string
expenseItem.descriptor string
expenseItem.href string
travelBookingRecord object
travelBookingRecord.id string
travelBookingRecord.descriptor string
travelBookingRecord.href string
memo string
quickExpense object
quickExpense.id string
quickExpense.descriptor string
quickExpense.href string
creditCardTransaction object
creditCardTransaction.id string
creditCardTransaction.descriptor string
creditCardTransaction.href string
totalAmount object
expenseReport object
expenseReport.id string
expenseReport.descriptor string
expenseReport.href string
Projects v1: Ad Hoc Project Time Transactions — Retrieve a collection of ad hoc project time transactions

Response schema:

Field Type
project object
project.id string
project.descriptor string
project.href string
projectRole object
projectRole.id string
projectRole.descriptor string
projectRole.href string
rateToBill object
includeCost boolean
hours number
memo string
worker object
worker.id string
worker.descriptor string
worker.href string
standardCostRate object
transactionDate string
billingStatus object
billingStatus.id string
billingStatus.descriptor string
billingStatus.href string
task object
task.id string
task.descriptor string
task.href string
worktags string
id string (Primary key)
href string
descriptor string
Projects v1: Plan Phases — Retrieve a collection of project plan phases for a specified project

Response schema:

Field Type
phase object
phase.id string
phase.descriptor string
phase.href string
editable boolean
childrenCount number
order string
project object
project.id string
project.descriptor string
project.href string
hasChildren boolean
parentPhase object
parentPhase.id string
parentPhase.descriptor string
parentPhase.href string
deletable boolean
levelNumber number
sequenceNumber string
warningCustomValidations string
id string (Primary key)
descriptor string
Projects v1: Plan Tasks — Retrieve a collection of project plan tasks for a specified project or project plan phase

Response schema:

Field Type
order string
startDate string
endDate string
utilization boolean
billableTask boolean
percentComplete number
task object
task.id string
task.descriptor string
task.href string
milestone boolean
customTaskName string
warningCustomValidations string
editable boolean
deletable boolean
closed boolean
memo string
phase object
phase.id string
phase.descriptor string
phase.href string
descriptor string
id string (Primary key)
Projects v1: Projects — Retrieve a collection of projects

Response schema:

Field Type
customer object
customer.id string
customer.descriptor string
customer.href string
problemStatement string
successRating object
successRating.id string
successRating.descriptor string
successRating.href string
company object
company.id string
company.descriptor string
company.href string
overview string
name string
probabilityOfSuccess number
worktags objectarray
worktags.descriptor string
worktags.id string
startDate string
status object
status.id string
status.descriptor string
status.href string
objective string
estimatedBudget object
owner object
owner.id string
owner.descriptor string
owner.href string
endDate string
businessEventRecords objectarray
businessEventRecords.delayedDate string
businessEventRecords.businessProcessStep object
businessEventRecords.businessProcessStep.id string
businessEventRecords.businessProcessStep.descriptor string
businessEventRecords.businessProcessStep.href string
businessEventRecords.businessEventValidation objectarray
businessEventRecords.businessEventValidation.conditionRule string
businessEventRecords.businessEventValidation.descriptor string
businessEventRecords.businessEventValidation.id string
businessEventRecords.status object
businessEventRecords.status.id string
businessEventRecords.status.descriptor string
businessEventRecords.status.href string
businessEventRecords.event object
businessEventRecords.event.id string
businessEventRecords.event.descriptor string
businessEventRecords.event.href string
businessEventRecords.completedByPerson object
businessEventRecords.completedByPerson.id string
businessEventRecords.completedByPerson.descriptor string
businessEventRecords.completedByPerson.href string
businessEventRecords.completedOn string
businessEventRecords.due string
businessEventRecords.creationDate string
businessEventRecords.awaitingPersons objectarray
businessEventRecords.awaitingPersons.id string
businessEventRecords.awaitingPersons.descriptor string
businessEventRecords.comments objectarray
businessEventRecords.comments.person object
businessEventRecords.comments.person.id string
businessEventRecords.comments.person.descriptor string
businessEventRecords.comments.person.href string
businessEventRecords.comments.commentDate string
businessEventRecords.comments.comment string
businessEventRecords.id string
businessEventRecords.descriptor string
riskLevel object
riskLevel.id string
riskLevel.descriptor string
riskLevel.href string
inScope string
description string
inactive boolean
measuresOfSuccess string
priority object
priority.id string
priority.descriptor string
priority.href string
capital boolean
externalProjectReference string
importanceRating object
importanceRating.id string
importanceRating.descriptor string
importanceRating.href string
projectDependencies objectarray
projectDependencies.id string
projectDependencies.descriptor string
currency object
currency.id string
currency.descriptor string
percentComplete number
outOfScope string
externalLink string
billable boolean
estimatedRevenueSavings object
includeProjectIDInName boolean
groups objectarray
groups.descriptor string
groups.id string
realizedRevenueSavings object
totalSavingsRemaining object
id string (Primary key)
href string
projectState object
projectState.id string
projectState.descriptor string
projectState.href string
Project_ID string
primaryHierarchy object
primaryHierarchy.id string
primaryHierarchy.descriptor string
primaryHierarchy.href string
optionalHierarchies objectarray
optionalHierarchies.id string
optionalHierarchies.descriptor string
descriptor string
Projects v1: Resource Forecast Lines — Retrieve a collection of resource forecast lines

Response schema:

Field Type
forecastedHours number
date string
descriptor string
id string (Primary key)
Projects v1: Resource Plan Lines — Retrieve a collection of resource plan lines

Response schema:

Field Type
percentAllocation number
workerGroup object
workerGroup.id string
workerGroup.descriptor string
workerGroup.href string
role object
role.id string
role.descriptor string
role.href string
bookingStatus object
bookingStatus.id string
bookingStatus.descriptor string
bookingStatus.href string
costRateCurrencyOverride object
costRateCurrencyOverride.id string
costRateCurrencyOverride.descriptor string
costRateCurrencyOverride.href string
roleCategory object
roleCategory.id string
roleCategory.descriptor string
roleCategory.href string
project object
project.id string
project.descriptor string
project.href string
excludedWorkers objectarray
excludedWorkers.id string
excludedWorkers.descriptor string
requirements objectarray
requirements.values objectarray
requirements.values.id string
requirements.values.descriptor string
requirements.category object
requirements.category.id string
requirements.category.descriptor string
requirements.category.href string
requirements.optional boolean
requirements.id string
requirements.descriptor string
resourceType object
resourceType.id string
resourceType.descriptor string
resourceType.href string
endDate string
jobRequisition object
jobRequisition.id string
jobRequisition.descriptor string
jobRequisition.href string
workers objectarray
workers.id string
workers.descriptor string
estimatedHours number
startDate string
businessEventRecords objectarray
businessEventRecords.delayedDate string
businessEventRecords.businessProcessStep object
businessEventRecords.businessProcessStep.id string
businessEventRecords.businessProcessStep.descriptor string
businessEventRecords.businessProcessStep.href string
businessEventRecords.businessEventValidation objectarray
businessEventRecords.businessEventValidation.conditionRule string
businessEventRecords.businessEventValidation.descriptor string
businessEventRecords.businessEventValidation.id string
businessEventRecords.status object
businessEventRecords.status.id string
businessEventRecords.status.descriptor string
businessEventRecords.status.href string
businessEventRecords.event object
businessEventRecords.event.id string
businessEventRecords.event.descriptor string
businessEventRecords.event.href string
businessEventRecords.completedByPerson object
businessEventRecords.completedByPerson.id string
businessEventRecords.completedByPerson.descriptor string
businessEventRecords.completedByPerson.href string
businessEventRecords.completedOn string
businessEventRecords.due string
businessEventRecords.creationDate string
businessEventRecords.awaitingPersons objectarray
businessEventRecords.awaitingPersons.id string
businessEventRecords.awaitingPersons.descriptor string
businessEventRecords.comments objectarray
businessEventRecords.comments.person object
businessEventRecords.comments.person.id string
businessEventRecords.comments.person.descriptor string
businessEventRecords.comments.person.href string
businessEventRecords.comments.commentDate string
businessEventRecords.comments.comment string
businessEventRecords.id string
businessEventRecords.descriptor string
unnamedResources number
costRateOverride object
memo string
toBeHired boolean
id string (Primary key)
descriptor string
pendingWorkers objectarray
pendingWorkers.id string
pendingWorkers.descriptor string
projectResources objectarray
projectResources.descriptor string
projectResources.id string
Projects v1: Task Resources — Retrieve a collection of task resources

Response schema:

Field Type
projectPlanTask object
projectPlanTask.id string
projectPlanTask.descriptor string
projectPlanTask.href string
warningCustomValidations string
allocation number
memo string
projectPlanLine object
projectPlanLine.associationResourcePlanDetail boolean
projectPlanLine.id string
projectPlanLine.descriptor string
estimatedHours number
projectResources objectarray
projectResources.processingUserHasAccessToViewWorker boolean
projectResources.unnamedResource boolean
projectResources.descriptor string
projectResources.id string
startDate string
endDate string
id string (Primary key)
descriptor string
Revenue v1: Billable Transactions — Retrieve a collection of billable transactions

Delta configuration: use it to request incremental data.

Setting Value
Delta filter fromDate = {{{lastExportDateTime}}}
Date format YYYY-MM-DD

Response schema:

Field Type
adjustmentReason object
adjustmentReason.id string
adjustmentReason.descriptor string
adjustmentReason.href string
memo string
zeroAmountToBill boolean
hoursToBill number
rateToBill object
billingStatus object
billingStatus.id string
billingStatus.descriptor string
billingStatus.href string
reasonForChange string
amountToBill object
href string
descriptor string
id string (Primary key)