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) |