Uploading documents to Sharepoint from within Automator

Altair Forum User

I am new to both Datawatch Server (Automator) and SharePoint Online. I see it is possible in the Automator documentation but it only says to enter the Sharepoint document library URL.

Has anyone out there been successful at using Automator to create content within SharePoint document libraries, and if so, do you mind sharing how you were able to do it?

Thanks,

Dean

Altair Forum User

Hi Dean,

If the SharePoint is 365, you need to use a public folder in the SharePoint to write or read files.  If the SharePoint is not a 365, and requires Active Directory account, then Automator service account or a domain account should have full access to that folder.

In the Automator standard process, within the project object, If you need to read an input file, you can specify a SharePoint URL followed by a file name within the input tab, and then under the Login Credential tab, you can either check the "Use Datawatch Service credentials" box for reading the file using the service account, or provide an Active directory account username and password in the HTTP login section.

If you need to write to the SharePoint, in the project export enter the SharePoint URL, and a file name, then specify the credential in the Login Credential tab.

 

In Visual process, you an specify a SharePoint URL and input file name in the Input file object, then use the Credential object to specify the SharePoint credential (either a AD account or Service Account).  If you need to write to the SharePoint, specify a SharePoint URL in the Export table/summary object, and specify the SharePoint login credential in the Credential object.

Regards

Mo

Altair Forum User

Altair Forum User said:

Hi Dean,

If the SharePoint is 365, you need to use a public folder in the SharePoint to write or read files.  If the SharePoint is not a 365, and requires Active Directory account, then Automator service account or a domain account should have full access to that folder.

In the Automator standard process, within the project object, If you need to read an input file, you can specify a SharePoint URL followed by a file name within the input tab, and then under the Login Credential tab, you can either check the "Use Datawatch Service credentials" box for reading the file using the service account, or provide an Active directory account username and password in the HTTP login section.

If you need to write to the SharePoint, in the project export enter the SharePoint URL, and a file name, then specify the credential in the Login Credential tab.

 

In Visual process, you an specify a SharePoint URL and input file name in the Input file object, then use the Credential object to specify the SharePoint credential (either a AD account or Service Account).  If you need to write to the SharePoint, specify a SharePoint URL in the Export table/summary object, and specify the SharePoint login credential in the Credential object.

Regards

Mo

It is SharePoint Online (O365), so I am now looking up how to create a public folder in SharePoint Online. The results I am getting are "Create a Public Folder on Exchange Online" and "Turn Folders on in SharePoint Online", Am I overthinking this or do you just mean that I need to create a folder in a document library and share it with everyone.

 

I am only looking to write to SharePoint at this time. I can select the destination source type as Web and enter the URL and file name but there is no Login Credentials Tab or at least I don't see one in Automator. When I run the job in Automator I get an error "Export failed. The remote server returned an error: (405) Method Not Allowed.