tSalesforceInput Limitations - 6.4

Talend Data Fabric Release Notes

EnrichVersion
6.4
EnrichProdName
Talend Data Fabric
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity Management
Talend Installer
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Project Audit
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

The following SOQL queries are not supported for the guess schema and guess query features of tSalesforceInput:

  • the SOQL query using the aggregate function

  • the SOQL query using the TYPEOF expression

  • the SOQL query using alias

  • the prefix in the SOQL query is the same as the module name after FROM

    For example, SELECT Account.Name, (SELECT Contact.LastName FROM Account.Contacts) FROM Account is not supported, while SELECT Name, (SELECT LastName FROM Contacts) FROM Account that performs the same function is supported.

  • the SOQL query with multiple modules after FROM

    For example, SELECT Contact.Firstname, Account.Name FROM Contact,Contact.Account is not supported. However, the child-to-parent and parent-to-child relationship queries are supported, so this query can be improved to SELECT Firstname, Account.Name FROM Contact.

  • the SOQL query using toLabel()

  • the field with the underscore character '_' in its name