topic Re: Lookup using a csv and Salesforce in Talend Studio

Lookup using a csv and Salesforce

Jennifer_siders — Sat, 16 Nov 2024 02:07:49 GMT

Hi there,

I am new to Talend and building a small job to test the lookup functionality.

I have a csv file that has id value using which i need to get the value from 'Name' field. When i run the query from tsalesforceinput manually using the id, i do get the NAME value. can anyone correct me?

Re: Lookup using a csv and Salesforce

manodwhb — Wed, 17 Jun 2020 14:04:22 GMT

@Jennifer_siders ,your job design is correct are you sure do you have matching records between csv and slaesforce object on id?

Re: Lookup using a csv and Salesforce

Jennifer_siders — Thu, 18 Jun 2020 01:07:10 GMT

Hi @manodwhb Thanks for the response.

There is indeed a value, i have even tried putting the same query with hard coding the value as shown but still no output.

Re: Lookup using a csv and Salesforce

manodwhb — Thu, 18 Jun 2020 05:20:28 GMT

@Jennifer_siders , I am sure that it is not matching with id, since you need to verify file do you have same id value ?

Re: Lookup using a csv and Salesforce

Jennifer_siders — Thu, 18 Jun 2020 05:46:13 GMT

Yes,

Re: Lookup using a csv and Salesforce

manodwhb — Thu, 18 Jun 2020 06:41:45 GMT

@Jennifer_siders ,if yes you might have some space in file data, check that?

Re: Lookup using a csv and Salesforce

TRF — Thu, 18 Jun 2020 07:11:46 GMT

@Jennifer_siders fields name in tSalesforceInput component MUST match exactly with those from the query, including the case.

So, when you write "select id, name..." fields must be "id" and "name", not "Id" and "Name".

Re: Lookup using a csv and Salesforce

Jennifer_siders — Thu, 18 Jun 2020 07:26:03 GMT

Thanks @TRF seems thats the trick while dealing with queries.