polymorphic relationship talend soql tsalesforceInput

EV89 — Mon, 24 Aug 2020 13:15:35 GMT

Legend

salesforce object

salesforce field

Hello,

is possible change schema of tSalesforceInput for retrieve polymorphic relationship information?

i'll try to explain better:

I need to extract from salesforce some attachment information. One information is about the type value of the parentId lookup.

I can perform this query "select id, createddate, parent.type from attachment"

in workbench or use parent.type in salesforce connector in the where conditions. But i cannot retrieve parent.type as field.

I have already try to add parent_type (replace dot with underscore) field in the connector schema and i had retrieved invalid_field error.

P.s

( parent.type possible values can be "invoice, log, ecc ecc")

( ParentId is a lookup to different salesforce object)

thanks for your help

Re: polymorphic relationship talend soql tsalesforceInput

EV89 — Tue, 25 Aug 2020 11:01:01 GMT

The solution is after have add the new column in the schema, flag "manual query" in basic view and insert the custom query.

See the following link, the Extracting data from a Salesforce database using the SOQL query scenario:

Curious topic:

It Is curious about the example that the column in the schema seems work without be compliant with the

NameofCurrentObject_NameofLinkedObject_NameofColumnofInterest path.

See attachment file for real working case.

P.s also "SELECT Id, Name, IsDeleted, Account.Name FROM Contact" query works.