Calling salesforce report with filters

Hi,

I am using a lookup activity to call salesforce report as mentioned in this doc https://docs.microsoft.com/en-us/azure/data-factory/connector-salesforce?tabs=data-factory#query-tips and it works. I want to know how can I pass filter value for the report by the call method.

I can't find any references that mentions how to pass a filter while calling salesforce report from ADF. Any thoughts?

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MartinJaffer-MSFT · Feb 09 at 05:16 PM

Hello and welcome to Microsoft Q&A @GayatriKrishnan-9239 .

I would like to help you, but I am not terribly familiar with Salesforce. Can you tell me whether a filter is different from the WHERE clause in a query?

0 ·

GayatriKrishnan-9239 MartinJaffer-MSFT · Feb 10 at 07:25 AM

I tried extracting report using Salesforce Service Cloud as mentioned below

Retrieve data from a Salesforce report
You can retrieve data from Salesforce reports by specifying a query as {call "<report name>"}. An example is "query": "{call \"TestReport\"}".