共用方式為


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 support@hithorizons.com
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