@extends('layouts.master') @section('content')
API Link:
https://leads.api.highlevelguru.cloud/
API Request Method:
POST
Query Parameters:
Below said parameters are required to be provided as query string.
KeyValueDetails
key your_api_key Required for Authorization
qry insertLeads Required to call API Request, to insert leads into the cloud database.
Body:
Provide raw data as json string, sample data provided below.
											
				{
					"data": [{
						"license_number": "18543585",
						"npn_no": "18543585",
						"full_name": "CAUDLE, CORBIN",
						"first_name": "CORBIN",
						"middle_name": "",
						"last_name": "CAUDLE",
						"license_type_code": "PRO",
						"license_type": "Insurance Producer",
						"license_status": "Surrendered",
						"license_effective_date": "2018-01-31",
						"license_expiration_date": "2021-04-30",
						"is_residence": "No",
						"loas": "NO LINES ASSIGNED",
						"dba_name": "",
						"designated_home_state": "",
						"phone": "8067867517",
						"email": "",
						"full_address": "DALLAS, TX 752065338",
						"street": "",
						"city": "DALLAS",
						"region": "TX",
						"zip_code": "752065338",
						"res_status": "",
						"selected_state": "Arizona",
						"unique_id": "0-AZ-18543585",
						"license_id": "",
						"source_id": "0",
						"appointments": "",
						"organizations": "",
						"is_person": "Y"
					},{
						Second lead's data goes here ...
					},{
						Third lead's data goes here ...
					}]
				}
Max Leads per request:
50. All records from more than 50 records will be truncated automatically!
Mandetory Fields:
unique_id, full_name
Respone on successful:
											
				{
					"response": {
						"status": "OK",
						"results": [{
							"message": "Data inserted/ updated successfully!",
							"total-received": 3,
							"total-inserted": 1,
							"total-updated": 0,
							"total-failed-to-insert": 2,
							"updated-records-details": [],
							"duplicate-records": 1,
							"empty-unique_id-or-full_name": 0,
							"no-unique_id-or-full_name-provided": 0,
							"error-records": 1,
							"duplicate-unique_ids": "0-AZ-2",
							"duplicate-records-details": [{
								"license_number": "2",
								"npn_no": "18548013",
								"full_name": "ABNEY, CURTIS"
							}],
							"empty-unique_id-or-full_name-details": [],
							"no-unique_id-or-full_name-details": [],
							"error-unique_ids": "0-ZA-3 (Error Description: Data too long for column 'license_type_code' at row 1)",
							"error-records-details": [{
								"license_number": "3",
								"npn_no": "",
								"full_name": "ZAMORA, ROBERTO ELIAS"
							}],
							"note": "All records from more than 50 records will be truncated automatically!"
						}]
					},
					"qry": "insertLeads",
					"data_source": 1
				}
Respone on error:
											
				{
					"response": {
						"status": "ERROR-101",
						"results": [{
							"message": "No any raw data provided!"
						}]
					},
					"qry": "insertLeads",
					"data_source": 1
				}
Source List:
@foreach ($data[0] as $key=>$val) @endforeach @foreach($data as $row) @foreach ($row as $key=>$val) @endforeach @endforeach
{{ ucwords(str_ireplace("_"," ",$key)) }}
{{ $val }}
Information about some fields:
unique_id = It is a combination of source_id, selected_state id and license_number.
source_id = It is a unique id of data source. The sources list is available above.
selected_state = It is a state name, which was selected at the time of data extraction.
full_address = It is a combination of street, city, region, zip_code.
street = It is a street of leads address.
city = It is a city of leads address.
region = It is a state of leads address.
zip_code = It is a zip code of leads address.
license_effective_date = It is a license issue/ effective date. The date format should be yyyy-mm-dd or NULL.
license_expiration_date = It is a license expiry/ in-active date. The date format should be yyyy-mm-dd or NULL.
is_person = It will be a single character value, which should be Y or N only. If lead belongs to Person, then value will be Y. If lead belongs to other than Person, then value will be N.
API Link:
https://leads.api.highlevelguru.cloud/
API Request Method:
POST
Query Parameters:
Below said parameters are required to be provided as query string.
KeyValueDetails
key your_api_key Required for Authorization
qry updateLeads Required to call API Request, to update leads into the cloud database.
Body:
Provide raw data as json string, sample data provided below.
											
				{
					"data": [{
						"set": {
							"full_name": "POWELL, RICHARD",
							"first_name": "RICHARD",
							"last_name": "POWELL",
							"phone": "9178265091",
							"email": "richard.powell@waypointunderwriting.com"
						},
						"where": "unique_id1='0-IL-18950009' and license_number='18950009'"
					}, {
						"set": {
							"license_status": "Cancelled",
							"license_effective_date": "2018-10-22",
							"full_address": "CHICAGO, IL 60608",
							"city": "CHICAGO",
							"region": "IL",
							"zip_code": "60608"
						},
						"where": "auto_increment_id=2"
					}]
				}
Max Leads per request:
50. All records from more than 50 records will be truncated automatically!
Mandetory Fields:
Any one field (unique_id or auto_increment_id) must be required to be present into your where statement string!
Respone on successful:
											
				{
					"response": {
						"status": "OK",
						"results": [
							{
								"message": "Data updated successfully!",
								"total-received": 2,
								"total-updated": 1,
								"error-records": 1,
								"error-records-details": [
									{
										"error_at_record_no": 1,
										"error_where": "unique_id1='0-IL-18950009' and license_number='18950009'",
										"error_description": "Unknown column 'unique_id1' in 'where clause'"
									}
								],
								"total-failed-to-update": 1,
								"note": "All records from more than 50 records will be truncated automatically! Any one field (unique_id or auto_increment_id) must be required to be present into your where statement string!"
							}
						]
					},
					"qry": "updateLeads",
					"data_source": 1
				}
Respone on error:
											
				{
					"response": {
						"status": "ERROR-104",
						"results": [{
							"message": "No any data updated!"
						}]
					},
					"qry": "updateLeads",
					"data_source": 1
				}
Note:
User can able to update any field of saved leads using correct field names and data format must be provided according to the data types of fields.
User must provide the array of all the update-able fields with data required to be update under set variable.
User must provide the correct where statement with one condition or multiple conditions using AND and OR operators. It must be a string (not an array) under the where variable.
API Link:
https://leads.api.highlevelguru.cloud/
API Request Method:
GET
Query Parameters:
Below said parameters are required to be provided as query string.
KeyValueDetails
key your_api_key Required for Authorization
qry getMaxLicenseEffectiveDate Required to call API Request, to get maximum license effective date from the cloud database.
state Florida Required to get maximum license effective date
Mandetory Fields:
All fields are mandetory.
Respone on successful:
											
				{
					"response": {
						"status": "OK",
						"results": [
							{
								"auto_increment_id": "15021686",
								"license_number": "G165599",
								"npn_no": "",
								"full_name": "BLAKE, ASHLEY CHRISTINE",
								"first_name": "ASHLEY",
								"middle_name": "CHRISTINE",
								"last_name": "BLAKE",
								"license_type_code": "",
								"license_type": "ADJUSTER - ALL LINES",
								"license_status": "Active",
								"license_effective_date": "2024-09-29",
								"license_expiration_date": "0000-00-00",
								"is_residence": "Y",
								"loas": "ADJUSTER - ALL LINES",
								"dba_name": "",
								"designated_home_state": "Florida",
								"phone": "7869446082",
								"email": "BLAKE092892@GMAIL.COM",
								"full_address": "1130 NW 179TH AVE, PEMBROKE PINES,33029",
								"street": "1130 NW 179TH AVE",
								"city": "PEMBROKE PINES",
								"region": "FL",
								"zip_code": "33029",
								"res_status": "N",
								"selected_state": "Florida",
								"unique_id": "9-FL-G165599",
								"license_id": "",
								"source_id": "9",
								"appointments": "",
								"organizations": null,
								"scraping_date": "2024-09-30 12:07:33",
								"is_phone_in_data247": "y",
								"data247_id": "1652542",
								"data_source": "2",
								"is_person": "Y",
								"sent_id": null,
								"buss_name": null,
								"buss_full_address": null,
								"buss_street": null,
								"buss_city": null,
								"buss_region": null,
								"buss_zip_code": null,
								"is_email_valid": "Not Checked",
								"phone_formatted": "(786) 944-6082",
								"timezone": "America/New_York"
							}
						]
					},
					"qry": "getMaxLicenseEffectiveDate"
				}
Respone on error:
											
				{
					"response": {
						"status": "ERROR-107",
						"results": [{
							"message": "License Effective Date was not found for the selected state!"
						}]
					},
					"qry": "getMaxLicenseEffectiveDate"
				}
API Link:
https://leads.api.highlevelguru.cloud/
API Request Method:
GET
Query Parameters:
Below said parameters are required to be provided as query string.
KeyValueDetails
key your_api_key Required for Authorization
qry getMaxLicenseEffectiveDateByScrapingDate Required to call API Request, to get maximum license effective date from the cloud database.
state Florida Required to get maximum license effective date
Mandetory Fields:
All fields are mandetory.
Respone on successful:
											
				{
					"response": {
						"status": "OK",
						"results": [
							{
								"auto_increment_id": "15021686",
								"license_number": "G165599",
								"npn_no": "",
								"full_name": "BLAKE, ASHLEY CHRISTINE",
								"first_name": "ASHLEY",
								"middle_name": "CHRISTINE",
								"last_name": "BLAKE",
								"license_type_code": "",
								"license_type": "ADJUSTER - ALL LINES",
								"license_status": "Active",
								"license_effective_date": "2024-09-29",
								"license_expiration_date": "0000-00-00",
								"is_residence": "Y",
								"loas": "ADJUSTER - ALL LINES",
								"dba_name": "",
								"designated_home_state": "Florida",
								"phone": "7869446082",
								"email": "BLAKE092892@GMAIL.COM",
								"full_address": "1130 NW 179TH AVE, PEMBROKE PINES,33029",
								"street": "1130 NW 179TH AVE",
								"city": "PEMBROKE PINES",
								"region": "FL",
								"zip_code": "33029",
								"res_status": "N",
								"selected_state": "Florida",
								"unique_id": "9-FL-G165599",
								"license_id": "",
								"source_id": "9",
								"appointments": "",
								"organizations": null,
								"scraping_date": "2024-09-30 12:07:33",
								"is_phone_in_data247": "y",
								"data247_id": "1652542",
								"data_source": "2",
								"is_person": "Y",
								"sent_id": null,
								"buss_name": null,
								"buss_full_address": null,
								"buss_street": null,
								"buss_city": null,
								"buss_region": null,
								"buss_zip_code": null,
								"is_email_valid": "Not Checked",
								"phone_formatted": "(786) 944-6082",
								"timezone": "America/New_York"
							}
						]
					},
					"qry": "getMaxLicenseEffectiveDateByScrapingDate"
				}
Respone on error:
											
				{
					"response": {
						"status": "ERROR-107",
						"results": [{
							"message": "License Effective Date was not found for the selected state!"
						}]
					},
					"qry": "getMaxLicenseEffectiveDateByScrapingDate"
				}
API Link:
https://leads.api.highlevelguru.cloud/
API Request Method:
GET
Query Parameters:
Below said parameters are required to be provided as query string.
KeyValueDetails
key your_api_key Required for Authorization
qry getMaxLicenseNumber Required to call API Request, to get maximum license number with full record details from the cloud database.
state Florida Required to get maximum license number with full record details
Mandetory Fields:
All fields are mandetory.
Respone on successful:
											
				{
					"response": {
						"status": "OK",
						"results": [{
							"license_number": "W719278",
							"npn_no": "",
							"full_name": "KEITH, ERIC L",
							"first_name": "ERIC",
							"middle_name": "L",
							"last_name": "KEITH",
							"license_type_code": "",
							"license_type": "NON-RES ADJUSTER - ALL LINES",
							"license_status": "Active",
							"license_effective_date": null,
							"license_expiration_date": null,
							"is_residence": "N",
							"loas": "",
							"dba_name": "",
							"designated_home_state": "Florida",
							"phone": "3344675557",
							"email": "ORION5557@YAHOO.COM",
							"full_address": "229 OAK FOREST DR, MONTGOMERY, AL 36109",
							"street": "229 OAK FOREST DR",
							"city": "MONTGOMERY",
							"region": "",
							"zip_code": "36109",
							"res_status": "N",
							"selected_state": "Florida",
							"unique_id": "9-FL-W719278",
							"license_id": "",
							"source_id": "9",
							"appointments": "",
							"organizations": null,
							"scraping_date": "2021-02-11 05:17:02",
							"is_phone_in_data247": "N",
							"data247_id": "0",
							"auto_increment_id": "7801780",
							"data_source": "2",
							"is_person": "Y",
							"sent_id": null,
							"buss_name": null,
							"buss_full_address": null,
							"buss_street": null,
							"buss_city": null,
							"buss_region": null,
							"buss_zip_code": null
						}]
					},
					"qry": "getMaxLicenseNumber"
				}
Respone on error:
											
				{
					"response": {
						"status": "ERROR-108",
						"results": [{
							"message": "License Number was not found for the selected state!"
						}]
					},
					"qry": "getMaxLicenseNumber"
				}
API Link:
https://leads.api.highlevelguru.cloud/
API Request Method:
GET
Query Parameters:
Below said parameters are required to be provided as query string.
KeyValueDetails
key your_api_key Required for Authorization
qry getMaxLicenseNumberByScrapingDate Required to call API Request, to get maximum license number with full record details from the cloud database.
state Florida Required to get maximum license number with full record details
Mandetory Fields:
All fields are mandetory.
Respone on successful:
											
				{
					"response": {
						"status": "OK",
						"results": [
							{
								"auto_increment_id": "14965448",
								"license_number": "G162996",
								"npn_no": "",
								"full_name": "MESA, MAGDIEL",
								"first_name": "MAGDIEL",
								"middle_name": "",
								"last_name": "MESA",
								"license_type_code": "",
								"license_type": "TITLE",
								"license_status": "Active",
								"license_effective_date": "2024-09-20",
								"license_expiration_date": "0000-00-00",
								"is_residence": "Y",
								"loas": "TITLE",
								"dba_name": "",
								"designated_home_state": "Florida",
								"phone": "7863917420",
								"email": "MAGDIELMESA@ICLOUD.COM",
								"full_address": "2596 WEST 9 CT, HIALEAH,33010",
								"street": "2596 WEST 9 CT",
								"city": "HIALEAH",
								"region": "FL",
								"zip_code": "33010",
								"res_status": "N",
								"selected_state": "Florida",
								"unique_id": "9-FL-G162996",
								"license_id": "",
								"source_id": "9",
								"appointments": "",
								"organizations": null,
								"scraping_date": "2024-09-24 12:26:13",
								"is_phone_in_data247": "y",
								"data247_id": "1644361",
								"data_source": "2",
								"is_person": "Y",
								"sent_id": null,
								"buss_name": null,
								"buss_full_address": null,
								"buss_street": null,
								"buss_city": null,
								"buss_region": null,
								"buss_zip_code": null,
								"is_email_valid": "Not Checked",
								"phone_formatted": "(786) 391-7420",
								"timezone": "America/New_York"
							}
						]
					},
					"qry": "getMaxLicenseNumberByScrapingDate"
				}
Respone on error:
											
				{
					"response": {
						"status": "ERROR-108",
						"results": [{
							"message": "License Number was not found for the selected state!"
						}]
					},
					"qry": "getMaxLicenseNumberByScrapingDate"
				}
API Link:
https://leads.api.highlevelguru.cloud/
API Request Method:
GET
Query Parameters:
Below said parameters are required to be provided as query string.
KeyValueDetails
key your_api_key Required for Authorization
qry getMinLeadsByLicenseEffectiveDateAndState Required to call API Request, to get lead details by minimum npn_no or license number from the cloud database.
state Florida Required
date 2025-01-01 Required
record_by npn_no OR license_number Required
Mandetory Fields:
All fields are mandetory.
Respone on successful:
											
				{
					"response": {
						"status": "OK",
						"results": [
							{
								"auto_increment_id": "15775590",
								"license_number": "G200024",
								"npn_no": "21427008",
								"full_name": "Belfon, Johnathon",
								"first_name": "Johnathon",
								"middle_name": "",
								"last_name": "Belfon",
								"license_type_code": "",
								"license_type": "LIFE INCL VAR ANNUITY & HEALTH",
								"license_status": "Active",
								"license_effective_date": "2025-01-01",
								"license_expiration_date": "0000-00-00",
								"is_residence": "Y",
								"loas": "LIFE INCL VAR ANNUITY & HEALTH",
								"dba_name": "",
								"designated_home_state": "Florida",
								"phone": "3475131543",
								"email": "JOHNBEL91@GMAIL.COM",
								"full_address": "650 LAURA OAKS BLVD APT. 204, KISSIMMEE,34747",
								"street": "650 LAURA OAKS BLVD APT. 204",
								"city": "KISSIMMEE",
								"region": "FL",
								"zip_code": "34747",
								"res_status": "N",
								"selected_state": "Florida",
								"unique_id": "9-FL-G200024",
								"license_id": "",
								"source_id": "9",
								"appointments": "",
								"organizations": null,
								"scraping_date": "2025-01-08 16:45:12",
								"is_phone_in_data247": "N",
								"data247_id": "0",
								"data_source": "2",
								"is_person": "Y",
								"sent_id": null,
								"buss_name": null,
								"buss_full_address": null,
								"buss_street": null,
								"buss_city": null,
								"buss_region": null,
								"buss_zip_code": null,
								"is_email_valid": "Not Checked",
								"phone_formatted": "(347) 513-1543",
								"npa": "347",
								"nxx": "513",
								"block_id": "1",
								"ltype_id": "C",
								"timezone": "America/New_York"
							}
						]
					},
					"qry": "getMinLeadsByLicenseEffectiveDateAndState"
				}
Respone on error:
											
				{
					"response": {
						"status": "ERROR-116",
						"results": [{
							"message": "Record not found as per your queries!"
						}]
					},
					"qry": "getMinLeadsByLicenseEffectiveDateAndState"
				}
API Link:
https://leads.api.highlevelguru.cloud/
API Request Method:
POST
Query Parameters:
Below said parameters are required to be provided as query string.
KeyValueDetails
key your_api_key Required for Authorization
qry insertJobsData Required to call API Request, to insert jobs data into the cloud database.
Body:
Provide raw data as json string, sample data provided below.
											
				{
					"data": [{
						"title": ".5 Dance Teacher (Grade: 9-12)",
						"organization": "Dallas ISD",
						"location": "Dallas, TX",
						"email": "test@test.com",
						"phone": "253-374-2938",
						"web_address": "https://www.google.com",
						"urgent_banner": "Actively Hiring During COVID-19",
						"short_description": "Present subject matter according to guidelines established by Texas Education Agency...",
						"long_description": "Present subject matter according to guidelines established by Texas Education Agency, Board of Trustee policies, and administrative regulations * Establish efficient classroom management procedures"
					},{
						Second job's data goes here ...
					},{
						Third job's data goes here ...
					}]
				}
Max Leads per request:
100. All records from more than 100 records will be truncated automatically!
Mandetory Fields:
All fields are mandetory.
Respone on successful:
											
				{
					"response": {
						"status": "OK",
						"results": [{
							"message": "Data inserted successfully!",
							"total-received": 3,
							"total-inserted": 1,
							"total-failed-to-insert": 2,
							"no-required-fields-provided": 2,
                			"no-required-fields-details": [{
								"title": "",
								"organization": "",
								"location": "",
								"email": "",
								"phone": "",
								"web_address": "",
								"urgent_banner": "",
								"short_description": "",
								"long_description": ""
							},{
								"title": "",
								"organization": "",
								"location": "",
								"email": "",
								"phone": "",
								"web_address": "",
								"urgent_banner": "",
								"short_description": "",
								"long_description": ""
							}],
                			"empty-title": 0,
                			"empty-title-details": [],
                			"duplicate-records": 0,
                			"duplicate-records-details": [],
                			"error-records": 0,
                			"error-records_titles": "",
                			"error-records-details": [],
							"note": "All records from more than 100 records will be truncated automatically!"
						}]
					},
					"qry": "insertJobsData",
					"data_source": 1
				}
Respone on error:
											
				{
					"response": {
						"status": "ERROR-101",
						"results": [{
							"message": "No any raw data provided!"
						}]
					},
					"qry": "insertJobsData",
					"data_source": 1
				}
API Link:
https://leads.api.highlevelguru.cloud/
API Request Method:
POST
Query Parameters:
Below said parameters are required to be provided as query string.
KeyValueDetails
key your_api_key Required for Authorization
qry insertAgentsData Required to call API Request, to insert agents data into the cloud database.
Body:
Provide raw data as json string, sample data provided below.
											
				{
					"data": [{
						"title": "The Gayden Team",
						"organization": "Keller Williams Signature",
						"email": "",
						"phone": "(832) 692-2000",
						"for_sale": 171,
						"sold": 1007,
						"experience": null,
						"activity_range": "$119K - $1.4M",
						"list_a_house": "2020-11-16",
						"bio_link": "https://realtor.com/realestateagents/the-gayden-team_houston_tx_163079_587994491",
						"phone1": "",
						"phone2": "",
						"image_link": "https://www.realtor.com///p.rdcpix.com/v02/g589b1900-c0md-r1d-r7_w110.jpg",
						"location": "",
						"city": "Katy",
						"state": "TX",
						"zip_code": "77449",
						"county": "Harris"
					},{
						Second agent's data goes here ...
					},{
						Third agent's data goes here ...
					}]
				}
Max Leads per request:
50. All records from more than 50 records will be truncated automatically!
Mandetory Fields:
All fields are mandetory.
Respone on successful:
											
				{
					"response": {
						"status": "OK",
						"results": [{
							"message": "Data inserted/ updated successfully!",
							"total-received": 3,
							"total-inserted": 1,
							"total-updated": 0,
							"total-failed-to-insert": 2,
							"updated-records-details": [],
							"no-required-fields-provided": 2,
                			"no-required-fields-details": [{
								"title": "",
								"organization": "",
								"email": "",
								"phone": "",
								"for_sale": null,
								"sold": null,
								"experience": null,
								"activity_range": "",
								"list_a_house": null,
								"bio_link": "",
								"phone1": "",
								"phone2": "",
								"image_link": "",
								"location": "",
								"city": "",
								"state": "",
								"zip_code": "",
								"county": ""
							},{
								"title": "",
								"organization": "",
								"email": "",
								"phone": "",
								"for_sale": null,
								"sold": null,
								"experience": null,
								"activity_range": "",
								"list_a_house": null,
								"bio_link": "",
								"phone1": "",
								"phone2": "",
								"image_link": "",
								"location": "",
								"city": "",
								"state": "",
								"zip_code": "",
								"county": ""
							}],
                			"empty-title": 0,
                			"empty-title-details": [],
                			"duplicate-records": 0,
                			"duplicate-records-details": [],
                			"error-records": 0,
                			"error-records_titles": "",
                			"error-records-details": [],
							"note": "All records from more than 50 records will be truncated automatically!"
						}]
					},
					"qry": "insertAgentsData",
					"data_source": 1
				}
Respone on error:
											
				{
					"response": {
						"status": "ERROR-101",
						"results": [{
							"message": "No any raw data provided!"
						}]
					},
					"qry": "insertAgentsData",
					"data_source": 1
				}
Information about the fields:
for_sale, sold, experience = The data type of these all the three fields is Int. So, you may able to provide the value as number or null.
list_a_house = The data type of this field is date. So, you may able to provide the value as date in format of YYYY-MM-DD or null.
All other fields are string fields. So you may provide any kind of value in these fields or empty value.
How to provide null value, it is used in above provided sample data.
Main Error List:
@foreach($GLOBALS['MAIN_ERRORS'] as $key=>$val) @endforeach
Error CodeDetails
{{ $key }} {{ $val }}
Internal Error List:
@foreach($GLOBALS['QRY_ERRORS'] as $key=>$val) @endforeach
Error CodeDetails
{{ $key }} {{ $val }}
@endsection