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 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则