Custom connector for Microsoft Power Automate

Dutch company data in your Power Automate flow.

Add one action to your flow. Pass in a KVK number and get the company name, trade name and registered address back as separate fields. Only have a name? Search for it and get the KVK number.

  • Live from the KVK register
  • Nothing stored
  • Personal API key
Power Automate · Try the action
Get company detailsFlowwise

Example with public register data for AFC Ajax N.V.

Outputs · available as dynamic content in the next step
companyName
AFC Ajax N.V.
tradeName
AFC Ajax N.V.
address
Johan Cruijff Boulevard 29, 1101 AX Amsterdam
How it works

One action between your trigger and your next step.

The connector takes a value from the previous step, looks it up in the KVK register and hands the result to the next step as dynamic content.

01

Pass in a KVK number or name

Use the value from a form, CRM record, e-mail or any other trigger in your flow.

02

Flowwise finds the company

The connector validates the input and retrieves the registered company data in real time. Nothing is stored.

03

Use the result

Write the name and address to your CRM, a document or an approval flow as separate fields.

Get company details

From KVK number to the registered name and address.

Give the action an eight-digit KVK number. It returns the company as it is registered, with the address split into street, house number, postal code and city.

  • Intake forms: the prospect only types the KVK number, the flow fills in the rest.
  • Supplier onboarding: master data in your ERP or SharePoint list comes straight from the register.
  • Quotes and invoices: the addressee is right the first time.
See all fields →
{
  "kvkNumber": "33302453",
  "companyName": "AFC Ajax N.V.",
  "tradeName": "AFC Ajax N.V.",
  "address": {
    "street": "Johan Cruijff Boulevard",
    "houseNumber": "29",
    "houseNumberAddition": null,
    "postalCode": "1101AX",
    "city": "Amsterdam",
    "countryCode": "NL"
  }
}
Find companies by name

Only have a name? Get the KVK number.

Search the register by company or trade name. You get the best match plus up to 20 results, each with its KVK number and address, in the register's own ranking order.

  • Take bestMatch.kvkNumber to fill in a number automatically.
  • Loop over results when a person has to choose.
  • No hits is a normal, empty result, not an error.
Read the API definition →
{
  "query": "Ajax",
  "totalResults": 1,
  "bestMatch": {
    "kvkNumber": "33302453",
    "companyName": "AFC Ajax N.V.",
    "tradeName": "AFC Ajax N.V.",
    "address": { "street": "Johan Cruijff Boulevard", "city": "Amsterdam", … }
  },
  "results": [ … one entry per KVK number ]
}
In your flow

It fits where you already work.

The connector is a normal Power Automate action. It sits between your trigger and your next step, and its outputs show up as dynamic content like any other connector.

  • Works with Microsoft Forms, Dynamics 365, Dataverse, SharePoint, Outlook and any other connector.
  • Also usable outside Power Automate: a plain HTTPS API with an OpenAPI definition.
  1. FMicrosoft FormsWhen a new response is submitted
  2. FlowwiseGet company details
  3. DDataverseAdd a new row · Accounts

Example: a new form response creates an account with the registered company name and address.

Fields

Every value as a separate field.

No parsing of address strings. Each part of the result is available as dynamic content in Power Automate. ‘Find companies by name’ returns the same fields per result, plus bestMatch and totalResults.

FieldExampleDescription
kvkNumber33302453The Dutch KVK number you passed in.
companyNameAFC Ajax N.V.The registered company name.
tradeNameAFC Ajax N.V.The current trade name.
Registered visiting address
streetJohan Cruijff BoulevardStreet name.
houseNumber29House number.
houseNumberAddition—Optional addition, empty when not registered.
postalCode1101AXDutch postal code without spaces.
cityAmsterdamCity or town.
countryCodeNLISO 3166-1 alpha-2 country code.
Installation

Ready for your environment.

You receive a personal API key and the OpenAPI file for the custom connector. We help with the first installation.

  1. Request accessTell us which Power Automate environment will use the connector.
  2. Import the custom connectorImport the supplied OpenAPI file in Microsoft Power Automate.
  3. Create a connection with your API keyOpen the connector, enter your personal API key and test the connection.
  4. Add an action to your flowUse ‘Get company details’ or ‘Find companies by name’ and pass the output to the next step.

Required: a Microsoft Power Automate environment that allows custom connectors. A Premium licence may be required. Rate limit: 60 lookups per minute per customer.

Frequently asked questions

Is this an official Microsoft connector?

Not yet. You install it as a custom connector in your own Power Automate environment. Flowwise supplies the OpenAPI file and helps with installation.

Which data fields do I receive?

The KVK number, company name, trade name and registered visiting address, each as a separate field. See the field overview above.

Can I search by company name instead of a KVK number?

Yes. ‘Find companies by name’ searches the register by company or trade name and returns the best match plus up to 20 results, each with its KVK number.

Can I get my own API key?

Yes. Each customer receives a personal key, so access and usage can be managed and revoked independently.

What happens to my KVK number?

The service only uses the number to retrieve data during the request. It does not store the KVK number or the returned company data.

Can I use the API outside Power Automate?

Yes. The connector is a plain HTTPS API with an OpenAPI definition, so it also works from Make, n8n, Zapier or your own software.

Let your flow do the lookup.

Request access and we send you the connector, your personal API key and a short installation guide.