ODBC Driver for Workday

Build 23.0.8839

SingleEntryTables

Treats the specified SOAP tables as having one entry per row, even if Workday says they are collections.

Data Type

string

Default Value

"Payments"

Remarks

The Workday SOAP API annotates some operations as returning a collection of data within each value. By default the driver exposes these responses using each collection entry as a row, instead of each top-level value being a row. This creates a simpler table by removing elements from the table that may be repeated across multiple rows.

For example, the CommitteeDefinition table is built using this process. Each response value is a Committee_Definition that contains both a reference as well as a Committee_Definition_Data structure. The driver table only contains the values from Committee_Definition_Data and leaves off the reference:

  • Included: ID, Private_Committee, Include_Code_In_Name, ...
  • Excluded: Committee_Definition_Reference_ID_WID, Committee_Definition_Reference_ID_CommitteeObjectID

However, some Workday SOAP definitions mark data as a collection when only one value is actually allowed. When this happens you can add the table to this connection property. The driver will then treat the collection as if it only has one value:

  • The driver table includes the reference and inner data in each row, instead of just the inner data.
  • The driver marks the reference as the primary key of the table.
  • The driver marks the reference as the foreign key of any child tables.

There are three ways to set this property. At the start you should explicitly include the tables you have checked against your Workday data. However, if you find that most of the tables in your workflow are single-entry, you can use the latter two formats:

  • As a comma-separated list of tables to include. For example, SingleEntryTables=Payments,CommitteeDefinition simplifies just those two tables.
  • As a comma-separated list of tables to exclude, with each table starting with a -. For example, SingleEntryTables=-SupplierInvoices,-CommitteeDefinition simplifies every table except those two tables.
  • SingleEntryTables=* simplifies every collection table.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839