Unanswered

Http Validation tax number

(0) Share

Report

Posted on by Ludwig Reinhard

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

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (1)

v-yamao-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
NielsSL on at

Like (0)

Report

@lreinhard7,

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

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard on at

Like (1)

Report

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

Was this reply helpful? Yes No
NielsSL on at

Like (1)

Report

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

Was this reply helpful? Yes No
Florian P. 12 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Nielf 306 on at

Like (1)

Report
@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:

Was this reply helpful? Yes No
Florian P. 12 on at

Like (1)

Report

@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 🙌

Was this reply helpful? Yes No
NielsSL on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Nielf 306 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Florian P. 12 on at

Like (1)

Report

Thank you very much for your solution!

Works for me again too 😀

Was this reply helpful? Yes No