Http Validation tax number

[lreinhard7]

Hi, I would like to validate tax numbers with the help of flow throug the following website: http://ec.europa.eu/taxation_customs/vies/vatRequest.html

I found some technical information and hints on the interactive service here:

http://ec.europa.eu/taxation_customs/vies/technicalInformation.html

http://ec.europa.eu/taxation_customs/vies/checkVatTestService.wsdl

The question is how to configure the http element in flow. 

Would be great if somebody could help. 

Many thanks, 

Ludwig

[v-yamao-msft]

Hi @lreinhard7 ,

Do you want to work with HTTP action in flow?

Please check the following thread on Example Http action:

https://powerusers.microsoft.com/t5/Building-Flows/Example-Http-action/td-p/1105

Further, a blog on how to build nested flows with the HTTP action for your reference:

https://flow.microsoft.com/de-de/blog/build-nested-flows/

Another blog on HTTP post requests using Microsoft Flows:

https://www.cloudfronts.com/http-post-requests-using-microsoft-flows/

Best regards,

Mabel

[Nielf]

@lreinhard7,

Did you come up with a solution? I'm currently exploring if this is possible using Power Automate. 

[lreinhard7 · Accepted solution]

Hi Nielf, 

That's what I finally found out:

Validate VAT Numbers | Dynamics 365FO/AX Finance & Controlling (dynamicsax-fico.com)

Hope this helps. 

Cheers, 
Ludwig

[Nielf]

Thanks @lreinhard7 - much appreciated. You should mark your reply aove as the answer. That will help people coming by this thread in the future. 

[FlorianP]

Thanks @lreinhard7 for your solution. I learned useful things.

I have set up the validation for the VAT numbers as you did.

The flow runs always successfull, but not correct.

In the condition step, the expression result is always false. Whether the compose of the validation result is true or false.

In the screenshots you can one with a valid VAT No. and one that's not valid.

Any ideas?

Thanks in advance for any help

VAT is validVAT not valid

[NielsL]

@FlorianP 

Try adding a compose action after your HTTP action with this expression:

if(equals(first(split(last(split(body('HTTP'),'<valid>')),'</valid>')),'true'),true,false)

 
Then use the output of the compose action in your condition:

[FlorianP]

@NielsL Thanks a lot. That's fixed it.

Except for if(equals(, my compose action was the same.

Would not have thought of using if(equals( 🤔

Learned something again 👨‍🎓

Thanks again for your quick and helpful answer 🙌

[Nielf]

@lreinhard7 Something seems to have changed recently with the VIES API. It's no longer working

The VIES (Independent Publisher) - Connectors is also affected by this. 

Have you found a solution for this? I have tried updating the endpoint to the new URL (http://ec.europa.eu/taxation_customs/vies/checkVatTestService.wsdl). However, I keep getting errors no matter what I try.

[NielsL]

It's working for me again using the original URI (without the 'Test' part). 

However, I had to add some headers in the HTTP request for it to work this time around. Otherwise it keeps timing out. It seems the API is really slow. It takes me up to 18 seconds to get a response. 

[FlorianP]

Thank you very much for your solution!

Works for me again too 😀

[123213123]

hello, can you share the flow details with me? I am trying to build a similar flow.

[Nielf]

@123213123 I think the most straightforward solution is to use the VIES (Independent Publisher) connector by Tomasz Poszytek. 

[123213123]

how much does this premium plug-in cost?

[Anonymous]

Niels can you share the details of your flow?

[singhal1998]

Hi Nielsl,

which expression is you using outputs of compose vat validity is equal to ? for what expression is using for true