Stored procedures are available to complement the data available from the 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 SendGrid Stored Procedures
|AddRecipientToList||Adds a recipient to a list.|
|DownloadCampaignAutomationStats||Download Marketing Campaign Stats for Automations|
|GetImportContactsStatus||Gets the Import contacts status|
|ImportMarketingContacts||Import contacts to sendgrid account from CSV file.|
|SendMail||Sends a mail.|
|SendTestCampaign||Sends a test campaign.|