How to import date time values for the user properties?
Last updated December 24, 2023
Import from CSV
- Mailmodo recognizes and stores values in YYYY-MM-DD format for the DateTime properties uploaded via CSV. Values in any other format will not be stored
Please refer to this article for formatting your date values into the YYYY-MM-DD format using MS Excel or Google Sheets
Add through addToList API
- Properties with the values in ISO format at the time of the first encounter by Mailmodo will be assigned date data type. Post that, the values can be sent in both ISO as well as Unix (in seconds)
- Values not in ISO/Unix will be sent an error response with the message "The <property_name> property accept(s) values in UNIX/ISO format"
Import from Apps
HubSpot, Mixpanel, and Salesforce
Default properties
- Please refer to this article for the date properties getting imported from the default properties in HubSpot
- Please refer to this article for the date properties getting imported from the reserved properties in Mixpanel
Non-default properties
- Properties with values in ISO at the time of the first encounter by Mailmodo will be assigned date data type. Post that, the values can be sent in both ISO as well as Unix (in seconds)
- While syncing, values adhering to ISO/Unix will be stored and the rest will be ignored
Default traits
- Please refer to this article for the date properties getting imported from the default properties in HubSpot
Custom traits
- Properties with values in ISO at the time of the first encounter by Mailmodo will be assigned date data type. Post that, the values can be sent in both ISO as well as Unix (in seconds)
- Values not adhering will be sent an error response with the message "The <property_name> property accept(s) values in UNIX/ISO format"
Was this article helpful?