topic tSalesforceInput - Manual Query - Bulk -> NULL values - Query -> filled values in Talend Studio

tSalesforceInput - Manual Query - Bulk -> NULL values - Query -> filled values

joboro1 — Sat, 16 Nov 2024 04:01:48 GMT

Hello everybody,

I try to pull data from Salesforce via bulk query (via tSalesforceInput).
I use a "manual query", which is structured as follows:

Select Id, Contact.Id, Account.Id, Contact.Name, Contact.LastName, Contact.FirstName, Account.Name
from User 
where isactive=true
and Contactid != null

I created the corresponding schema according to the syntax, i.e. User_Contact_id, User_Account_Name etc..

If the component runs in query mode "bulk", all non-user fields are null.
If the component runs in query mode "query", all non-user fields are filled.

Is this an intended behavior and is it possible to get the bulk mode work with the manual query?

We use Integration Studio 6.4.1.

Re: tSalesforceInput - Manual Query - Bulk -> NULL values - Query -> filled values

TRF — Mon, 25 Nov 2019 15:49:02 GMT

If you have less than 50,000 rows, don't use bulk (not necessary).

Don't why the result is different in your case.

Re: tSalesforceInput - Manual Query - Bulk -> NULL values - Query -> filled values

Fred_FM — Thu, 20 May 2021 09:52:43 GMT

Hello All,

I know this is an old thread, but i encounter exactly the same problem.

The number of rows is > 500.000 and is going to increase, so non bulk query is not an option.

@Joerg Bohlen if you read this, did you find a solution ?

Thanks for your response