Salesforce Input Slow to Load

I have four different Salesforce input tools in my workflow, three running custom queries. I have these grouped and usually disabled because I write the query to an Alteryx database. When I enable the group, Alteryx freezes up for 3-5 minutes. I get this same behavior when opening up the workflow, group not disabled, and click on an individual input tool, then Alteryx will freeze for a shorter period. Is the input tool trying to connect to Salesforce in this time? Why is it taking so long?

Thanks for any feedback.

Input

Salesforce

Accepted answers

JeffF

@vancelopez Your workflow is waiting for the metadata to load from Salesforce so the configuration panel can be populated and down steam tools are aware of the fields coming in. Salesforce connectors in a disabled Tool Container do not connect to get the metadata. The time it takes to retrieve the metadata depends on the queries you are running and your connection speed.

Metadata is requested when a workflow is opened and when tools are enabled in a tool container.

To speed development of a workflow, you can cache your input with the Cache Dataset Macro (https://gallery.alteryx.com/#!app/CacheDataset-V2--Installer-/57087ee23df7da0fb4056e39) and disable all Salesforce inputs. Here is more information about the Cache Dataset Macro.

http://community.alteryx.com/t5/Engine-Works-Blog/The-Cache-Dataset-Macro/ba-p/3162

I hope that helps.

All comments

JeffF

Metadata is requested when a workflow is opened and when tools are enabled in a tool container.

http://community.alteryx.com/t5/Engine-Works-Blog/The-Cache-Dataset-Macro/ba-p/3162

I hope that helps.

vancelopez

Thanks, Jeff. That macro looks like exactly what I need.

vancelopez

@JeffF Is there anyway, other than disabling tool, to stop the connector from pulling the metadata? I usually have a few connectors (because the tool has troubling parsing more complicated queries). If I've changed my SFDC password, the connectors try to login via the old password, causing the API to lockout my account. A change of password is required. This starts a cycle of lockouts. The next time I open a workflow that has the old login info, I get locked out. I'm having to reset my SF password daily.

It would be great if the tool could have the option of when to collect the metadata, i.e. not when opening the workflow or enabling a container.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703