community
cancel
Showing results for 
Search instead for 
Did you mean: 

Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!
SOLVED

Salesforce Input Connector - Selecting Deleted Records

Alteryx Certified Partner

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.

Asteroid

Sorry, yes you are correct, been too long since I did it. Thanks

Asteroid

@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!

Sr. Community Content Manager
Sr. Community Content Manager

Hi @mpurdy,

 

You're right we re-wrote this tool using our HTML/JavaScript SDK so you will no longer find a macro. But you can still make a copy of the tool and customize it, as you did before. I believe the relevant line of code that you're looking for is line  274 in the Salesforce.js file:

url = url + '/services/data/v'+apiVersion+'.0/query/';

Happy hacking!

 

-Neil

Thank you Neil! :D

Meteor

Hi,

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.


Thanks!

Asteroid

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.

Meteor

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?

 

Thanks!

Sr. Community Content Manager
Sr. Community Content Manager

You will need to add the new custom tool to your server.

Meteor

Thought so. Thank you for the confirmation!