Help CenterContacts and SegmentContacts & Contact ProfileHow to import date time values for the user properties?

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

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

    Segment.io    

Default traits

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?