topic Null CreatedDate from Salesforce in Talend Studio

Null CreatedDate from Salesforce

Anonymous — Wed, 07 Aug 2019 07:49:07 GMT

I have create a job for Salesforce and Oracle DB Integration via tMap. However i am always getting created date as null in DB and also in tLogRow whereas data is updated properly for LastModifiedDate.

I have also tried using below logic to check if the Date is actually null or being missed because of wrong formatting.

row1.CreatedDate != null ? row1.CreatedDate : TalendDate.getDate("yyyy-MM-dd")

As a result i am always getting today's data in the DB.

Warm Regards,

Ankit Singh

Re: Null CreatedDate from Salesforce

lennelei — Wed, 07 Aug 2019 09:05:50 GMT

Hi,

I don't have a solution for your problem yet but I have some remarks.

The following code shouldn't work in the tMap :

row1.CreatedDate != null ? row1.CreatedDate : TalendDate.getDate("yyyy-MM-dd")

According ro your screenshot, both row1.CreatedDate and CREATION_DATE are Date objects while TalendDate.getDate("yyyy-MM-dd") returns a String.

This code cannot work and you should have a "Type mismatch: cannot convert from String to Date" error message!

Assuming this is not exactly the code you have in your job, and that you have something like this instead:

row1.CreatedDate != null ? row1.CreatedDate : TalendDate.getCurrentDate()

Then, if you have the current date as output, it probably means you have null values as inputs!

Did you try to add a tLogRow before the tMap in order to see the actual values?

Regards

Re: Null CreatedDate from Salesforce

TRF — Wed, 07 Aug 2019 09:35:47 GMT

Having null values for CreatedDate and LastModifiedDate Salesforce fields is just not possible.

Share your job design + details for the tSalesforceInput component.

Re: Null CreatedDate from Salesforce

lennelei — Thu, 08 Aug 2019 08:10:04 GMT

Of course it's possible to have null value before using the second option with ternary operator!

Re: Null CreatedDate from Salesforce

TRF — Thu, 08 Aug 2019 08:33:46 GMT

No.

On salesforce side CreatedDate and LastModifiedDate fields are never null (like id, owner and some others).

So when you get records from salesforce, these fields are allways populated.

If you have null, you have a bug somewhere.

For example, if you enter the SOQL query by yourself, it may arrives if you write createDate instead of CreatedDate in your schema (and the job will not fail).