Execute soql query
It will be great if we have an action to execute soql query in salesforce connector , Since salesforce triggers can poll for single salesforce object
Sid Stusinski commented
Absolutely! We integrate a small number of records in the scope of a much larger data set from salesforce. Although the filtering will work, the trigger fires over 80% of the time for records we do not need. Having the SOQL would reduce the "noise" records we do not need for the logic app.
Chandra Sekhar commented
Absolutely, when there are over a million records in an object and all I need is 20 records to iterate through within Logic App, we absolutely need ability to execute SOQL with multiple filter conditions without having to tinker with the ODATA filtering. Do the filtering at the source rather.