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
已提問 4 個月前檢視次數 79 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南