> Markdown versions of all pages of this connector library are available by appending `.md` to the page URL. For the full index of connectors, see [llms.txt](https://connectors.appmixer.com/llms.txt).

# appmixer.merk.database.SearchCompany

- Component: `appmixer.merk.database.SearchCompany`
- Kind: Action
- Version: 1.0.0
- Visibility: Public
- Connector: [appmixer.merk 1.2.3](https://connectors.appmixer.com/connector/appmixer.merk/1.2.3.md)
- Component page: <https://connectors.appmixer.com/connector/appmixer.merk/1.2.3/component/appmixer.merk.database.SearchCompany>

This action provides you company data from given company name (or part of it), email address or regno (also known as IČ - unique identifier for czech and slovak companies).

## Input ports

### Port `query`

| Field | Type | Description |
| --- | --- | --- |
| Company name (or part of it) (`name`) | text | - |
| Email address (`email`) | text | - |
| Company registration number (IC) (`regno`) | text | - |
| Number of returned results (`count`) | number | - |

## Output ports

### Port `company`

| Field | Type | Description |
| --- | --- | --- |
| Registration number (`regno`) | integer | - |
| VAT number (cz: DIČ, sk: IČ DPH) (`vatno`) | string,null | - |
| Tax number (sk: DIČ, cz: null) (`taxno`) | string,null | - |
| Databox IDs (datové schránky) (`databox_ids`) | array,null | - |
| Subject name (`name`) | string | - |
| Legal form name (`legal_form.text`) | string | - |
| Legal form ID (`legal_form.id`) | integer | - |
| Establishment date (`estab_date`) | string,null | - |
| Is subject active or not (`is_active`) | boolean | - |
| Country code (2 char) (`address.country_code`) | string | - |
| Address descriptive number (`address.number_descriptive`) | string,null | - |
| Address municipality part (`address.municipality_part`) | string,null | - |
| Address municipality (`address.municipality`) | string | - |
| Address number (`address.number`) | string,null | - |
| Address municipality first (`address.municipality_first`) | string,null | - |
| Address street fixed (`address.street_fixed`) | string,null | - |
| Address street (`address.street`) | string,null | - |
| Address postal code (`address.postal_code`) | string,null | - |
| Address number orientation (`address.number_orientation`) | string,null | - |
| Address region ID (`address.region.id`) | string,null | - |
| Address region Text (`address.region.text`) | string,null | - |
| Address county ID (`address.county.id`) | string,null | - |
| Address county (`address.county.text`) | string,null | - |
| List of bank accounts (`bank_accounts`) | array,null | - |
| List of contact phones (`phones`) | array,null | - |
| List of contact mobile phones (`mobiles`) | array,null | - |
| List of contact emails (`emails`) | array,null | - |
| List of web pages (`webs`) | array,null | - |
| Main industry ID (`industry.id`) | string,null | - |
| Main industry text (`industry.text`) | string,null | - |
| Secondary industries and their codes (`secondary_industries`) | array,null | - |
| Company magnitude ID (`magnitude.id`) | integer,null | - |
| Company magnitude trend (`magnitude.trend`) | string,null | - |
| Company magnitude lower bound (`magnitude.lower_bound`) | string,null | - |
| Company magnitude upper bound (`magnitude.upper_bound`) | string,null | - |
| Company magnitude text (`magnitude.text`) | string,null | - |
| Company turnover ID (`turnover.id`) | integer,null | - |
| Company turnover trend (`turnover.trend`) | string,null | - |
| Company turnover lower bound (`turnover.lower_bound`) | string,null | - |
| Company turnover upper bound (`turnover.upper_bound`) | string,null | - |
| Company turnover text (`turnover.text`) | string,null | - |
| Court file number (`court.file_nr`) | string,null | - |
| Court name (`court.name`) | string,null | - |
| Is company a VAT payer? (`is_vatpayer`) | boolean | - |
| Vatpayer registration § (`vat_registration_type`) | boolean,string,null | - |
| Unreliable VAT payer (`is_unreliable_vatpayer`) | boolean | - |
| Unreliable VAT payer date since (`unreliable_vatpayer_since`) | string,null | - |
| Currently owed sum to VZP (`vzp_debt`) | string,number,null | - |

## Full metadata (component.json)

```json
{
  "name": "appmixer.merk.database.SearchCompany",
  "author": "David Durman <david@client.io>",
  "description": "This action provides you company data from given company name (or part of it), email address or regno (also known as IČ - unique identifier for czech and slovak companies).",
  "inPorts": [
    {
      "name": "query",
      "schema": {
        "type": "object",
        "properties": {
          "name": {
            "type": "string",
            "minLength": 2
          },
          "email": {
            "type": "string"
          },
          "regno": {
            "type": "string"
          },
          "count": {
            "type": "integer",
            "minimum": 0,
            "maximum": 10
          }
        }
      },
      "inspector": {
        "inputs": {
          "name": {
            "type": "text",
            "group": "transformation",
            "index": 1,
            "label": "Company name (or part of it)",
            "attrs": {
              "label": {
                "data-tooltip": "Company name (or part of it)."
              }
            }
          },
          "email": {
            "type": "text",
            "group": "transformation",
            "index": 2,
            "label": "Email address",
            "attrs": {
              "label": {
                "data-tooltip": "Email address of a contact person in the company."
              }
            }
          },
          "regno": {
            "type": "text",
            "group": "transformation",
            "index": 3,
            "label": "Company registration number (IC)",
            "attrs": {
              "label": {
                "data-tooltip": "Company registration number (IC) with or without leading zeros."
              }
            }
          },
          "count": {
            "type": "number",
            "group": "transformation",
            "index": 3,
            "label": "Number of returned results",
            "attrs": {
              "label": {
                "data-tooltip": "Maximum number of returned results. Set to 1 if you're interested in the best match only. By default, maximum number of results of what the Merk database allows is used, i.e. 10."
              }
            }
          }
        },
        "groups": {
          "transformation": {
            "label": "Transformation",
            "index": 1
          }
        }
      }
    }
  ],
  "outPorts": [
    {
      "name": "company",
      "options": [
        {
          "label": "Registration number",
          "value": "regno",
          "schema": {
            "type": "integer",
            "example": 28547888
          }
        },
        {
          "label": "VAT number (cz: DIČ, sk: IČ DPH)",
          "value": "vatno",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "CZ28547888"
          }
        },
        {
          "label": "Tax number (sk: DIČ, cz: null)",
          "value": "taxno",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": null
          }
        },
        {
          "label": "Databox IDs (datové schránky)",
          "value": "databox_ids",
          "schema": {
            "type": [
              "array",
              "null"
            ],
            "example": [
              "v4vhaq5"
            ]
          }
        },
        {
          "label": "Subject name",
          "value": "name",
          "schema": {
            "type": "string",
            "example": "Imper CZ s.r.o."
          }
        },
        {
          "label": "Legal form name",
          "value": "legal_form.text",
          "schema": {
            "type": "string",
            "example": "Společnost s ručením omezeným"
          }
        },
        {
          "label": "Legal form ID",
          "value": "legal_form.id",
          "schema": {
            "type": "integer",
            "example": 112
          }
        },
        {
          "label": "Establishment date",
          "value": "estab_date",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "2009-03-20T00:00:00"
          }
        },
        {
          "label": "Is subject active or not",
          "value": "is_active",
          "schema": {
            "type": "boolean",
            "example": true
          }
        },
        {
          "label": "Country code (2 char)",
          "value": "address.country_code",
          "schema": {
            "type": "string",
            "example": "cz"
          }
        },
        {
          "label": "Address descriptive number",
          "value": "address.number_descriptive",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "359"
          }
        },
        {
          "label": "Address municipality part",
          "value": "address.municipality_part",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "Smíchov"
          }
        },
        {
          "label": "Address municipality",
          "value": "address.municipality",
          "schema": {
            "type": "string",
            "example": "Praha"
          }
        },
        {
          "label": "Address number",
          "value": "address.number",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "359/6"
          }
        },
        {
          "label": "Address municipality first",
          "value": "address.municipality_first",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "Praha"
          }
        },
        {
          "label": "Address street fixed",
          "value": "address.street_fixed",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "Viktora Huga"
          }
        },
        {
          "label": "Address street",
          "value": "address.street",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "Viktora Huga"
          }
        },
        {
          "label": "Address postal code",
          "value": "address.postal_code",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "15000"
          }
        },
        {
          "label": "Address number orientation",
          "value": "address.number_orientation",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "6"
          }
        },
        {
          "label": "Address region ID",
          "value": "address.region.id",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "CZ010"
          }
        },
        {
          "label": "Address region Text",
          "value": "address.region.text",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "Hlavní město Praha"
          }
        },
        {
          "label": "Address county ID",
          "value": "address.county.id",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "CZ0100"
          }
        },
        {
          "label": "Address county",
          "value": "address.county.text",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "Praha"
          }
        },
        {
          "label": "List of bank accounts",
          "value": "bank_accounts",
          "schema": {
            "type": [
              "array",
              "null"
            ],
            "example": [
              {
                "account_number": "123456789",
                "bank_code": "0100"
              }
            ]
          }
        },
        {
          "label": "List of contact phones",
          "value": "phones",
          "schema": {
            "type": [
              "array",
              "null"
            ],
            "example": [
              "+420123456789"
            ]
          }
        },
        {
          "label": "List of contact mobile phones",
          "value": "mobiles",
          "schema": {
            "type": [
              "array",
              "null"
            ],
            "example": []
          }
        },
        {
          "label": "List of contact emails",
          "value": "emails",
          "schema": {
            "type": [
              "array",
              "null"
            ],
            "example": [
              "info@example.cz"
            ]
          }
        },
        {
          "label": "List of web pages",
          "value": "webs",
          "schema": {
            "type": [
              "array",
              "null"
            ],
            "example": [
              "https://www.example.cz"
            ]
          }
        },
        {
          "label": "Main industry ID",
          "value": "industry.id",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "68310"
          }
        },
        {
          "label": "Main industry text",
          "value": "industry.text",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "Zprostředkovatelské činnosti realitních agentur"
          }
        },
        {
          "label": "Secondary industries and their codes",
          "value": "secondary_industries",
          "schema": {
            "type": [
              "array",
              "null"
            ],
            "example": [
              {
                "id": "73200",
                "text": "Průzkum trhu a veřejného mínění"
              }
            ]
          }
        },
        {
          "label": "Company magnitude ID",
          "value": "magnitude.id",
          "schema": {
            "type": [
              "integer",
              "null"
            ],
            "example": 210
          }
        },
        {
          "label": "Company magnitude trend",
          "value": "magnitude.trend",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "rising"
          }
        },
        {
          "label": "Company magnitude lower bound",
          "value": "magnitude.lower_bound",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "10 zam."
          }
        },
        {
          "label": "Company magnitude upper bound",
          "value": "magnitude.upper_bound",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "19 zam."
          }
        },
        {
          "label": "Company magnitude text",
          "value": "magnitude.text",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "10 - 19 zaměstnanců"
          }
        },
        {
          "label": "Company turnover ID",
          "value": "turnover.id",
          "schema": {
            "type": [
              "integer",
              "null"
            ],
            "example": 70
          }
        },
        {
          "label": "Company turnover trend",
          "value": "turnover.trend",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "rising"
          }
        },
        {
          "label": "Company turnover lower bound",
          "value": "turnover.lower_bound",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "10 mil. Kč"
          }
        },
        {
          "label": "Company turnover upper bound",
          "value": "turnover.upper_bound",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "29,999 mil. Kč"
          }
        },
        {
          "label": "Company turnover text",
          "value": "turnover.text",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "10 000 000 - 29 999 999 Kč"
          }
        },
        {
          "label": "Court file number",
          "value": "court.file_nr",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "C 149457"
          }
        },
        {
          "label": "Court name",
          "value": "court.name",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": "Městský soud v Praze"
          }
        },
        {
          "label": "Is company a VAT payer?",
          "value": "is_vatpayer",
          "schema": {
            "type": "boolean",
            "example": true
          }
        },
        {
          "label": "Vatpayer registration §",
          "value": "vat_registration_type",
          "schema": {
            "type": [
              "boolean",
              "string",
              "null"
            ],
            "example": null
          }
        },
        {
          "label": "Unreliable VAT payer",
          "value": "is_unreliable_vatpayer",
          "schema": {
            "type": "boolean",
            "example": false
          }
        },
        {
          "label": "Unreliable VAT payer date since",
          "value": "unreliable_vatpayer_since",
          "schema": {
            "type": [
              "string",
              "null"
            ],
            "example": null
          }
        },
        {
          "label": "Currently owed sum to VZP",
          "value": "vzp_debt",
          "schema": {
            "type": [
              "string",
              "number",
              "null"
            ],
            "example": null
          }
        }
      ]
    }
  ],
  "auth": {
    "service": "appmixer:merk"
  },
  "icon": "(data URI omitted)"
}
```
