Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the server beyond simple SELECT/INSERT/UPDATE/DELETE operations with Microsoft Exchange.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Microsoft Exchange, along with an indication of whether the procedure succeeded or failed.

CData MCP Server for Microsoft Exchange Stored Procedures


Name	Description
CreateAttachments	Creates and attaches one or more files to an existing email message using the message's unique identifier. It supports various file types and ensures attachment persistence.
DeleteAttachment	Removes one or more attachments from a specified email or item. It requires the attachment ID or related identifiers to perform deletion.
GetAttachment	Retrieves file attachments associated with a given email or item. It returns binary content and metadata such as name, size, and content type.
GetOAuthAccessToken	Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made to Microsoft Exchange.
GetOAuthAuthorizationURL	Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process.
GetRoomLists	Returns a collection of room lists available in the Exchange organization. The room lists are mail-enabled distribution groups that contain email addresses of meeting rooms, often used to simplify resource scheduling in Outlook and other calendar tools.
GetRooms	Fetches all individual rooms that belong to a specified room list. This is useful for applications that need to display or schedule meetings in available rooms within a specific building or location.
GetUserAvailability	Provides free/busy availability data for a list of users, rooms, and resources over a defined time range. It is often used for scheduling meetings by determining when participants are available.
GetUserOofSettings	Retrieves the Out of Office (OOF) settings for a given user, identified by their email address. It includes information on whether automatic replies are enabled and any custom OOF messages configured by the user.
MoveItem	Moves an item, such as an email or calendar event, from one folder to another within the Exchange mailbox store. This is useful for organizing mailbox contents or implementing custom automation workflows.
RefreshOAuthAccessToken	Refreshes an expired OAuth Access Token to maintain continuous authenticated access to Microsoft Exchange resources without requiring reauthorization from the user.
SendItem	Sends an existing item—such as a draft email message—that resides in the Exchange store. This procedure finalizes the send action and delivers the message to the recipient(s).
SendMail	Creates and sends a new email message to one or more specified recipients. This procedure constructs a new message object, defines its content, and dispatches it via the Exchange server.