Use Alteryx to Check VAT# on UK VAT Site

[zqlcancer]

Hi

I used a marco shared by David through below link to check VAT number on UK VAT site. It has been working correctly for several months but I have had issues since last week as this marco now returns no data.

I am attaching the original marco shared in that link again. Can anyone help to try at their end and let me know if it still works?

Post Brexit UK VAT ID Validation - Page 2 - Alteryx Community

[davidskaife · Accepted solution]

Yes, purely to test that it's not Alteryx being the issue. I suggest something like Postman (which is free)

[zqlcancer]

Thanks for sharing. My company policy does not allow us to use unauthorized software. Let me try to grant production credentials and try if it works in production system.

[JasperLeonson]

Thanks @DavidSkaife and @zqlcancer! I got my Client ID/Secret and was able to generate the access token using Postman. Now trying to update the Alteryx macro to fetch VAT data using the token. If anyone has a quick example for doing both steps in one workflow, that’d help a lot!

 Thank You....

[zqlcancer]

@JasperLeonson ，perhaps you can use my workflow at first to see if you can receive a get request. Please add you own token in formula tool for column 'Authorization'. Back in April I failed to receive anything from HMRC.