Thanks for the quick response!! I was able to create a copy of the macro and return the isDeleted records.
One minor thing to call out is that the formula tool that needs updated is actually in the "Build Query" container. In the lone formula tool in that container, update the URL formula. Just wanted to call this out for anyone else trying to make the change to the macro.
@NeilR if I am trying to duplicate the control SalesForceInput (the new SF Input Connector) how do I do this? It looks like it is now written in the js file and I can edit the query in there so that it does a "queryAll" instead of just a "query". Thanks!
url = url + '/services/data/v'+apiVersion+'.0/query/';
We are in the same situation, where we'd need to query for deleted records. Other than replacing the line in the .js file, is there no other way around this? Since this might affect all workflows using the SalesforceInput.
Hi, no I wouldn't recommend making the change in the Alteryx Salesforce Input tool, I'd make a copy and update that version instead. Then you can use the new tool when you need to query deleted records.
Hi, Thanks. I am fairly new to alteryx. So, I've made a copy of the SalesforceInput (Input-Queryall) and replaced the .js file there. Using this new input does bring up the deleted records. But, what happens when we move this workflow to the server as a scheduled job. Would it still be functional?