Use Alteryx to Check VAT# on UK VAT Site

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

UK VAT Check.yxzp

Help

Accepted answers

davidskaife

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

All comments

davidskaife

Hi @zqlcancer

This link may shed some light on it, HMRC have depreciated version 1 of the VAT Check API on the 17th Feb and you now need to register and go via authentication - https://developer.service.hmrc.gov.uk/api-documentation/docs/api/service/vat-registered-companies-api/2.0

zqlcancer

Thanks for sharing, I just noticed that. But it is strange that one of my colleague said she can still use it.

zqlcancer

OK，I have successfully registered and get my Client ID and Client Secret number. But I am not quite sure where to put these information.

@DavidSta , is it ok for you to advise how to change your old workflow to compliance with new API change of UK VAT Verification site?

davidskaife

Hi @zqlcancer

Having a read through the HMRC documentation there is a lot of guidance on what you need to do - looks like you need to use the Sandbox version first before they allow access..

Looking at it a brief overview of what you'll need to do is this:

use your Client ID and Secret to make an API call to obtain the Access Token
use the Access Token to make an API call to obtain the VAT info
do this in one workflow, which means that each time you run it you will generate a new Access Token

There is a really good article on obtaining an access token here - https://www.thedataschool.co.uk/erlina-cahyadi/retrieving-an-access-token-through-oauth-on-alteryx/

This article then explains how to use the token to access the data - https://www.thedataschool.co.uk/erlina-cahyadi/getting-api-authorization-with-basic-authentication-on-alteryx/

zqlcancer

@davidskaife

I followed HMRC API documentation and successfully receive an access token in sandbox environment. But when I tried to use this access token to issue a Get request, I received an error message saying “{"code": "RESOURCE_FORBIDDEN", "message": "The application is not subscribed to the API which it is attempting to invoke"}”.

Could you please help to check my attached workflow and let me know what I did wrong? Please be noted I include fake access token in the sample just for reference.

access token.jpg

Access Token.yxmd

zqlcancer

@davidskaife

The pic you used should refer to the first step "Request an OAuth 2.0 access token with the required scope", I did it and received the access token which I used in step 2 "Issue a GET request".

Do you suggest me combine all 2 steps in 1 workflow? If this is the case, I have done so but received same error message. If your guess is that the issue is on HMRC end perhaps I can apply for production credential key and try in production environment.

davidskaife

Hi @zqlcancer

I'd suggest trying the process in another tool first, to make sure its not anything going wrong on your side

zqlcancer

@davidskaife , do you mean to try another tool other than Alteryx?

davidskaife

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

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.

Access Token.yxmd

KINGAZAWORATE

Has anyone develop any holistic solution here?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703