I have a SF report created in the Salesforce of type 'Contacts With Opportunities'. I need to set the ETL automation for this report using python.: Please have a look at following screenshot:
I have tried to download this report using 'Salesforce Reports and Dashboards REST API' but SF Reports API has limit where we can only pull 2000 records and my report has more than 2000 records. So I believe Reports API would not be the solution for me.
So, as an alternative I was thinking to create an SOQL query to pull this information. Is it possible to get this information using SOQL? If Yes, then you can see that in the report filter conditions there is a cross filter condition to filter the 'Contacts' based on the 'Campaign History'. In SF we need some relationship fields to filter parent records using child records. But I am not sure which relationship field is there between 'Contacts' and 'Campaign History'.
Can anyone help me here?