Insert a record on Salesforce, issue with DateTime format

Stefano81 — Mon, 24 Feb 2025 10:38:41 GMT

Hello

I have to insert a new record into Sfdc Object, the field EndDate__c datetime is not populated.

In my TMap I have input

Column - EndDate ; Type - Date ; Date Pattern - "yyyy-MM-dd'T'HH:mm:ss'.000Z'"

then in my TMap the output vs Salesforce

Column - EndDate__c; Type - Date ; Date Pattern - "yyyy-MM-dd'T'HH:mm:ss'.000Z'"

the field is always empty, I tried in a different way without success

I added a t_log and the input it seems fine

|EndDate__c |
|2025-03-28T00:00:00.000Z|

best regards,

Stefano

Re: Insert a record on Salesforce, issue with DateTime format

quentin-vigne — Mon, 24 Feb 2025 13:03:01 GMT

Maybe try to debug it by inserting a forced value like instead of out.yourcolumn in your tMap use :

TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss'.000Z'", "2025-02-24T00:00:00.000Z")

Did you check that EndDate__c in Salesforce is a DateTime field, not just a Date field ?

If this doesn't solve your issue can you share other screenshots of your Job and your tMap ?