Endpoint Delete Item (File or Folder)
Name
delete_item
Description
Parameters
| Parameter | Required | Options |
|---|---|---|
|
Name:
Label: Drive Id Specify a drive |
YES | |
|
Name:
Label: File/Folder Id or Path (e.g. root:/myfolder: -OR- root:/myfolder/file.xyz: ) - Max 1000 Listed Specify an item Id you like to delete |
YES | |
|
Name:
Label: Site Id (Re-Select Drive Id after you change this) Specify a site |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Status |
DT_WSTR
|
nvarchar(4000)
|
4000 |
If the column you are looking for is missing, consider customizing SharePoint Online Connector.
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Id |
DT_WSTR
|
nvarchar(4000)
|
4000 |
Required columns that you need to supply are bolded.
Examples
SSIS
Use SharePoint Online Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
API Source - SharePoint Online
SharePoint Connector can be used to read, write data in SharePoint Online List / Document Library, perform file operations such as upload, download, create, move, delete, rename in a few clicks!
SharePoint Online
Delete Item (File or Folder)
| Required Parameters | |
|---|---|
| Drive Id | Fill-in the parameter... |
| File/Folder Id or Path (e.g. root:/myfolder: -OR- root:/myfolder/file.xyz: ) - Max 1000 Listed | Fill-in the parameter... |
| Optional Parameters | |
| Site Id (Re-Select Drive Id after you change this) | |
| RawOutputDataRowTemplate | {Status:'Deleted'} |
| EnableRawOutputModeSingleRow | True |
| Continue On 404 Error (When item not found) | False |
API Destination
API Destination - SharePoint Online
SharePoint Connector can be used to read, write data in SharePoint Online List / Document Library, perform file operations such as upload, download, create, move, delete, rename in a few clicks!
SharePoint Online
Delete Item (File or Folder)
| Required Parameters | |
|---|---|
| Drive Id | Fill-in the parameter... |
| File/Folder Id or Path (e.g. root:/myfolder: -OR- root:/myfolder/file.xyz: ) - Max 1000 Listed | Fill-in the parameter... |
| Optional Parameters | |
| Site Id (Re-Select Drive Id after you change this) | |
| RawOutputDataRowTemplate | {Status:'Deleted'} |
| EnableRawOutputModeSingleRow | True |
| Continue On 404 Error (When item not found) | False |
ODBC application
Use these SQL queries in your ODBC application data source:
Delete item
SELECT * FROM delete_item
WHERE Id = 'abcd-1234-itemid'
WITH
(
"DriveId" = 'abcd-1234-driveid'
)SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Delete item
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_item
WHERE Id = ''abcd-1234-itemid''
WITH
(
"DriveId" = ''abcd-1234-driveid''
)';
EXEC (@MyQuery) AT [LS_TO_SHAREPOINT_ONLINE_IN_GATEWAY];