Sharepoint Input tool error

sabitha_alt

I have workflow that reads a list from sharepoint->select tool->data stream in->writes to DB. Able to run workflow manually in designer with no issues but when i run workflow on server it executes but grabs the field that do not have the same name. Getting warning  in server as "Field is missing, Compare tool configuration with input stream". For example i have "First Name" , "Content Type" "Last Name" field in select tool but on server it says missing fields and writes field to db as First Name_0, Content Type_1, Last Name_2

jrgo

Hi @sabitha_alt 

Most likely cause is that the SharePoint tool is failing to authenticate when it tries to run on Server. There's a long explanation for why this is the case, which I won't get into, but the short of it is that Python based tools with the HTML tool configuration interface, credentials that are entered will only work when the workflow is ran on your machine.

In order to get it to work, you have to utilize the Data Connection Manager (DCM) to establish the connection then sync your DCM with your server. This will then allow server to supply the workflow with the credential it needs at run time.

This is explained further in these help docs.

https://help.alteryx.com/current/en/designer/data-sources/microsoft-sharepoint.html#idp391615 

https://help.alteryx.com/current/en/designer/tools/dcm---designer.html#data-connection-manager-configuration