PUT /tables/{id}

A reference to a Prism Analytics table. Example: The ID of the table.

Default value: "application/json"

A long string field you can use to include more detailed information about this object for internal documentation purposes. The documentation must contain less than 32,000 characters.

The description of the object. The description must contain less than 1,000 characters.

Analytic tags

The display name for the object. You can change this name at any time. If you don't include this parameter, Workday sets it to the same value in the name parameter.

Creates a Prism data source using the data in this table that can be used for querying.

Readonly attribute included in the response.

Required for Date fields. The Date format that the values in this field must match to be recognized as a Date field.

The description of the field. The description must contain less than 1,000 characters.

Required when field is set as the external ID (primary key). Specifies that the field must contain data. Make a field required to ensure it doesn’t contain a NULL value when you insert or update data in the table. When you insert or update data in a table and this field is NULL, Workday rejects the row and instead includes it in the error file.

The order of the field in the file (index). The ordinal values:

• Must start with 1.
• Must be contiguous.
• Can't skip any number.
• Have a maximum of 1,000.

The display name for the object. You can change this name at any time. If you don't include this parameter, Workday sets it to the same value in the name parameter.

Required for Numeric fields. The maximum number of digits in a Numeric field. This value includes all digits to the left and right of the decimal point. The maximum value is 38.

Specifies a value for a field if the uploaded source file schema doesn't include that field. When the source file schema doesn't include a field, Workday uses the default value for all rows in the source file.

Note: The Default Value is only used when the source file schema is missing a field, not when a particular field value is NULL.

Required when the target operation is update, upsert, or delete. Specifies the field in a table to use as a key. Specify a field as the external ID when the values in the field uniquely identify each row from its source.

Set a field as the external ID if you want to update or delete data in the table based on data in an external file. This parameter is similar to a primary key in a relational database.

When using this parameter, consider:

• You can only define 1 field in a table as the external ID field.
• Ensure that each field value in the external ID field is unique. If the field values aren’t unique, you'll get unexpected results. Workday doesn’t enforce the uniqueness.
• You can’t define a default value for fields used as an external ID. The field value must come from the external source and can’t be NULL.
• You must set the external ID field as required.

Valid values:

• "Schema_Field_Type=Date"
• "Schema_Field_Type=Currency"
• "Schema_Field_Type=Multi_Instance"
• "Schema_Field_Type=Text"
• "Schema_Field_Type=Numeric"
• "Schema_Field_Type=Integer"
• "Schema_Field_Type=Boolean"
• "<id>"
• "Schema_Field_Type=Decimal"
• "Schema_Field_Type=Instance"
• "Schema_Field_Type=Long"

• Boolean - True/False value
• Numeric - Numeric
• Text - String
• Date - Datetime
• Currency - Currency
• Instance - ID of an instance
• Multi_Instance - List of IDs of instances. Use this format: "type": { "id": "Schema_Field_Type=type" }

Valid values:

• "Date"
• "Instance"
• "Numeric"
• "Text"
• "Multi_Instance"
• "Currency"
• "Boolean"

Required for Numeric fields. The maximum number of digits to the right of the decimal point in a Numeric field. This value must be less than the precision value.