Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
In recognition of Martin Luther King Day, our Support Centers will be open with limited hours on Monday (1/20) from 10AM ET to 6PM ET. Visit our Help Center to see all of the ways you can find answers to your questions.
While I don't have much recent experience with MSSQL, in theory it would be possible to call out to Constant Contact from a database hook. However, there would definitely not be an elegant method for doing this, as it's definitely stretching the limits of what arguably should be done on the SQL server.
In order to be able to use the Constant Contact API to add contacts, you would need to be able to make HTTP GET/PUT/POST requests with headers and an optional JSON body. If you can find a way to make these requests from within the database, then you could implement a create/update method for contacts in Constant Contact. One potential solution is to build the integration as an external library and use CLR to make calls to that library from SQL Server.
I'm not sure if I can help much further with the problem of how to make the API calls from the server, as this task goes a ways beyond anything that I've personally done with MSSQL. However, if you have any questions about our API or any issues that are specific to the API, please let me know!