Next revision | Previous revision |
transformations:sharepointcommand [2019/09/08 18:36] – created dmitry | transformations:sharepointcommand [2024/02/05 14:46] (current) – craigt |
---|
===== SharePoint Command ===== | {{ transformations:SharePointCommandAction.png}} |
| ====== SHAREPOINT COMMAND ====== |
| Category: Workflow / App/Cloud\\ |
| |
Category: Workflow / External. | \\ |
| =====Description===== |
| This action performs file operations with a SharePoint site. A configured [[connectors:sharepoint|SharePoint connector]] is required. SharePoint Online and on-premises SharePoint sites are supported. |
| |
This action performs file operations with a SharePoint site. Currently, the following commands are available: | Currently, the following commands are available: |
| * List files |
| * Download file |
| * Download files |
| * Upload file |
| * Upload files |
| * Delete file |
| * Delete files |
| * List folders |
| * Create folder |
| * Rename folder |
| * Delete folder |
| * List libraries |
| |
* List files - generate a list of files in specified folder of a SharePoint site | \\ |
* Upload file - upload a single file to SharePoint | =====Action settings===== |
* Upload files - upload to SharePoint multiple files which paths are obtained from specified column | ^ Setting ^ Description ^ |
* Download file - download a single file from SharePoint | |Connector<sup>*</sup>|Select the preconfigured SharePoint connector, or, build one by selecting //Add connector//.| |
* Download files - download from SharePoint multiple files which remote paths are obtained from specified column | |Library<sup>1</sup>|Select the Library to perform the command in.| |
* Delete file - delete a single file | |Command|Select the file operation this action will perform. Options: //List files//, //Download file//, //Download files//, //Upload file//, //Upload files//, //Delete file//, //Delete files//, //List folders//, //Create folder//, //Rename folder//, //Delete folder//, or //List libraries//. See below for details of each command type.| |
* Delete files - delete multiple files which remote paths are obtained from specified column | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ |
| <sup>1</sup> Setting can be specified using a [[:parameters|parameter]] or the first value of a column.\\ |
| |
| \\ |
| ====List files settings==== |
| **Description:** Produce a list of files, with selected details, in a specified folder in the SharePoint site. |
| ^ Setting ^ Description ^ |
| |Folder<sup>*</sup>|Select a folder containing the files to create the file list from.| |
| |Columns|Select the details of the found files to be included in the dataset. Each detail creates a column in the dataset. Options: //File name with full path//, //File name only//, //File extension//, //Size//, //Date created//, and //Date modified//.| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| |
| \\ |
| ====Download file settings==== |
| **Description:** Downloads the specified file from the SharePoint site to the local location defined. |
| ^ Setting ^ Description ^ |
| |File path<sup>*</sup>|Enter or browse to the file in the SharePoint site to be downloaded.| |
| |Local folder<sup>*</sup>|Enter or browse to the local folder to download the file to.| |
| |If a file with such name already exists|Select how EasyMorph will handle saving the file if a file with the same name exists in the destination folder. Options: //Overwrite//, //Do nothing//, or //Halt project execution//. See the "File already exists" table below.| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| |
| \\ |
| ====Download files settings==== |
| **Description:** Downloads multiple files specified in a column in the action's input dataset from the SharePoint site. |
| ^ Setting ^ Description ^ |
| |File list|Select the table column containing the list of fully qualified file names to be downloaded.| |
| |Local folder<sup>*</sup>|Enter or browse to the local folder to download the files to. This action will //overwrite// files with the same name(s)\\ that already exist(s) in the destination folder.| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| |
| \\ |
| ====Upload file settings==== |
| **Description:** Uploads the specified local file to the defined SharePoint folder. |
| ^ Setting ^ Description ^ |
| |File path<sup>*</sup>|Enter or browse to the local file to upload.| |
| |Target folder<sup>*</sup>|Enter or browse to a SharePoint folder to upload the file to.| |
| |If a file with such name already exists|Select how EasyMorph will handle saving the file if a file with the same name exists in the destination folder. Options: //Overwrite//, //Do nothing//, or //Halt project execution//. See the "File already exists" table below.| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| |
| \\ |
| ====Upload files settings==== |
| **Description:** Uploads multiple files specified in a column in the action's input dataset to a folder on the SharePoint site. |
| ^ Setting ^ Description ^ |
| |File list|Select the table column containing the list of fully qualified local file names to be uploaded.| |
| |Target folder<sup>*</sup>|Enter or browse to a SharePoint folder to upload the files to. This action will //overwrite// files with the same name(s)\\ that already exist(s) in the destination folder.| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| |
| \\ |
| ====Delete file settings==== |
| **Description:** Deletes the specified file stored on the SharePoint site. |
| ^ Setting ^ Description ^ |
| |File path<sup>*</sup>|Enter or browse to the remote file on the SharePoint site to delete.| |
| |If the file doesn't exist|Select how EasyMorph handles situations when the specified file does not exist. Options: //Do nothing// (nothing\\ happens, the workflow continues, no error is displayed), or //Halt project execution// (workflow stops, an error is displayed).| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| |
| \\ |
| ====Delete files settings==== |
| **Description:** Deletes multiple files specified in a column in the action's input dataset from the SharePoint site. |
| ^ Setting ^ Description ^ |
| |File list|Select the table column containing the list of fully qualified file names to be deleted from the SharePoint site.| |
| |If a file from the list doesn't exist|Select how EasyMorph handles situations when a file in the list does not exist. Options: //Ignore// (nothing\\ happens, the workflow continues, no error is displayed), or //Halt project execution// (workflow stops, an error is displayed).| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]]. |
| |
| \\ |
| ====File already exists options==== |
| ^Option ^Description ^ |
| |Overwrite|The new file replaces the original file.| |
| |Do nothing|No file is downloaded/uploaded, the workflow does not halt, and no error is displayed.| |
| |Halt project execution|The project will stop processing and this action will display an error.| |
| |
| \\ |
| ====List folders settings==== |
| **Description:** Produce a list of subfolders under the selected folder. |
| ^ Setting ^ Description ^ |
| |Folder<sup>*</sup>|Select a folder on SharePoint to retrieve a list of subfolders from.| |
| |Columns|Select the details of the found subfolders to be included in the dataset. Each detail produces a column.\\ Options: //Folder name with full path//, and //Folder name only//.| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ |
| |
| \\ |
| ====Create folder settings==== |
| **Description:** Create a new SharePoint folder under the selected parent folder. |
| ^ Setting ^ Description ^ |
| |Parent folder<sup>*</sup>|Select a folder on SharePoint to create the new folder under.| |
| |Folder name<sup>*</sup>|Enter the name of the new folder.| |
| |If a folder with such name already exists|Choose how EasyMorph behaves if a folder with the //Folder name// already exists. Options: //Fail// (the workflow stops with a warning) or //Do nothing// (the workflow continues without creating the new folder).| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ |
| |
| \\ |
| ====Rename folder settings==== |
| **Description:** Rename the selected SharePoint folder. |
| ^ Setting ^ Description ^ |
| |Folder<sup>*</sup>|Select the folder on SharePoint to rename.| |
| |New name<sup>*</sup>|Enter the new name for the selected folder.| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ |
| |
| \\ |
| ====Delete folder settings==== |
| **Description:** Delete the selected SharePoint folder. |
| ^ Setting ^ Description ^ |
| |Folder path<sup>*</sup>|Select the folder on SharePoint to delete.| |
| |If the folder doesn't exist|Choose how EasyMorph behaves if the selected folder does not exist. Options: //Do nothing// (the workflow continues without creating the new folder) or //Fail// (the workflow stops with a warning).| |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ |
| |
| \\ |
| ====List libraries settings==== |
| **Description:** This mode generates a dataset of the libraries in the SharePoint site that includes //Title//, //Description//, and //Type// columns. No other settings are required. |
| |
| \\ |
| =====Remarks===== |
| The easiest way to build a list of remote files on a SharePoint site to be downloaded or deleted is to use this action in its //File list// configuration, including the "File name with full path" option. This list can then be modified to generate the final list of files to be downloaded or deleted. |
| |
| \\ |
| =====See also===== |
| * [[transformations:filecommand|File command]] |
| * [[transformations:filelist|List of files]] |
| * [[transformations:amazoncommand|Amazon S3 command]] |
| * [[transformations:azureblobstoragecommand|Azure Blob Storage command]] |
| * [[transformations:dropboxcommand|Dropbox command]] |
| * [[transformations:googledrivecommand|Google Drive command]] |
| * [[transformations:onedrivecommand|OneDrive command]] |
| |
The action requires a configured SharePoint connector. SharePoint Online and on-premises SharePoint sites are supported. | |