Jaa


Pappers (Independent Publisher) (Preview)

Pappers International allows you to retrieve information and documents on European companies through their registration number in the appropriate commercial register.

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 Troy Taylor
URL https://www.hitachisolutions.com
Email ttaylor@hitachisolutions.com
Connector Metadata
Publisher Troy Taylor
Website https://www.pappers.in/
Privacy policy https://www.pappers.fr/politique-de-protection-des-donnees-personnelles
Categories Business Intelligence;Data

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

Get company

Get company information by country code and company number.

Get document

Provided the document's token, it will be downloaded to you in PDF format.

Search companies

Search for companies by country code and query string.

Get company

Get company information by country code and company number.

Parameters

Name Key Required Type Description
Country Code
country_code True string

The country code of the company.

Company Number
company_number True string

The company number.

Fields
fields string

Additional fields (separated by a comma) to include in the return.

Returns

CompanyFormat
CompanyFormat

Get document

Provided the document's token, it will be downloaded to you in PDF format.

Parameters

Name Key Required Type Description
Token
token True string

The document's token.

Returns

Name Path Type Description
Content Type
$content-type string

The content type.

Content
$content string

The content.

Search companies

Search for companies by country code and query string.

Parameters

Name Key Required Type Description
Country Code
country_code True string

The country code of the company.

Query
q True string

The search query string.

Page
page integer

The page number of the search result.

Per Page
per_page integer

The number of results returned per page.

Returns

Response
SearchResponse

Definitions

SearchFormat

Name Path Type Description
Company Number
company_number string

The identification number of the company entity in it's appropriate registry of commerce.

Name
name string

Denomination of the company.

Local Code
local_legal_form_code string

Local legal form code.

Local Name
local_legal_form_name string

Local legal form name.

Activities
activities array of Activity

Array of company's activities, in the NACE classification.

Local Activities
local_activities array of LocalActivity

Array of company's activities, in the local classifications.

Date of Creation
date_of_creation date

Company's inception date.

Status
status string

Indicates whether or not the company is still active.

Date of Cessation
date_of_cessation date

Indicates the company's cessation date if company is inactive, otherwise null.

Address Line 1
head_office.address_line_1 string

The company's primary address line.

Address Line 2
head_office.address_line_2 string

The company's additional address line.

Postal Code
head_office.postal_code string

The company's local postal code.

City
head_office.city string

The company's city.

Country
head_office.country string

The company's country.

Country Code
head_office.country_code string

The company's country code.

CompanyFormat

Name Path Type Description
Company Number
company_number string

The number of the company entity.

Name
name string

Denomination of the company.

Trade Number
trade_name string

Trade name of the company.

Acronym
acronym string

Acronym of the company.

VAT Number
vat_number string

Tax number of the company.

Local Code
local_legal_form_code string

Local legal form code.

Local Name
local_legal_form_name string

Local legal form name.

Activities
activities array of Activity

Array of company's activities, in the NACE classification.

Field of Activities
fields_of_activity array of string

Array of company's fields of activity, in the NACE classification.

Local Activities
local_activities array of LocalActivity

Array of company's activities, in the local classifications.

Date of Creation
date_of_creation date

Company's creation date.

Status
status string

Indicates whether or not the company is still active.

Date of Cessation
date_of_cessation date

Indicates the company's cessation date if company is inactive, otherwise null.

Workforce
workforce integer

Indicates the company's exact workforce.

Workforce Range
workforce_range string

Indicates the company's workforce range.

Address Line 1
head_office.address_line_1 string

The company's primary address line.

Address Line 2
head_office.address_line_2 string

The company's additional address line.

Postal Code
head_office.postal_code string

The company's local postal code.

City
head_office.city string

The company's city.

Country
head_office.country string

The company's country.

Country Code
head_office.country_code string

The company's country code.

CommercialRegisterRegistrationStatus
commercial_register_registration_status string

Indicates the company's registration status on the appropriate commercial register.

Registration Location
commercial_register_registration_location string

Indicates the location of the company's commercial register.

Registration Date
commercial_register_registration_date date

Indicates the company's registration date in the commercial register.

Cessation Date
commercial_register_cessation_date date

Indicates the company's cessation date in the commercial register.

Capital Share
share_capital integer

Indicates the company's share of capital.

Capital Share Currency
share_capital_currency string

Indicates the company's share of capital's currency.

Next Year End
next_fiscal_year_end date

Indicates the company's next fiscal year end.

Fiscal Year End
fiscal_year_end date

Indicates the company's current fiscal year end.

Officers
officers array of Officer

Array of company's officers. Present only if "officers" has been indicated in the Fields query.

Owners
ubos array of Ubo

Array of company's owners. Present only if "ubos" has been indicated in the Fields query.

Financials
financials array of Financial

Array of company's financials. Present only if "financials" has been indicated in the Fields query.

Documents
documents array of Document

Array of company's documents. Present only if "documents" has been indicated in the Fields query.

Certificates
certificates array of Certificate

Array of company's certificates. Present only if "certificates" has been indicated in the Fields query.

Publications
publications array of Publication

Array of company publications. Present only if "publications" has been indicated in the Fields query.

Establishments
establishments array of Establishment

Array of company establishments. Present only if "establishments" has been indicated in the Fields query.

Contacts
contacts array of Contact

Array of company contacts. Present only if "contacts" has been indicated in the Fields query.

Activity

Name Path Type Description
Activity Code
code string

Activity code.

Activity Name
name string

Activity name.

Certificate

Name Path Type Description
Type
type string

Type of document.

Date
date date

Document's publication date.

File Available
file_available boolean

File download availability.

Description
description string

File description.

Token
file_token binary

File token that can be used for downloads.

File Format
file_format string

File format.

Contact

Name Path Type Description
Type
type string

Type of contact.

Value
value string

The contact value.

Document

Name Path Type Description
Type
type string

Type of document.

Date
date date

Document's publication date.

File Available
file_available boolean

File download availability.

Description
description string

File description.

Token
file_token binary

File token that can be used for downloads.

File Format
file_format string

File format.

Establishment

Name Path Type Description
Number
number string

The number of the establishment.

Name
name string

Name of the establishment.

Trade Name
trade_name string

Trade name of the establishment.

Acronym
acronym string

Acronym of the establishment.

Activities
activities array of Activity

Array of establishment's activities, in the NACE classification.

Field of Activities
fields_of_activity array of string

Array of establishment's fields of activity, in the NACE classification.

Local Activities
local_activities array of LocalActivity

Array of establishment's activities, in the local classifications.

Creation Date
date_of_creation date

Establishment's creation date.

Status
status string

Indicates whether or not the company is still active.

Cessation Date
date_of_cessation date

Indicates the establishment's cessation date if establishment is inactive, otherwise null.

Address Line 1
address_line_1 string

The establishment's primary address line.

Address Line 2
address_line_2 string

The establishment's additional address line.

Postal Code
postal_code string

The establishment's local postal code.

City
city string

The establishment's city.

Country
country string

The establishment's country.

Financial

Name Path Type Description
Type
type string

The type of financials.

Start Date
financials_start_date date

The financials start date.

End Date
financials_end_date date

The financials end date.

Deposit Date
deposit_date date

The financials deposit date.

Currency
currency string

The financials currency.

Availability
availability string

The financials availability.

Ratio
ratios Ratios
Related Document
related_documents array of RelatedDocument

Array of documents related to the financials.

LocalActivity

Name Path Type Description
Code
code string

Activity code.

Name
name string

Activity name.

Classification
classification string

Activity classification.

Officer

Name Path Type Description
Type
type string

The officer's type.

Role
role string

The officer's role within the company.

Appointment Date
date_of_appointment date

The date of appointment of an officer.

Last Name
last_name string

The officer's last name, if physical officer.

First Name
first_name string

The officer's last name, if physical officer.

Gender
gender string

The officer's gender, if physical officer.

Birth Date
date_of_birth date

The officer's date of birth, if physical officer.

Birth Date Format
date_of_birth_format string

The officer's date of birth's format, if physical officer.

Nationality
nationality string

The officer's nationality, if physical officer.

Nationality Code
nationality_code string

The officer's nationality code, if physical officer.

Company Name
company_name string

The officer's company name, if legal officer.

Company Number
company_number string

The officer's company number, if legal officer.

Address Line 1
address_line_1 string

The officer's primary address line.

Address Line 2
address_line_2 string

The officer's additional address line.

Postal Code
postal_code string

The officer's local postal code.

City
city string

The officer's city.

Country
country string

The officer's country.

Country Code
country_code string

The officer's country code.

Publication

Name Path Type Description
Type
type string

Type of publication.

Date
date date

The publication date.

Source
source string

The publication's source.

Content
content string

The publication's content.

Ratios

Name Path Type Description
Turnover
turnover double

The company's turnover over that fiscal year.

Gross Profit
gross_profit double

The company's gross profit over that fiscal year.

EBITDA
ebitda double

The company's EBITDA over that fiscal year.

Operating Profit
operating_profit double

The company's operating profit over that fiscal year.

Net Income
net_income double

The company's net income over that fiscal year.

Revenue Growth Rate
revenue_growth_rate double

The company's revenue growth rate over that fiscal year.

Gross Margin Rate
gross_margin_rate double

The company's gross margin rate over that fiscal year.

EBITDA Margin
ebitda_margin double

The company's EBITDA margin over that fiscal year.

EBIT Margin
ebit_margin double

The company's EBIT margin over that fiscal year.

Working Capital Requirements
working_capital_requirements double

The company's working capital requirements over that fiscal year.

Day Sales Outstanding
day_sales_outstanding double

The company's day sales outstanding over that fiscal year.

Days Payable Outstanding
days_payable_outstanding double

The company's days payable outstanding over that fiscal year.

Cash Flow
cash_flow_from_operations double

The company's cash flow from operations over that fiscal year.

Net Working Capital
net_working_capital double

The company's net working capital over that fiscal year.

Cash
cash double

The company's cash over that fiscal year.

Financial Debt
financial_debt double

The company's financial debt over that fiscal year.

Net Financial Debt
net_financial_debt double

The company's net financial debt over that fiscal year.

Capital Debt Repayment Capacity
capital_debt_repayment_capacity double

The company's capital debt repayment capacity over that fiscal year.

Gearing
gearing_ratio double

The company's Gearing ratio over that fiscal year.

Leverage
leverage_ratio double

The company's leverage ratio over that fiscal year.

Debts Payable Within One Year
debts_payable_within_one_year double

The company's debts payable within one year over that fiscal year.

Debt Coverage
debt_coverage_ratio double

The company's debt coverage ratio over that fiscal year.

Equity
equity double

The company's equity over that fiscal year.

Net Margin
net_margin double

The company's net margin over that fiscal year.

Return on Equity
return_on_equity double

The company's return on equity over that fiscal year.

Value Added
value_added_ratio double

The company's value added ratio over that fiscal year.

Export Turnover
export_turnover double

The company's export turnover over that fiscal year.

RelatedDocument

Name Path Type Description
Type
type string

Type of document.

Date
date date

Document's publication date.

File Available
file_available boolean

File download availability.

Description
description string

File description.

Token
file_token binary

File token that can be used for downloads.

File Format
file_format string

File format.

SearchResponse

Name Path Type Description
Results
results array of SearchFormat

The results of the search is an array of companies that satisfy the specified criterias.

Total
total integer

Number of companies returned by the response.

Current Page Index
page integer

Current page index.

Ubo

Name Path Type Description
Last Name
last_name string

The owner's last name.

First Name
first_name string

The owner's last name.

Gender
gender string

The owner's gender.

Birth Date
date_of_birth date

The owner's date of birth.

Birth Date Format
date_of_birth_format string

The owner's date of birth's format.

Nationality
nationality string

The owner's nationality.

Nationality Code
nationality_code string

The owner's nationality code.

Address Line 1
address_line_1 string

The owner's primary address line.

Address Line 2
address_line_2 string

The owner's additional address line.

Postal Code
postal_code string

The owner's local postal code.

City
city string

The owner's city.

Country
country string

The owner's country.

Country Code
country_code string

The owner's country code.

Share Percentage
percentage_of_shares string

The owner share percentage.

Voting Percentage
voting_percentage string

The owner voting percentage.