Verification VAT numbers VIES website

[speedway]

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.

[mahadevaswab]

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

[DavidSta]

I can heavily recommend to take a look to this Post. This explains how to create a API call against a SOAP Interface.

[VenkateshMS]

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?

[mahadevaswab]

Yes even We are getting the same issue @VenkateshMS @DavidSta  please let us know if any alternative way to fix this.

and the below is what we get from SOAP API tool and used in Alteryx

'<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:ec.europa.eu:taxud:vies:services:checkVat:types">
<soapenv:Header/>
<soapenv:Body>
<urn:checkVat>
<urn:countryCode>'+[Customer Country Code]+'</urn:countryCode>
<urn:vatNumber>'+[VAT number]+'</urn:vatNumber>
</urn:checkVat>
</soapenv:Body>
</soapenv:Envelope>'

[Kingazawora]

Do we have any new validation available?

[DavidSta]

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

[taxhead]

Great, this worked for me. Thanks!!

[Kingazawora]

Could someone update above? The website is now: https://ec.europa.eu/taxation_customs/vies/#/vat-validation

[DavidSta]

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.

[Kingazawora]

Thanks