Insert a record on Salesforce, issue with DateTime... - Qlik Community

Stefano81 · ‎2025-02-24

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

quentin-vigne · ‎2025-02-24

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 ?

Insert a record on Salesforce, issue with DateTime format