Leads - Fetch
Retrieve Hunter.io leads using SQL Server
- See SQLHTTP easy setup for Hunter.io
- See API Call documentation for parameter values and other information
- Create the stored procedure documented below
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
CREATE PROCEDURE usp_Hunter_Leads_Fetch( @Profile nvarchar(100), @Offset int = NULL, @Limit int = 20, @Lead_list_id int = NULL, @First_name varchar(30) = NULL, @Last_name varchar(30) = NULL, @Email varchar(50) = NULL, @Company varchar(30) = NULL, @Phone_number varchar(20) = NULL, @Twitter varchar(30) = NULL, @Response nvarchar(MAX) OUTPUT, @StatusCode int OUTPUT, @StatusDescription nvarchar(MAX) OUTPUT) AS SET NOCOUNT ON DECLARE @URL nvarchar(MAX) DECLARE @QueryString nvarchar(MAX) DECLARE @HTTPSessionID uniqueidentifier SET @URL = 'https://api.hunter.io/v2/leads' EXEC SQLHTTP.net.QueryStringBuilder @QueryString OUTPUT, @Profile, 'api_key', '#APIKey', 'offset', @Offset, 'limit', @Limit, 'lead_list_id', @Lead_list_id, 'first_name', @First_name, 'last_name', @Last_name, 'email', @Email, 'company', @Company, 'phone_number', @Phone_number, 'twitter', @Twitter SET @URL = @URL + @QueryString EXEC SQLHTTP.net.HTTPSession @HTTPSessionID OUTPUT EXEC SQLHTTP.net.HTTPRequest @HttpSessionID, @URL = @URL, @Method = 'GET', @StatusCode = @StatusCode OUTPUT, @StatusDescription = @StatusDescription OUTPUT, @Response = @Response OUTPUT GO |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
DECLARE @Response nvarchar(MAX) DECLARE @StatusCode int DECLARE @StatusDescription nvarchar(MAX) EXEC usp_Hunter_Leads_Fetch @Profile = 'My Hunter', @Offset = 0, @Limit = 5, @Response= @Response OUTPUT, @StatusCode = @StatusCode OUTPUT, @StatusDescription = @StatusDescription OUTPUT IF @StatusCode >= 400 EXEC SQLHTTP.net.RaiseHttpError @StatusCode, @StatusDescription, @Response ELSE BEGIN DECLARE @X xml SET @X = SQLHTTP.net.Json_To_Xml(@Response, '0') --The XPath syntax below was easily generated by executing the following commands: --EXEC SQLHTTP.net.XQueryHelper @X --and then executing: --EXEC SQLHTTP.net.XQueryHelper @X, 'JsonObject/data/leads/JsonObject' -- SELECT T.C.value(N'@id', N'nvarchar(MAX)') AS [id] ,T.C.value(N'@email', N'nvarchar(MAX)') AS [email] ,T.C.value(N'@first_name', N'nvarchar(MAX)') AS [first_name] ,T.C.value(N'@last_name', N'nvarchar(MAX)') AS [last_name] ,T.C.value(N'@position', N'nvarchar(MAX)') AS [position] ,T.C.value(N'@company', N'nvarchar(MAX)') AS [company] FROM @X.nodes(N'/JsonObject/data/leads/JsonObject') T(C) END |
|
1 2 3 4 5 6 7 |
id email first_name last_name position company --------- ------------------------- ------------ ----------- ---------------------- ------------- 32142619 bill.gates@microsoft.com Bill Gates Technical Evangelist Microsoft 32136449 paul.allen@microsoft.com Paul Allen Release Management Microsoft |
- 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.