Marketo API date & datetime errors | Community
Skip to main content
A
Anonymous
July 11, 2017
Solved

Marketo API date & datetime errors

  • July 11, 2017
  • 1 reply
  • 1875 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

Well, 0000-00-00 has never been a valid ISO8601 date, like 2017-00-00 is not valid.

0000-01-01 is technically valid (though unsupported by Marketo anyway).

At any rate, if you can't send a blank value you need to use a String (which will mean datetime queries won't work).

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
July 11, 2017

Well, 0000-00-00 has never been a valid ISO8601 date, like 2017-00-00 is not valid.

0000-01-01 is technically valid (though unsupported by Marketo anyway).

At any rate, if you can't send a blank value you need to use a String (which will mean datetime queries won't work).

Terms & ConditionsAccessibility statement

Loading footer...