I’ve uploaded on my public space a template you could use to query VIES with the VAT number.
Please lookup workflow: LOOKUP_VIES_VAT_NUMBER – KNIME Community Hub
Some sample are included in the “Table Creator” for you to understand how it works (quite easy, you’ll see).
Normally, VIES use SOAP protocol (xml). But you can use the same logic of API’s also. For this, you just have to send a GET request with this query :
Just replace the XX by the country code (2 char iso country that VAT number should start with) and the # by the VAT number (after the country code). There is no authentification needed but there is a limit rate. In this case, you will receive a “MS_MAX_CONCURRENT_REQ” status.
For the limit rate, and before querying, you should first check that your VAT number is correct (maybe with a regex) and check the last date query for every row and query old data only.
Then the response should be treated with a “JSON Path” node :
GB are not included anymore. For that, you should use GOV.UK service (free also).
Please also check the list of country available and the availability of data (some are down for a certain time, so you will not have any response 200).
:
