MoveResource
Move a resource from one directory in your drive to another.
Stored Procedure Specific Information
Microsoft OneDrive allows only a small subset of columns to be used in the Exec query. DestinationID and either of ResourcePath or ResourceId is required to move the resource. These columns can typically be used with only = comparison.
If file is present in the root folder of a OneDrive account, then mention the file name directly for the value of ResourcePath.
For example:
EXECUTE MoveResource ResourcePath = 'Book.xlsx', DestinationID = '01JSGDQ3MFCITWE4PQKFAY6KH5LHJKPYU5'
If file is present inside a child folder of a OneDrive account, then you need to specify the path of the file starting from child folder name for the value of ResourcePath.
For example:
EXECUTE MoveResource ResourcePath = 'Notebooks/test.png', DestinationID = '01JSGDQ3MFCITWE4PQKFAY6KH5LHJKPYU5'
You can also move the resource by providing the ResourceId and DestinationID as well.
For example:
EXECUTE MoveResource ResourceId = '01CYQN2MFPR6NIWVZNMNFL3SL4E3KF7IHY', DestinationID = '01JSGDQ3MFCITWE4PQKFAY6KH5LHJKPYU5'
Input
| Name | Type | Required | Description |
| DestinationID | String | True | The ID of the folder you want to move the resource to. |
| ResourcePath | String | False | The location of the resource. Either ResourceId or ResourcePath is required for this operation. |
| ResourceId | String | False | Id of the resource. Either ResourceId or ResourcePath is required for this operation. |
| DriveId | String | False | The Id of the drive the resource is located in if this is different from the current user drive. |
Result Set Columns
| Name | Type | Description |
| Success | String | File moving results. |