Workflow with DCM gives back "invalid JSON" error when using desktop automation.

[tristan_urbany]

Hello Everyone,

I'm currently operating an Alteryx Designer setup with desktop automation. I'm eager to utilize Alteryx's DCM feature, especially since I need it when using OAuth Azure AD for MS mail tools.

When I use DCM, the workflow operates perfectly. However, the moment I schedule the workflow, I encounter an "invalid JSON" error message after hitting the cancelation threshold. This issue persists irrespective of the type of connection being used - SMTP, Oracle, or a simple local database connection.

Despite my efforts to find a solution online, I've come up empty-handed. I hope that someone here might be able to provide assistance.

Thank you,

Tristan

the workflow is as simple as these two:

[dorette]

Same issue here. Can't wait to hear of a potential solution

[tristan_urbany]

[tristan_urbany · Accepted solution]

I just found https://alteryx.my.site.com/knowledgecenter/s/article/Invalid-JSON-Error-when-Scheduling-using-Deskt... DCM is not supported for desktop automation.

[acowpy]

Has anyone found a workaround for this? With Snowflake enforcing MFA later this year we need to move to either key pair or OAuth authentication, both of which require DCM which means at present we won't be able to schedule workflows using Desktop Automation.

Has anyone come up with a workaround e.g using embedded python to authenticate?