HitHorizons
HitHorizons enables you to work with data of 75M+ European companies from 60 countries directly in your Microsoft products. Enrich you software with company data from various sources to provide you with a more complete and complex picture of the market, individual companies and their evolution over time.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | HitHorizons support |
| URL | https://www.hithorizons.com/services/api |
| [email protected] |
| Connector Metadata | |
|---|---|
| Publisher | FinStat, s. r. o. |
| Website | https://www.hithorizons.com/ |
| Privacy policy | https://www.hithorizons.com/legal/privacy-policy |
| Categories | Business Intelligence;Sales and CRM |
HitHorizons connector allows you to integrate HitHorizons database of European companies in your Microsoft products. It allows you to search in a database of more than 75 million companies in 60 countries and use the company data in your solution.
Prerequisites
You will need the following to proceed:
- HitHorizons subscription.
- HitHorizons API key.
How to get credentials
Please visit https://www.hithorizons.com/services to view the range of services provided by HitHorizons and to purchase HitHorizons subscription.
Getting started with your connector
- Use action Company-Search to search for a company by name and location.
- Use action Company-Get to retrieve company information, including basic registration data, sales information with analytics, and employee number information with analytics.
Known issues and limitations
There is a rate limit for API requests in place. Maximum rate of 30 requests per minute is allowed. After exceeding this limit, a 429 Too Many Requests response is returned.
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
| Name | Type | Description | Required |
|---|---|---|---|
| API Key | securestring | The API Key for this api | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Retrieve company detail data by ID |
Retrieve data of company specified by HitHorizonsId. |
| Search for companies using structured query |
Search for companies using structured query. |
| Search for companies using unstructured query |
Search for companies using unstructured query. |
Retrieve company detail data by ID
Retrieve data of company specified by HitHorizonsId.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
ID of the company to retrieve
|
HitHorizonsId | True | string |
HitHorizons ID of the company to retrieve. HitHorizonsId can be retrieved by searching for the company using Company-Search or Company-SearchUnstructured operations. |
Returns
Search for companies using structured query
Search for companies using structured query.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
DUNS Number to find
|
DUNSNumber | string |
Company with the provided DUNS Number will be returned. |
|
|
Value to search in company names
|
CompanyName | string |
Company name and secondary name will be searched for this value. |
|
|
Value to search in company National ID
|
NationalId | string |
National ID will be searched for this value. |
|
|
Value to search in company address
|
AddressUnstructured | string |
Company address will be searched for this value. All address fields will be searched (street address, postal code, city, state/province). When country name is present in this field, the results are limited only to the given country. Any of the terms can be present in any of the address fields. |
|
|
Value to search in company street address
|
AddressStreet | string |
Company street address will be searched for this value. All terms must be present in either one of the street address lines. |
|
|
Value to search in company city
|
City | string |
Company city will be searched for this value. All terms must be present in city name. |
|
|
Value to search in company state/province
|
StateProvince | string |
Company state/province will be searched for this value. All terms must be present in state/province name. |
|
|
Country to limit the search in
|
Country | string |
Only companies in the given country will be searched. |
|
|
Whether to include branch records in results
|
ShowBranches | boolean |
When false (default), only main offices and single-location companies are retrieved. When true, also records marked as branch offices are included in the results. |
|
|
Company types to be included in the results
|
CompanyTypes | string |
Array of company types to search for. This value can be provided as a comma-separated list of values, instead of an array of values (i.e. CompanyTypes=3,13 , instead of CompanyTypes=3&CompanyTypes=13) Refer to the following codelist for available values: https://hithorizonsapim.portal.azure-api.net/api-docs/code-lists#companyType . When not provided, the following values are used by default: 0, 3, 10, 11, 12, 13, 14, 100, 102, 107, 120, 151, 154, 160, 167 |
|
|
Max number of results to return
|
MaxResults | integer |
Max number of results to return. Default value is 20. Maximum possible value is 100. |
Returns
Search for companies using unstructured query
Search for companies using unstructured query.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Value to search in company IDs: HitHorizonsId, DUNSNumber and NationalId
|
Ids | string |
All available IDs will be searched for the values in this field: HitHorizons ID, DUNS Number and National ID. Multiple values can be provided, separated by space. |
|
|
Value to search in company names and company IDs
|
Name | string |
Company name and secondary name will be searched for this value. Also, NationalId will be searched. If the format corresponds to the HitHorizonsId (starts with H-), HitHorizonsId will be searched. This field can be used for broad search using names and IDs for user convenience. |
|
|
Value to search in company address
|
Address | string |
Company address will be searched for this value. All address fields will be searched (street address, postal code, city, state/province). When country name is present in this field, the results are limited only to the given country. |
|
|
Whether to include branch records in results
|
ShowBranches | boolean |
When false (default), only main offices and single-location companies are retrieved. When true, also records marked as branch offices are included in the results. |
|
|
Company types to be included in the results
|
CompanyTypes | string |
Array of company types to search for. This value can be provided as a comma-separated list of values, instead of an array of values (i.e. CompanyTypes=3,13 , instead of CompanyTypes=3&CompanyTypes=13) Refer to the following codelist for available values: https://hithorizonsapim.portal.azure-api.net/api-docs/code-lists#companyType . When not provided, the following values are used by default: 0, 3, 10, 11, 12, 13, 14, 100, 102, 107, 120, 151, 154, 160, 167 |
|
|
Max number of results to return
|
MaxResults | integer |
Max number of results to return. Default value is 20. Maximum possible value is 100. |
Returns
Definitions
CompanyDetailResult
| Name | Path | Type | Description |
|---|---|---|---|
|
HitHorizonsId
|
HitHorizonsId | string | |
|
DUNSNumber
|
DUNSNumber | string | |
|
CompanyName
|
CompanyName | string | |
|
CompanySecondaryName
|
CompanySecondaryName | string | |
|
AddressStreetLine1
|
AddressStreetLine1 | string | |
|
AddressStreetLine2
|
AddressStreetLine2 | string | |
|
PostalCode
|
PostalCode | string | |
|
City
|
City | string | |
|
StateProvince
|
StateProvince | string | |
|
Country
|
Country | string | |
|
NationalId
|
NationalId | string | |
|
NationalIdType
|
NationalIdType | string | |
|
SICText
|
SICText | string | |
|
SICCode
|
SICCode | string | |
|
Industry
|
Industry | string | |
|
LocalActivityCode
|
LocalActivityCode | string | |
|
LocalActivityCodeType
|
LocalActivityCodeType | string | |
|
EstablishmentOfOwnership
|
EstablishmentOfOwnership | integer | |
|
SalesLocal
|
SalesLocal | double | |
|
LocalCurrency
|
LocalCurrency | string | |
|
SalesAccuracyIndicator
|
SalesAccuracyIndicator | string | |
|
SalesUSD
|
SalesUSD | double | |
|
SalesEUR
|
SalesEUR | double | |
|
HitHorizonsSalesAnalysis
|
HitHorizonsSalesAnalysis | object | |
|
EmployeesNumber
|
EmployeesNumber | integer | |
|
EmployeesNumberAccuracyIndicator
|
EmployeesNumberAccuracyIndicator | string | |
|
EmployeesNumberTotal
|
EmployeesNumberTotal | integer | |
|
EmployeesNumberTotalAccuracyIndicator
|
EmployeesNumberTotalAccuracyIndicator | string | |
|
HitHorizonsEmployeesAnalysis
|
HitHorizonsEmployeesAnalysis | object | |
|
CompanyType
|
CompanyType | integer | |
|
LocationType
|
LocationType | integer | |
|
HitHorizonsCompanyProfileURL
|
HitHorizonsCompanyProfileURL | string |
CompanyDetailResultApiResponse
| Name | Path | Type | Description |
|---|---|---|---|
|
Success
|
Success | boolean | |
|
Error
|
Error | string | |
|
Result
|
Result | CompanyDetailResult |
CompanySearchResult
| Name | Path | Type | Description |
|---|---|---|---|
|
HitHorizonsId
|
HitHorizonsId | string | |
|
DUNSNumber
|
DUNSNumber | string | |
|
CompanyName
|
CompanyName | string | |
|
CompanySecondaryName
|
CompanySecondaryName | string | |
|
AddressStreetLine1
|
AddressStreetLine1 | string | |
|
AddressStreetLine2
|
AddressStreetLine2 | string | |
|
PostalCode
|
PostalCode | string | |
|
City
|
City | string | |
|
StateProvince
|
StateProvince | string | |
|
Country
|
Country | string | |
|
NationalId
|
NationalId | string | |
|
Industry
|
Industry | string | |
|
EstablishmentOfOwnership
|
EstablishmentOfOwnership | integer | |
|
SalesEUR
|
SalesEUR | double | |
|
EmployeesNumber
|
EmployeesNumber | integer | |
|
CompanyProfileURL
|
CompanyProfileURL | string |
CompanySearchResponse
| Name | Path | Type | Description |
|---|---|---|---|
|
Results
|
Results | array of CompanySearchResult | |
|
ResultsCount
|
ResultsCount | integer | |
|
TotalCount
|
TotalCount | integer |
CompanySearchResponseApiResponse
| Name | Path | Type | Description |
|---|---|---|---|
|
Success
|
Success | boolean | |
|
Error
|
Error | string | |
|
Result
|
Result | CompanySearchResponse |