Hunter.io
Interact with the Hunter.io API using SQL Server
- Install the SQLHTTP database on your SQL Server
- Obtain an API Key from Hunter.io
- Create the stored procedures documented below
- Execute the following SQL statement:
1 2 3 4 |
EXEC usp_Hunter_Auth_Init @Profile = 'enter-profile-name-of-your-choosing', @APIKey = 'enter-your-API-Key-here' |
1 2 3 4 5 6 7 8 9 10 |
CREATE PROCEDURE usp_Hunter_Auth_Init( @Profile nvarchar(100), @APIKey nvarchar(100)) AS EXEC SQLHTTP.net.AuthParamSet @Profile = @Profile, @Name = 'APIKey', @Value = @APIKey GO |
- Account Information – Fetch
- Deleted Records – Fetch
- Domain – Search
- Email – Fetch
- Email Count – Fetch
- Email Verification – Fetch
- Lead – Create
- Lead – Delete
- Lead – Update
- Leads – Fetch
- Leads List – Create
- Leads List – Delete
- Leads List – Fetch
- Leads List – Update
- Leads Lists – Fetch
- Multiple Reocords – Create
- Multiple Requests – Create
- Nested Records – Create
- Recently Viewed Records – Fetch
- Records as Recently Viewed – Query
- Relevant Items – Fetch
- Search Scope and Order – Fetch
- String – SOSL Search
- Updated Records – Fetch
IMPORTANT DISCLAIMER
CODE/SQL ON THESE PAGES ARE PROVIDED AS-IS AND ARE AVAILABLE FOR ILLUSTRATIVE PURPOSES ONLY.
USERS ARE REQUIRED TO ABIDE BY THE TERMS AND CONDITIONS FOR USING REFERENCED THIRD PARTY WEBSITES AND/OR APIs FROM THEIR RESPECTIVE WEBSITES. WE DO NOT CONDONE ANY VIOLATION OF THIRD PARTY WEBSITES AND/OR APIs TERMS AND CONDITIONS USING OUR SOFTWARE.
USERS SHALL BE SOLELY RESPONSIBLE AND BE SOLELY LIABLE FOR VIOLATION OF ANY RULES SPECIFIED BY THIRD PARTIES FOR USING THEIR WEBSITES AND/OR APIs, OR INFRINGEMENT OF RIGHTS OF SUCH THIRD PARTIES.