Lookup using a csv and Salesforce

[Jennifer_siders]

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?

[manodwhb]

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

[Jennifer_siders]

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.

[manodwhb]

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

[Jennifer_siders]

Yes,

[manodwhb]

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

[TRF · Accepted solution]

@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".

[Jennifer_siders]

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