sourcePayloadDateFormat

The "sourcePayloadDateFormat" is an optional enumerated string that specifies how the server encodes and decodes a date value assigned to a tag. For example, it controls how a transform converts a date value between a JSON property and a table field.

• It applies to the tag's value only when the  "tagDataType" property is "date" or "timestamp".
• The default value is "iso8601".
• Use one of the following values (see "dateFormat"):
  • "ccyy.mm.dd"
  • "mm.dd.ccyy"
  • "mm.dd.yy"
  • "dd.mm.ccyy"
  • "dd.mm.yy"
  • "ccyymmdd"
  • "iso8601"
  • "yymmdd"
  • "utc"
• For example, "sourcePayloadDateFormat":"iso8601" decodes "2025-07-11" into a date that can be stored in a date field.
• It applies to the tag's property in the source_payload field, which is specified by the "sourcePayloadPath" property.
• It applies to the tag's field in the integration table, which is specified by the "sourceFieldName" property.
• For example, "sourcePayloadDateFormat": "iso8601" causes a "jsonToTableFields" transform to read the value "2026-03-23" from the tag's property in the source_payload field, decode it into the year 2026, month 3, and day 23, and store it in the tag's date or timestamp field in the integration table.
• For example, "sourcePayloadDateFormat": "mm.dd.ccyy" causes a "jsonToTableFields" transform to read the value "03/23/2026" from the tag's property in the source_payload field, decode it into the year 2026, month 3, and day 23, and store it in the tag's date or timestamp field in the integration table.
• For example, "sourcePayloadBinaryFormat": "yymmdd" causes a "tableFieldsToJson" transform to read the value year 2026, month 3, and day 23 from the tag's date or timestamp field in the integration table, encode it into "260323", and store it the tag's property in the source_payload field.
• When combined with the "sourcePayloadTimeFormat" property, the server can properly encode and decode a date and time stored in a timestamp field.