JDBC Driver for SharePoint

Build 21.0.7867

Stored Procedures

Stored procedures are available to complement the data available from the SOAP Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.

CData JDBC Driver for SharePoint Stored Procedures

Name Description
AddAttachment Add an Attachment to a SharePoint List item.
AddList Creates a list on a SharePoint site.
AddListColumn Adds a new column to the specified list.
AddUserToGroup Add the user to specified group.
AddUserToRole Add the user to specified role.
CheckInDocument Checks in a document to SharePoint and releases the lock on the document.
CheckOutDocument Checks out a document from SharePoint.
CopyDocument Copies a document from the SharePoint library.
CreateFolder Adds a folder to a document library on a SharePoint site.
CreateSchema Creates the schema file for the specified SharePoint list. The schema file may be customized manually to exclude unwanted columns or include additional information about columns.
DeleteAttachment Delete an attachment from a SharePoint list item.
DeleteDocument Delete a document on the SharePoint library.
DeleteList Permanently deletes a list from a SharePoint site.
DeleteListColumn Deletes a column from the specified list.
DeleteUserFromGroup Delete the user from specified group.
DeleteUserFromRole Delete the user from specified role.
DiscardCheckOutDocument Discards a check out on a document in SharePoint. This does not check a new file into SharePoint. It only releases the lock on the document.
DownloadAttachment Download a document from the SharePoint list.
DownloadDocument Download a document from the SharePoint library.
UpdateList Updates a list on a SharePoint site.
UpdateListColumn Updates a column to the specified list.
UploadDocument Upload a document to the SharePoint library.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7867