great tutorial, thx for sharing
The open data in Denmark has started to evolve – and now a public marketplace of data and apps is available as well via – https://data.virk.dk/
One of the apps in the App market is actually very nice and can then be used in Excel to wash/check your master about Danish companies. The app is a mirror of data from The Central Business Register – http://www.CVR.dk and can be accessed via http://cvrapi.dk/, and is not associated with http://cvr.dk
Using the new Excel functions WEBSERVICE and FILTERXML can then be used to lookup values via the API.
First I found a list of all the companies in Denmark where the name Microsoft was included.
A simple search via the API – for the first VAT number gives me the result but also the syntax to call the API – http://cvrapi.dk/api?search=13612870&country=dk
The documentation reveals that the result can be returned either as…
Ursprünglichen Post anzeigen 160 weitere Wörter