Delete Item (File or Folder)
Parameters
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| Status |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
If the column you are looking for is missing, consider customizing SharePoint Online Connector.
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| Id |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
Required columns that you need to supply are bolded.
Examples
SSIS
Use SharePoint Online Connector in API Source component to read data or in API Destination component to read/write data:
Delete Item (File or Folder) using API Source
SharePoint Online
Delete Item (File or Folder)
Delete Item (File or Folder) using API Destination
SharePoint Online
Delete Item (File or Folder)
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];