In many cases, you can update a field in a DataTable call simply by using its API name. For example, you can rename an asset with the following call:
POST or GET
/API/DataTable/V2.2/Documents.Folder.Default:Update?CoreField.Identifier=ZZ13U2O&CoreField.Title:=January photoshoot
In this example, CoreField.Title
is the field to update, :=
is the operator, and January photoshoot
is the new field value.
In the other cases, you’ll need to use a specific syntax to incorporate more data about the field you’re updating. Some commonly used field types are detailed below.
Inherited fields
Inherited fields are read-only. You cannot change the value of an inherited field with a DataTable API call.
Only the value of the original field – the value that other fields inherit – can be changed. The original field is identified with the <BaseField>
attribute.
Related value fields
Related value fields are read-only. You cannot change the value of a related value field with a DataTable API call.
Only the value of the original field – the value that the related value field reflects – can be changed.
Multivalued fields
Use pipes ( |
) to separate values.
Example:
/API/DataTable/V2.2/Documents.Image.Default:Update?CoreField.Identifier=ZZ12PAR&CoreField.Keywords++=River Thames|Tower of London|England
Paired value fields
Enter a value from an authority list, indicate the type of pairing in the paired value field, and then enter one of the following: another value from an authority list, a string of text, or a linked field’s record ID. The information you enter uses this structure:
[paired-value field’s API name][operator][authority list value]{"type of paired value field":"[value in the second authority list, free text, or the linked field’s record ID]"}
There are three types of paired value fields:
- Two authority lists: Use
"LinkedKeyword"
to identify this type of paired value field. - An authority list and free text: Use
"LinkedText"
to identify this type of paired value field. - An authority list and a linked field: Use
"LinkedField"
to identify this type of paired value field.
Example:
/API/v2.2/DataTable/Documents.Image.Product-Photo:CreateOrUpdate?CoreField.Identifier=ZZ1428I&products.Marketing-campaign++=Create Your Dream Home{"LinkedKeyword":"Mango Atelier"}
Go to Update paired value fields to see more examples.
Date fields
Some types of date fields are read-only. Editable date fields can be updated with DataTable API calls using the name of the field and a date and time value following the ISO 8601 standard of yyyy-mm-ddThh:mm:ss
, where T
represents time, which is optional.
Example:
/API/V2.2/DataTable/Documents.Image.Default:Update?CoreField.Identifier=ZZ1428I&CoreField.SensitiveUntil:=2025-08-23
Computed date fields
Computed date fields are read-only. You cannot change a computed date with a DataTable API call.
Examples of computed dates include:
- Creation Date (CoreField.CreateDate)
- Digitized Date (CoreField.DigitizedDate)
- Edited Date (CoreField.EditDate)
- File Create Date (CoreField.FileCreateDate)
- File Edit Date (CoreField.FileEditDate)
- File Import Date (CoreField.FileImportDate)
- Proxy Import Date (CoreField.ProxyImportDate)
Workflow date fields
Workflow date fields are editable. Update workflow date fields using the API name of the date field.
Example:
/API/V2.2/DataTable/Documents.Project.Standard-Project:Update?CoreField.Identifier=ZZ1428I&CoreField.LastStatusDate:=2025-08-23
Examples of workflow dates include:
- Start Date (CoreField.StartDate)
- End Date (CoreField.EndDate)
- Last Status Update Date (CoreField.LastStatusDate)
Advanced date fields
All advanced date field types are editable. Update advanced date fields using a slash (/) and “NA” where needed to indicate unfilled date information.
Single Date
Update a single date using its API name.
Example:
/API/V2.2/DataTable/Documents.Image.Default:Update?CoreField.Identifier=ZZ1428I&campaigns.Air-date:=2025-09-20
Interval Dates
Update an interval date using a slash ( /
) between the date values.
Example:
/API/V2.2/DataTable/Documents.Image.Default:Update?CoreField.Identifier=ZZ1428I&campaigns.Air-date:=2025-09-20/2025-09-21
From (Start date only)
Update a start date using /NA
to indicate an empty end date.
Example:
/API/V2.2/DataTable/Documents.Image.Default:Update?CoreField.Identifier=ZZ1428I&campaigns.Air-date:=2025-09-20/NA
Until (End date only)
Update an end date using /NA
to indicate an empty start date.
Example:
/API/V2.2/DataTable/Documents.Image.Default:Update?CoreField.Identifier=ZZ1428I&campaigns.Air-date:=NA/2025-09-20
Indefinite
Update an indefinite date using NA/NA
to indicate a date field with no date values.
Example:
/API/V2.2/DataTable/Documents.Image.Default:Update?CoreField.Identifier=ZZ1428I&campaigns.Air-date:=NA/NA
Partial dates (For example, just the month and year)
Update a partial date using /NA
to indicate the missing date information.
For example, to update a month and year date without a specific day value, use the following structure:
/API/V2.2/DataTable/Documents.Image.Default:Update?CoreField.Identifier=ZZ1428I&campaigns.Air-date:=2025-09/NA
Checkboxes
Use true
and false
boolean values to update checkbox fields.
Example:
/API/V2.2/DataTable/Documents.Image.Default:Update?CoreField.Identifier=ZZ1428I&merchandise.Approved:=true