Hi,
I'm trying to create a flow that verifies if a VAT number is active according to the EU website http://ec.europa.eu/taxation_customs/vies/?locale=en
They have an API that can be used to verify this: http://ec.europa.eu/taxation_customs/vies/checkVatService.wsdl
I started for this from an other API flow but I do not see how I can reuse this in this case.
The enlcosed flow has a VAT number in a second file input file which can be validated via the AP.
Thanks for the support.
@speedway So I spent some time with the SOAP api this morning. After going through the WSDL and some examples I found online I was able to get a working SOAP request without having to replicate the form data used by the interactive website. The example injects the VAT number and country code into an XML request body for the SOAP api and passes it to the VIES service. The response back is an XML response with the validation information. I didn't bother parsing the response so you will need to do that on your own but this example should at least get you started with the SOAP api instead of using the alternative REST provider I originally recommended.
@speedway Is using a third party API wrapper an option? If so a third party that uses a REST API to provide this same data would be much simpler to develop a workflow for. I was able to find a number of third parties that provide various alternatives to the SOAP API provided by europa.eu for VIES VAT validation. Using one of these third parties I was able to toss together a simple REST API example (See attached). The third party provider I used was isvat.eu and per their documentation all the data returned comes from the VIES VAT Validation System.
If using a third party is not an option the options to use eurpopa.eu's SOAP API would be to either mimic the form data submitted by their web form. This would require capturing network traffic for a successful form submission and indepth review of their html for the web form to piece the process together. The other option would be to develop a direct SOAP API integration which would require detailed documentation of the API and knowledge of how SOAP API's work. From looking at the information available it seems most of the SOAP API documentation is in the WSDL file rather than documented on their website. My experience with SOAP API's is also limited so I wasn't able to piece together a working example for you.
Thanks for the response, this indeed works however, the amount of checks is limited to only 1.000 per month (which is unfortunately to limited for the project I'm working on).
As this is connecting to the official VIES website, I guess it should be possible to also connect to the VIES website directly.
I know that our accounting software (MS Dynamics NAV) has a connector directly to the VIES website, that's probably the SOAP API option you are referring to.
I'm able to get some response using the XML Parse but nothing I can work with.
@KevinP this is really a great effort and helps lot if Indirect Tax teams, and can enhance the scope if it works to check the multiple VAT Id validation and download the data into form.
The reason being, changes in the API and I think VIES has new API for this validation.
If some one can help us with New API is much appreciated
I can heavily recommend to take a look to this Post. This explains how to create a API call against a SOAP Interface.
Hi David,I have checked your link which explains the SOAP API. when I tried using the tool SOAPUI the XML request got the corresponding XML response as shown in the below image.
But I tried using the same XML request and URL request in the download tool, getting the error as HTTP/1.1 500 Internal Server Error in the Downloadheaders column as shown in the below image.
Is this issue related to the server?
Do we have any new validation available?
Hi @mahadevaswab , @Kingazawora ,
it looks like the API requires now a Content-Type Header information. I don't know thy, but for me this solves the issue.
I used the SoapUI Tool which was used here to check out the request.
As it was working in SoapUI I checked the Headers used for this request and simply tried them one by one. The Content-Type was the missing one.
Please find attached an updated version of the Workflow @KevinP created.
Best regards,
David
Great, this worked for me. Thanks!!
Could someone update above? The website is now: https://ec.europa.eu/taxation_customs/vies/#/vat-validation
Hi @Kingazawora,
the API has not changed and is still working.
For a working Version please check out my last post in this thread.
If you are looking for something different I would recommend to open a new thread.
Thanks
hello all
I am trying to have the validation for the Slovakian VAT numbers as well for my internal processes. Website: https://www.financnasprava.sk/sk/elektronicke-sluzby/verejne-sluzby/zoznamy/detail/_101c6128-e1f6-4a48-81ed-ad3c01220e03
To have the process executed, I need to file in here:
I have tried to adjust the same process as for VIES, but not completely. Could someone help here?
@Kingazawora, as this is a new/different solution you are looking for I would recommend to open a new thread for this. Feel free to tag me if the Community is not able to help in the new thread.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/API-Connection-to-the-checker-of-VAT-numbers-in-Slovakia/m-p/1066541
Hi all, I had a perfectly working workflow for years - though didn't use it the last +- 2 years and now I seem to get an error. May I kindly ask whether someone could have a look at this workflow? I have a decent basic knowledge of Alteryx, but the API functionality is a bit above my level of expertise. Would be VERY grateful if someone could solve this.
Kind regards,Christoph
Hi @ChristophVW,
the solution was already provided here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Verification-VAT-numbers-VIES-website/m-p/987518/highlight/true#M244184
You need to add an header to the Download Tool
Content-Type: text/xml;charset=UTF-8
Then everything should be fine.
Dear experts, VIES VAT ID validation is throwing the below error instead of download the data required.
Could you kindly advise how to fix it and also the sample workflow which is working for VAT ID validation for EU countries
.
Error: XML Parse (12): attribute name expected at Line:1 and Column:23 at value <env:Envelopexmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header/><env:Body><ns2:checkVatResponsexmlns:ns2="urn:ec...Error: XML Parse (12): attribute name expected at Line:1 and Column:23 at value <env:Envelopexmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header/><env:Body><ns2:checkVatResponsexmlns:ns2="urn:ec...
