×

Aanmelden

Gratis account aanmaken

Wil je een indruk krijgen van de mogelijkheden van Innovatiespotter? Maak nu een gratis account aan en krijg een selectie van innovatieve bedrijven.

*: verplicht

Voornaam*
Achternaam*
Voornaam*
Achternaam*
Bedrijfsnaam*
E-mailadres*
Telefoonnummer
Wachtwoord*
Wachtwoord herhalen*
Heb je een account?
Je kan hier inloggen.
×
Innovatiespotter

Innovatiespotter API

Index

  1. Endpoints
  2. Response fields
  3. Integration with Power BI

Endpoints

1. Search (https://online.innovatiespotter.nl/api/search, https://online.innovatiespotter.nl/api/quicksearch)

Takes a text argument (in parameter "q") and returns a list of companies matching that text either in the company name or in the kvk number. It's a multi field search. You can see an implementation of this kind of quick search in the homepage of online.innovatiespotter.nl. The amount of returned results can be defined with the parameter "page_size" (default 10). You receive the first page of results by default, but you can request another page using the parameter "page_number" (default 1).

Search applies a detailed multi-criteria search everywhere, quicksearch applies a quicksearch only within companies in your subscription.

1.1 Parameters
  1. q -> text (required)
  2. page_size -> 0 to 50 (10 default)
  3. page_number -> 1 to ($page_size*($page_number-1)<50) (1 default)
1.2 Examples of use
  1. https://online.innovatiespotter.nl/api/search?q=b.v.  => This request will return the first page of results, consisting of 10 companies that match the text "b.v.".
  2. https://online.innovatiespotter.nl/api/search?q=b.v&page_size=20 => This request will return the first page of results, consisting of 20 companies that match the text "b.v.".
  3. https://online.innovatiespotter.nl/api/search?q=b.v&page_size=20&page_number=2 => This request will return the second page of results, consisting of 20 companies that match the text "b.v.".
1.3 Example of AJAX request
$.get('https://online.innovatiespotter.nl/api/search', {'q': 'b.v.', 'page_size': 20}, yourOnSuccessFunction() );
1.4 Response codes
200 -> OK
4XX -> client error (login, wrong parameters etc)
5XX -> server error

2. Companies (https://online.innovatiespotter.nl/api/companies)

Returns a paginated list of the companies in your subscription. You can filter them by themes (location and other filters are a work in progress). In the response you will get the location and other info, so you can use that to show some geographic data or to implement a temporary filter in the frontend.

2.1 Parameters
page_size -> 1-100 (100 default)
page_number -> 1-ceil(total_results/page_size)
sort_column -> (id, bedrijfsnaam, adres, postcode, plaats, provincie, werknemers, jaar, rechtsvorm, bag, kvk, datum_toegevoegd, geregistreerd, status_aangepast, score) (datum_toegevoegd default, for keywords: score default and the only one allowed)
sort_direction -> (asc, desc) (asc default)
2.2 Filters
Comma ',' is used to list multiple string/numeric values or to define a numerical range.
For ranges only one is allowed and it is obligatory. For lists more than one are allowed and they are optional. 

bag -> string filter (values from https://online.innovatiespotter.nl/api/filter_values/bag)
economischactief -> boolean filter (values: true false)
geregistreerd -> boolean filter (values: true false)
jaar -> range integer filter (values: 0 - current year)
keywords -> query string filter (simple queries to be used as: "cell therapy" AND patient)
plaats -> string filter (values from https://online.innovatiespotter.nl/api/filter_values/plaats)
postcode -> string filter (4 digits or 4 digits and 2 letters)
provincie -> string filter (values from https://online.innovatiespotter.nl/api/filter_values/provincie)
rechtsvorm -> string filter (values from https://online.innovatiespotter.nl/api/filter_values/rechtsvorm)
sbi_code -> query numeric multiple values filter [hierarchical field] (values from https://online.innovatiespotter.nl/api/filter_values/sbi_code)
themas -> string filter (values from https://online.innovatiespotter.nl/api/filter_values/themas)
type_bedrijf -> string filter (values from https://online.innovatiespotter.nl/api/filter_values/type_bedrijf)
vestigingstype -> query string multiple values filter (values from https://online.innovatiespotter.nl/api/filter_values/vestigingstype)
werknemers -> range string filter (values from https://online.innovatiespotter.nl/api/filter_values/werknemers)
kvk -> numeric multiple values filter [8 digits per kvk]
vestigingsnummer -> numeric multiple values filter [12 digits per vestigingsnummer]
2.3 Examples of use
  1. https://online.innovatiespotter.nl/api/companies => Is the default request. Returns 100 companies in your subscription.
  2. https://online.innovatiespotter.nl/api/companies?geregistreed=true&economischactief=true => Fetches all active and economic active registrations.
  3. https://online.innovatiespotter.nl/api/companies?sort_direction=desc&sort_column=werknemers&werknemers=Cat. 01: 1 - 1,Cat. 05: 20 - 49 => werknemers filter.
  4. https://online.innovatiespotter.nl/api/companies?sort_direction=desc&sort_column=jaar&jaar=2010,2017 => jaar filter.
  5. https://online.innovatiespotter.nl/api/companies?themas=im_proef_ict,im_proef_not_existing,im_proef_bouw => themas filter.
  6. https://online.innovatiespotter.nl/api/companies?bag=kantoorfunctie => bag filter.
  7. https://online.innovatiespotter.nl/api/companies?postcode=1999 ,1901,2105mg,8911 eR => postcode filter.
  8. https://online.innovatiespotter.nl/api/companies?plaats=leeuwarden,groningen => plaats filter.
  9. https://online.innovatiespotter.nl/api/companies?provincie=Utrecht,Groningen => provincie filter.
  10. https://online.innovatiespotter.nl/api/companies?sort_column=rechtsvorm&rechtsvorm=B.V.,C.V.&page_number=14 => rechtsvorm filter.
  11. https://online.innovatiespotter.nl/api/companies?type_bedrijf=Aardgas,Financi%C3%ABle dienstverlening,Eet- en drinkgelegenheden,ICT-dienstverlening => type_bedrijf filter.
  12. https://online.innovatiespotter.nl/api/companies?sort_direction=desc&sort_column=jaar&postcode=1999, 1901,2105mg,8911 eR&jaar=2010, 2017&bag=kantoorfunctie => Combination of filters.
  13. https://online.innovatiespotter.nl/api/companies?sort_direction=desc&sort_column=jaar&postcode=1999 ,1901,2105mg,8911 eR&jaar=2010, 2017&bag=kantoorfunctie&plaats=leeuwarden,groningen&themas=im_proef_ict,im_proef_not_existing,im_proef_bouw&rechtsvorm=B.V.&type_bedrijf=Aardgas,Financi%C3%ABle dienstverlening,Eet- en drinkgelegenheden,ICT-dienstverlening => multiple extensive filtering.
  14. https://online.innovatiespotter.nl/api/companies?geregistreed=true&keywords=%22cell%20therapy%22%20AND%20patient => keywords filter fetching only active companies.
  15. https://online.innovatiespotter.nl/api/companies?vestigingstype=Hoofdvestiging => vestigingstype filter fetching only Hoofdvestiging companies [note first capital letter].
  16. https://online.innovatiespotter.nl/api/companies?geregistreed=true&economischactief=true&sbi_code=09,139 => Fetches active and economic active registrations with sbi_code 08 (Dienstverlening voor de winning van delfstoffen) and its subcategories as well as sbi_code 139 (Vervaardiging van overige textielproducten) and its subcategories.
  17. https://online.innovatiespotter.nl/api/companies?geregistreed=true&economischactief=true&sbi_code_exclude=09,139 => Fetches all active and economic active registrations excluding ones with sbi_code 08 (Dienstverlening voor de winning van delfstoffen) and its subcategories as well as sbi_code 139 (Vervaardiging van overige textielproducten) and its subcategories.
  18. http://online.innovatiespotter.nl/api/companies?kvk=56819528,61556173,16050353 => Fetches all branches from the companies with the listed kvks.
  19. http://online.innovatiespotter.nl/api/companies?kvk=16050353&vestigingsnummer=000021885613 => Fetches specific branch of companies using combination of vestigingsnummer and kvk.

Check the response of the examples above by entering those urls in your browser. You should see a json response.

2.4 Example of AJAX request
$.get('https://online.innovatiespotter.nl/api/companies', {'themas': 'im_proef_energie'}, yourOnSuccessFunction() );
2.5 Response codes
200 -> OK
4XX -> client error (login, wrong parameters etc)
5XX -> server error

3. Filter values (https://online.innovatiespotter.nl/api/filter_values)

These are the names we use in the backend for referring to the themes you see in the frontend, so for example if you want to filter by the theme "Energie", you have to use the label name im_proef_energie in your request.
So we use this endpoint to provide you with the backend filter names you need to use when you are filtering in companies endpoint.

3.1 Parameters
In this unique parameter you must specify the name of the filter for which you want to know the values. 
q -> text (required) [case insensitive]
Possible values: all, rechtsvorm, type_bedrijf, Type Bedrijf, bag, werknemers, themas, Thema's, plaats.
3.2 Examples of use
  1. https://online.innovatiespotter.nl/api/filter_values/all
  2. https://online.innovatiespotter.nl/api/filter_values/themas

Check the response of the examples above by entering those urls in your browser. You should see a json response.

3.3 Example of AJAX request
$.get('https://online.innovatiespotter.nl/api/filter_values/themas', yourOnSuccessFunction() );
3.4 Response codes
200 -> OK
4XX -> client error (login, wrong parameters etc)
5XX -> server error

4. Company full data (https://online.innovatiespotter.nl/api/company_full)

Here you can request up to 10 companies with their IDs to retrieve their whole information if they are within your subscription. If not you will get only free fields. You can request up to 1 company as an arg and up to 10 with parameter id separated by comma.

4.1 Parameters/Arguments:

id -> positive integer (required)

4.2 Example of use:

https://online.innovatiespotter.nl/api/company_full/3441068

https://online.innovatiespotter.nl/api/company_full?id=3441068,3593466,2678774,4,3040748 

4.3 Example of AJAX request:
$.get('https://online.innovatiespotter.nl/api/company_full/3441068', yourOnSuccessFunction() );

4.4 Response codes
200 -> OK
4XX -> client error (login, wrong parameters etc)
5XX -> server error

Response fields

Field Present in endpoints Premium field
ID 1, 2, 4
Datum Toegevoegd 1, 2, 4
Bedrijfsnaam 1, 2, 4
Handelsnamen 1, 2, 4
Thema's 1, 2, 3, 4
Topics 1, 2, 3, 4
Innovatie-footprint 1, 2, 4
Websites 1, 2, 4
Adres 1, 2, 4
Postcode 1, 2, 4
Plaats 1, 2, 3, 4
Gemeente 1, 2, 4
Provincie 1, 2, 4
Type Bedrijf 2, 3, 4
Werknemers 1, 2, 3, 4
Jaar 1, 2, 4
Rechtsvorm 1, 2, 3, 4
BAG 1, 2, 3, 4
SBI Code 1, 2, 4
SBI Hoofdactiviteit 1, 2, 4
Keywords-Snippet 2
SBI Branche 4
Vestiging 1, 2, 4
Vestigingsnummer 4
KvK-Nummer 1, 2, 4
E-mails 4
Telefoon 4
LinkedIn 4
Geregistreerd 1, 2, 4
Geregistreerde Status Aangepast 1, 2, 4
in_subscription 1, 4

Integration with Power BI

1. Open Power BI Desktop app

2. Click on "Get data" and select "Web"



3. Insert the API endpoint url



4. Select "Basic" authentication and insert credentials (mail + password)



5. Browse the data and convert it to the desired format











Get MKB in CSV with Python

Example of import script to fetch data from Online Innovatiespotter API in Python:

 
import config
start = time.time()

df = pd.DataFrame()
pages = list(range(1, 10))

for (i in pages):
  try:
    url = 'https://online.innovatiespotter.nl/api/companies?sort_direction=desc&sort_column=
werknemers&werknemers=Cat. 01: 1 - 1,Cat. 07: 100 - 249&geregistreerd=true&page_number='+str(i)
    response = requests.get(url, auth=(config.username, config.password))
    d = json.loads(response.text)
    companies = d['companies']
    df = df.append(pd.DataFrame(companies))
    df.to_csv('innovatiespotter.csv')
    time.sleep(1)
    print("page number=", i)
  except:
    print("something went wrong on page number ", i)
end = time.time()
print(end-start)