topic Re: Salesforce Manual Query - child relationships in Talend Studio

Salesforce Manual Query - child relationships

Anonymous — Sat, 16 Nov 2024 12:29:46 GMT

Using tSalesforceInput you can specify a manual query, e.g.
"Select Firstname,Lastname,Account.Name from Contact where Lastname like 'A%'"
How can I access the field Account.Name within an expression in tMap? You don't seem to be able to specify a column name with a '.' in it?

Re: Salesforce Manual Query - child relationships

Anonymous — Wed, 21 Dec 2011 02:57:06 GMT

Hi
Yes. Talend doesn't support you specify a column name with a '.' in it.

"Select Firstname,Lastname,Account.Name from Contact where Lastname like 'A%'"

Specify the query manually and edit the schema with a column 'Accoount_Name'.
Try this. Can column map the field Account.Name automatically?
Wait for your feedback.
Best regards!
Pedro

Re: Salesforce Manual Query - child relationships

Anonymous — Thu, 22 Dec 2011 09:15:26 GMT

It works! Awesome!