Search code examples
salesforcetalend

Cannot see the custom field created under account in Salesforce on Schema retrieval in Talend

In order to copy Salesforce production data to a sandbox environment, I created a custom field Migration_id which is an external id that will will be mapped as the Account Id.

However, when I use Talend to retrieve the schema, I am unable to see the new column field. Isn't this supposed to be instantaneous? Perhaps I'm missing something? Help would be appreciated.

Solution

  • I've not used Salesforce before but it looks like Talend bundles some prebuilt queries to Salesforce in the tSalesforceInput component.

    You should be able to tick the "Manual input of SOQL query" box and define the query by hand. Make sure to align the component's schema with that of the SOQL query.