topic tSalesforceOutput vs tSalesforceOutputBulkExec for Date field : a timezone problem in Talend Studio

tSalesforceOutput vs tSalesforceOutputBulkExec for Date field : a timezone problem

Anonymous — Sat, 16 Nov 2024 03:26:04 GMT

Dear community,

After having worked with Salesforce components, I conclued to this two rules :

When using tSalesforceOutputBulkExec : I must be sure that my Date field values are in timezone "UTC". (It feels OK to me because Salesforce stores every DateTime with UTC timezone)
When using tSalesforceOutput : I must be sure that my Date field values are in timezone "Europe/Paris" (my timezone). (It feels strange to me)

My first problem here is to answer the questions below:

When using tSalesforceOutput,
- who (Salesforce or Talend) knows my timezone ?
- how does it get that information ?

I have already tested to modified the timezone of

My PC
My Salesforce User

and it didn't affect the way my Date field values had been processed...

Re: tSalesforceOutput vs tSalesforceOutputBulkExec for Date field : a timezone problem

TRF — Tue, 28 Jan 2020 16:58:49 GMT

The timezone depends on the user defined for the salesforce connection.

You need to get the value from the User object.

Re: tSalesforceOutput vs tSalesforceOutputBulkExec for Date field : a timezone problem

Anonymous — Tue, 28 Jan 2020 18:07:32 GMT

Thank you for your answer TRF,

I tried again to modify the Salesforce user timezone (field User.TimeZoneSidKey) with a timeZone (Asia/Hong_kong GMT+08) very different of "Europe/Paris" (GMT +01). I verified with Workbench, it has been well applied. I modified the user I am using for my connection.

I tried to : get a single record from an object : ID+MyDateTimeField with a tSalesforceInput, and then without any transformation, to update the record with tSalesforceOutput.

The result : I get +1hour to my MyDateTimeField as result

So it make me think that editing the Salesforce user timezone is not the right solution...

Re: tSalesforceOutput vs tSalesforceOutputBulkExec for Date field : a timezone problem

TRF — Tue, 28 Jan 2020 19:14:00 GMT

Can you share the values used for the example?
Usually I set the timezone for the user used for integration to GMT and I convert all datetime from the original timezone to GMT before to push records to salesforce. This is usefull when records you want to load into salesforce are not aligned on a single timezone.

Re: tSalesforceOutput vs tSalesforceOutputBulkExec for Date field : a timezone problem

Anonymous — Wed, 29 Jan 2020 10:13:47 GMT

Here is an example of a run with "Europe/Paris" configure for my Salesforce User (as for my PC): Please observe the +1hour on the datetime field value

No transform action, but the datetime field value changes

By the way, I have observed that my Datetime field value doesn't change when I configure my OS Timezone as "(UTC+08:00) Beijing, Congqing, Hong Kong (R.A.S.), Urumqi".

The OS Timezone seems to be very related to this case

Re: tSalesforceOutput vs tSalesforceOutputBulkExec for Date field : a timezone problem

TRF — Wed, 29 Jan 2020 10:32:32 GMT

Hum...

What when you query the value using the Salesforce Developer Console?

Re: tSalesforceOutput vs tSalesforceOutputBulkExec for Date field : a timezone problem

Anonymous — Thu, 06 Feb 2020 17:16:11 GMT

I have never used Salesforce Developer Console.

I will be able to do so in few days, then I will answer to you! Thank you