EndPoint 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 OneDrive 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 OneDrive Connector in API Source component to read data or in API Destination component to read/write data:
Delete rows from Files table using API Destination
This EndPoint belongs to Files table, therefore you cannot work with it directly. Use this table and table-operation pair instead:
OneDrive
Files
Delete
ODBC application
This endpoint belongs to the table
Files.
You can still use the examples below, but it is advised to work directly with the table.
Use these SQL queries in your ODBC application data source:
Delete a file/folder
Deletes a file or folder in OneDrive
SELECT * FROM delete_item
WITH (DriveId='b!GtLN726LE0eY5F2BBNi14'
,ItemId='01SUOJPKHXMPKD2UXXXXXXXXXXXXXXXXXX'
)
--Using Table Name instead of endpoint (with Id / Path in WHERE clause for simple Syntax)
--************
--Delete File by ID or Path
--************
--DELETE From Files Where Id='01N3NI7YU6DYBSLCEDKBB23CR4FSWZYSDJ'
--DELETE From Files Where Id='root:/test_out.csv:'
--DELETE From Files Where Id='root:/somefolder/test_out.csv:'
--************
--Delete Folder by ID or Path
--************
--DELETE From Folders Where Id='01N3NI7YU6DYBSLCEDKBB23CR4FSWZYSDJ'
--DELETE From Folders Where Id='root:/somefolder:'
--DELETE From Folders Where Id='root:/somefolder/childfolder:'
--DriveId can be retrieved by selecting from 'list_drives' endpoint.
--FileId can be retrieved by selecting from 'list_folder' or 'list_root' endpoints.SQL Server
This endpoint belongs to the table
Files.
You can still use the examples below, but it is advised to work directly with the table.
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Delete a file/folder
Deletes a file or folder in OneDrive
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_item
WITH (DriveId=''b!GtLN726LE0eY5F2BBNi14''
,ItemId=''01SUOJPKHXMPKD2UXXXXXXXXXXXXXXXXXX''
)
--Using Table Name instead of endpoint (with Id / Path in WHERE clause for simple Syntax)
--************
--Delete File by ID or Path
--************
--DELETE From Files Where Id=''01N3NI7YU6DYBSLCEDKBB23CR4FSWZYSDJ''
--DELETE From Files Where Id=''root:/test_out.csv:''
--DELETE From Files Where Id=''root:/somefolder/test_out.csv:''
--************
--Delete Folder by ID or Path
--************
--DELETE From Folders Where Id=''01N3NI7YU6DYBSLCEDKBB23CR4FSWZYSDJ''
--DELETE From Folders Where Id=''root:/somefolder:''
--DELETE From Folders Where Id=''root:/somefolder/childfolder:''
--DriveId can be retrieved by selecting from ''list_drives'' endpoint.
--FileId can be retrieved by selecting from ''list_folder'' or ''list_root'' endpoints.';
EXEC (@MyQuery) AT [LS_TO_ONEDRIVE_IN_GATEWAY];