User Tools

Site Tools


transformations:sharepointcommand

SHAREPOINT COMMAND

Category: Workflow / App/Cloud


Description

This action performs file operations with a SharePoint site. A configured SharePoint connector is required. SharePoint Online and on-premises SharePoint sites are supported.

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


Action settings

Setting Description
Connector*Select the preconfigured SharePoint connector, or, build one by selecting Add connector.
Library1Select the Library to perform the command in.
CommandSelect 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.

* Setting can be specified using a parameter.
1 Setting can be specified using a 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*Select a folder containing the files to create the file list from.
ColumnsSelect 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, Date modified, Created by and Modified by.

* Setting can be specified using a parameter.


Download file settings

Description: Downloads the specified file from the SharePoint site to the local location defined.

Setting Description
File path*Enter or browse to the file in the SharePoint site to be downloaded.
Local folder*Enter or browse to the local folder to download the file to.
If a file with such name already existsSelect 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.

* Setting can be specified using a 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 listSelect the table column containing the list of fully qualified file names to be downloaded.
Local folder*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.

* Setting can be specified using a parameter.


Upload file settings

Description: Uploads the specified local file to the defined SharePoint folder.

Setting Description
File path*Enter or browse to the local file to upload.
Target folder*Enter or browse to a SharePoint folder to upload the file to.
If a file with such name already existsSelect 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.

* Setting can be specified using a 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 listSelect the table column containing the list of fully qualified local file names to be uploaded.
Target folder*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.

* Setting can be specified using a parameter.


Delete file settings

Description: Deletes the specified file stored on the SharePoint site.

Setting Description
File path*Enter or browse to the remote file on the SharePoint site to delete.
If the file doesn't existSelect 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).

* Setting can be specified using a 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 listSelect 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 existSelect 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).

* Setting can be specified using a parameter.


File already exists options

Option Description
OverwriteThe new file replaces the original file.
Do nothingNo file is downloaded/uploaded, the workflow does not halt, and no error is displayed.
Halt project executionThe 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*Select a folder on SharePoint to retrieve a list of subfolders from.
ColumnsSelect the details of the found subfolders to be included in the dataset. Each detail produces a column.
Options: Folder name with full path, Folder name only, Date created, Date modified, Created by, and Modified by.

* Setting can be specified using a parameter.


Create folder settings

Description: Create a new SharePoint folder under the selected parent folder.

Setting Description
Parent folder*Select a folder on SharePoint to create the new folder under.
Folder name*Enter the name of the new folder.
If a folder with such name already existsChoose 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).

* Setting can be specified using a parameter.


Rename folder settings

Description: Rename the selected SharePoint folder.

Setting Description
Folder*Select the folder on SharePoint to rename.
New name*Enter the new name for the selected folder.

* Setting can be specified using a parameter.


Delete folder settings

Description: Delete the selected SharePoint folder.

Setting Description
Folder path*Select the folder on SharePoint to delete.
If the folder doesn't existChoose 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).

* Setting can be specified using a 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/sharepointcommand.txt · Last modified: 2024/08/14 01:32 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki