Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the cmdlet 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 Cmdlets PowerShell Module 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. |