REX Number Validation SOAP API Europa Website

[stephenleahy]

Hello Alteryx Community,

I’m currently working on retrieving REX number validation from the European Commission’s website: REX Validation, and I need some assistance.

I’ve been following the process outlined in this community post: Verification of VAT Numbers using VIES, and I was able to get a successful response back with the method described.

However, when I try to run a request for the REX validation API via Alteryx, I get an HTTP/1.1 500 Internal Server Error from the service.

What I’ve Done:

• I followed the same configuration steps in the Download Tool as described in the community post.
• I’ve encountered an error in the download data field output.
• Interestingly, I was able to return a valid response through POSTMAN, so the request itself seems to work in that environment.

The Issue:

• When trying to execute the request through Alteryx, I receive the 500 Internal Server Error, even though the same request works in POSTMAN.
• I suspect there might be an issue with the configuration or how Alteryx handles the request, but I’m unsure where things are going wrong.

Has anyone else faced this issue or encountered a similar problem? If so, what steps did you take to work around or resolve it?

Thank you in advance for any help or insights!

[KGT]

I had a look at this and debated whether to comment given that I don't have the solution, but thought it was best to add what I found. I don't have Postman to test.

There is very little info I could find about this as an API (and no sample that I could find). However I did find the wsdl. (And related services here). My initial thought is that the definition for the SOAP body is not verbose enough and the return message is referring to the elements not being complete or wrong format.

My next steps would be to use Postman or SOAPUI to generate a stub from the WSDL. Sorry I couldn't be of more help...

[apathetichell]

uhoh @KGT doesn't have Postman -> and I don't have Alteryx. @stephenleahy -> Switch to your code mode in Postman and look at what you are sending in via Curl/Http -> compare that to what you see in Alteryx in your Soap payload. something you are doing is off.

[stephenleahy]

@KGT Thanks for the reply. @apathetichell

I have attached some screenshots of my Postman CURL and HTTP request. The Alteryx payload is exactly the same. I'm thinking it might be firewall restrictions or proxy settings issue.

Will keep trying

[apathetichell]

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Making-a-SOAP-request-using-do... - can you confirm you have a header configured?

[stephenleahy]

I do indeed