Salesforce input tool - custom query

[Robert_Ziarno]

Hi,

when I am using Salesforce input tool (Python based) and query builder then I don' have any issues when running such workflow on Alteryx Server. However, when I use custom query in Salesforce input tool then I got error unauthorized on Alteryx Server.

Any ideas why this is not working?

[mceleavey]

Hi @Robert_Ziarno ,

I'm not sure what you're having problems with. Can you show screen shots of the differences between the two, and the error?

M.

[Robert_Ziarno]

HI @mceleavey, sorry for late reply. I did some more tests and it seems that issue is with query type. When I run this workflow from designer then it is working fine, even when I save it to gallery and run just after saving it runs successfully. However, if I enable schedule then when workflow is run after some time I got this error (401) for custom query. Same happens after some idle time in designer (last screenshot). Strange that custom query and query builder behaves in different way. Any ideas why is this happening?

[mceleavey]

Hi @Robert_Ziarno ,

This sounds like an authorisation error due to the user account.

If you run it from the Designer or manually through the gallery it's using your user account. When you schedule it, it runs from the Alteryx service account on the server. If your service account is not authorised to access Salesforce it will error.

Try either setting up the Service account as an authorised user in Salesforce, or changing the service account on the Alteryx server to your account.

Hope this helps,

M.

[Robert_Ziarno]

Hi @mceleavey  found what the issue is Refresh Salesforce access tokens - Alteryx Community