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! Rex Number Verify SOAP API.yxmd

REX Number Validation SOAP API Europa Website

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!

Rex Number Verify SOAP API.yxmd

API

Interface Tools

Accepted answers

All comments

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

POSTMAN_CURL_REQUEST.PNG

POSTMAN_HTTP_REQUEST.PNG

ALTERYX_SOAP_PAYLOAD.PNG

apathetichell

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

stephenleahy

I do indeed

header.PNG

stephenleahy

Hello, just an update on this issue. I finally got somewhere with the Postman response. Using the attached Post-response, it gave me only the data I needed in an easy to read format, which I then exported from the Postman console into Excel. Then I could input into Alteryx and go from there. Still far from perfect, but will keep trying with the API tool.

Thank you all for your input. Much appreciated

POSTMAN_RESPONSE.PNG

Post-response.txt

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

hhaigh1 280