1 Reply Latest reply on Jul 11, 2017 12:42 PM by Sanford Whiteman

    Marketo API date & datetime errors

    Michael Tyson

      Hello,

      I have several custom fields I added to our database for our sandbox testing.

       

      When I pull this data from our local repository & try to send to Marketo, I keep getting errors on fields that have the type Date and Datetime: "1003: Invalid value for field ''".

       

      This is because our database (MySQL) has null values with DATE & DATETIME types, so the resulting values come out as 0000-00-00 and 0000-00-00T00:00:00. Unfortunately I need these values to be stored in Marketo as is.

       

      Is there any way around these errors aside from changing the Marketo field's data type to String?