Date is invalid - Marketo components

[Francois61]

Hi community,

I am trying to use the Marketo components to get infomation on leads but I have issues with date formats.

With the REST API, the default format given for getLeadChanges operation is "yyyy-MM-dd HH:mm:ss Z" but when I try with this format I have an error.

Exception in component tMarketoInput_1 (MarketoLeadsGetCreated)
java.lang.RuntimeException: Since date time is invalid.
    at marketoleadsgetcreated_0_1.MarketoLeadsGetCreated.tMarketoInput_1Process(MarketoLeadsGetCreated.java:1199)
    at marketoleadsgetcreated_0_1.MarketoLeadsGetCreated.runJobInTOS(MarketoLeadsGetCreated.java:2492)
    at marketoleadsgetcreated_0_1.MarketoLeadsGetCreated.main(MarketoLeadsGetCreated.java:2207)
[FATAL]: marketoleadsgetcreated_0_1.MarketoLeadsGetCreated - tMarketoInput_1 Since date time is invalid.

I have tried many dates format but none of them work.

I also tried the same function (getLeadChanges) with the SOAP API where the format is different (like "2018-01-01T01:00:00+0800") but even the default dates given by Talend raise the same error (date time is invalid).

Marketo datetime should be like "2010-05-07T15:41:32-05:00" (http://developers.marketo.com/rest-api/lead-database/fields/field-types/).

I am not sure how to debug this, it is a runtime exception but I can't find where the date is parsed.

Any help greatly appreciated!

(I use Talend Data Fabric 6.4.1)

[Anonymous · Accepted solution]

Hello,

Could you please refer to this jira issue about: "tMarketoInput doesn't work with getLeadActivity"? This issue has been fixed on 6.4.2, 6.5.1, 7.0.1

https://jira.talendforge.org/browse/TDI-39141

Best regards

Sabrina

[Francois61]

Thanks!