Get related fields from Salesforce objects using Amazon Appflow

0

Hi, I'm trying to create a flow between Salesforce and Amazon S3 in order to get ready-to-use reports. For that purpose, I need to get related fields of the objects I'm importing. For example, I have an Invoice object which relates to a Contract (one contract may have multiple invoices), and in my report, I would need to get an external id of the contract.

Using SOQL and the Bulk API, I can retrieve this field using the following query: SELECT ID_Contrato__r.External_ID__c FROM Invoice__c, therefore it is possible to get related fields using this API (which can be selected to be used by Appflow). However, in the Appflow console, I can't see any option that allows me to get those related fields. Could you please tell me how can I retrieve them? And if it is not possible, could you explain me why, as the Salesforce API does allow it?

Thank you

awacate
posta 4 mesi fa79 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande