Cannot Update/Insert a Date Value Containing "T" via REST API using Triggered Send
Trailblazer Community

Cannot Update/Insert a Date Value Containing "T" via REST API using Triggered Send

Marketing Cloud API , Marketing Cloud Sending

Last updated 2019-10-31 ·Reference W-6309721 ·Reported By 1 users

Fixed in version Marketing Cloud October 2019 Release

Summary
Learn how to work around a known issue with the REST API endpoint POST /messaging/v1/email/messages/{messageKey}, where the payload includes a date value with the "T" character (which is a legitimate character in a date type value).

Repro
1. [UI] Create a new sendable DE with a date field
2. [UI] Create a new email
3. [API] Create a send definition using the above
4. [API] Use the transactional send REST API to send an email. Include the date value in this format: yyyy-mm-ddTHH:MM:SS (the "T" needs to be included).

5. [RESULT]

{
"requestId": &requestId,
"statusCode": 20,
"statusMessage": "InvalidFieldValue",
"eventCategoryType": "TransactionalSendEvents.EmailNotSent",
"timestamp": "yyyy-mm-ddTHH:MM:SS.sss"
}

Workaround
Omit the "T" from the timestamp in the API call.

Reported By (1)

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.