Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with SendGrid.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from SendGrid, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for SendGrid Stored Procedures
| Name | Description |
| AddRecipientToList | Adds a recipient to a list. |
| DownloadCampaignAutomationStats | Download Marketing Campaign Stats for Automations |
| GetImportContactsStatus | Gets the Import contacts status |
| GetScopes | Returns a list of all scopes that this user has access to. |
| ImportMarketingContacts | Import contacts to sendgrid account from CSV file. |
| SendMail | Sends a mail. |
| SendMail2 | Sends a mail. This Stored Procedure is used to handle aggregates. |
| SendTestCampaign | Sends a test campaign. |