nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Salesforce Input Connector - Selecting Deleted Records

mpurdy

I was wondering if it was possible to select deleted records using the Salesforce Input Connector? Thanks in advance for any help that you can provide.

Input

Salesforce

Accepted answers

mpurdy

I have done some more reading and research and found that if I modify the link in the file: "Alteryx\bin\RuntimeData\Macros\Supporting_Macros\SalesforceInput" from "/services/data/v20.0/query/?q=" to "/services/data/v29.0/queryAll/?q=" then I can pick up the deleted records - using "IsDeleted = TRUE". Do you know what the implications are of making this change are? Thanks

NeilR

I can't speak to the implications but I can help you make a new tool using the modified macro that you created (nice job with that, by the way).

Navigate to the HtmlPlugins folder within your Alteryx installation (eg C:\Program Files\Alteryx\bin\HtmlPlugins) and make a copy of the "Salesforce Input" folder, then rename the copy what you'd like the new tool to be called (eg "Salesforce Input - Query All")
Within the new folder that you just created, rename "Salesforce InputConfig.xml" to "[New folder name]Config.xml" (eg "Salesforce Input - Query AllConfig.xml").
Open the aforementioned xml file in a text editor. Change the reference to the underlying macro to point to the new custom macro you created (eg "Supporting_Macros/SalesforceInput.yxmc" -> "Supporting_Macros/SalesforceInput-QueryAll.yxmc"

At this point, if you restart Alteryx, you should have a working version of your new tool in the "Laboratory" tool category.

All comments

NeilR

You should be able to by adding the following to the "Where Clause (SOQL)" input parameter:

isDeleted = TRUE

mpurdy

Thanks for the feedback. I have tried this for the Account object in Salesforce but it does not return any records (this is the only filter I am using in the Salesforce Input tool).

I log into SF (using the same credentials that I have used in Alteryx) and I can see Accounts that have been deleted in the recyling bin.

I have read that you have to execute your SOQL query in APEX to select deleted records (and use the keywords "ALL ROWS") and I assume that Alteryx would have this limitation as well?

Thanks in advance for any insight you can offer.

NeilR

In that case it may not be possible with the REST API, which is what Alteryx uses to pull data from Salesforce, but probably worth checking with your SFDC rep or admin before giving up.

mpurdy

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15898

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703