UploadDocument
Uploads a document to the SharePoint library.
Note: This procedure makes use of indexed parameters. Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.
Suppose there is an input parameter named Param#. To input multiple instances of an indexed parameter like this, execute:
EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"
In the table below, indexed parameters are denoted with a '#' character at the end of their names.
Input
Name | Type | Description |
File | String | The path of the file to be added. |
FileContent | String | Base64 encoded content of the file to be added. If specified, the value of 'File' input will be ignored. |
Library | String | The URL of the directory you would like to upload file(s) to, relative to the base Url supplied in the connector's connection properties. For example: Root directory: Documents If you set the Url connection property to a site collection, the relative URL corresponds to a path on the base site. If the Url connection property points to a specific site, the relative URL is relative to the site supplied in the Url. |
Name | String | The name assigned to the new file. If uploading to the root directory of the site, supply only the filename. If uploading to a folder nested at some level inside the root directory, prepend the full parent subdirectory. For example: Root Directory: filename.txt Sub-directory:MyFolder/filename.txt |
Result Set Columns
Name | Type | Description |
Success | Boolean | Indicates whether the operation was successful or not. |
Id | String | The internal Id of the document. |
DocumentId | String | The document Id. |
DocumentIdUrl | String | The URL of the document Id. |
FileRef | String | The file reference of the document. |