Timezone to import lead in Marketo account CEST | Community
Skip to main content
J
Jay00031987-2
New Participant
December 18, 2020
Question

Timezone to import lead in Marketo account CEST

  • December 18, 2020
  • 1 reply
  • 4163 views

Marketo custom field opt-in date is sent to internal system database as "optinDate" :"2020-11-28 00:24:20", and while exporting lead from Marketo.

Next day, same date is sent to Marketo again via internal system DB "optinDate" :"2020-11-28 00:24:20",via API in this format YYYY-MM-DD hh:mm:ss.0000000 this format but due to that opt-in date is changed with below reason mentioned in Marketo. Our Marketo account timezone is in CEST. Hence, what should be exact format so that optinDate should not change while lead import through API. Can anyone suggest on this issue?

 
 

 

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

1 reply

Katja_Keesom
Katja_Keesom
Community Manager
December 19, 2020

Hi Jayant,

 

First of all, I think your screenshot is not related to the actual activity your question is about. This screenshot shows the datetime zone being adjusted, not the optin datetime. Importing and exporting datetime fields can be a bit tricky, as you need to align the interpretation of the value based on timezones. The best way to avoid this is to include the reference to "zulu time" (GMT) in your API message. For more info please see the  fieldtype explanation here: https://developers.marketo.com/rest-api/lead-database/fields/field-types/

J
Jay00031987-2Author
New Participant
December 22, 2020

I am facing datetime zone being adjusted this is the main pain point. For different country the person timezone is being adjusted when we are doing lead import via API. how can this be fixed in this case?

Jay
Katja_Keesom
Katja_Keesom
Community Manager
December 22, 2020

Hmm, I would need to see what happened in the activity log. Some questions I have:

  • I see in your screenshot a reference to a smart campaign that updated the time zone? In the activity log you should be able to see a hyperlink to that smart campaign to find out what it does exactly.
  • Is the optin datetime synced correctly via the API and then updated in Marketo to the incorrect value or is it received with the incorrect value straight from the API?

Without more information I'm afraid I cannot give you any definitive answers.

Terms & ConditionsAccessibility statement

Loading footer...