VAT ID_Poland API check

[Kingazawora]

Hello

I am looking for a solution on how to check Polish VAT ID numbers on the website that has been available by Polish Tax Administration: https://www.podatki.gov.pl/wykaz-podatnikow-vat-wyszukiwarka

The aim is to read whether or not the VAT ID is valis, the name and date of the check.

There are similar checks already implemented by the EU Tax Administrations - so called VIES ID check.

[Kingazawora]

Similarly to checks performed for EU VAT ID validation: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Verification-VAT-numbers-VIES-...

I would like to check VAT ID of Polish Taxpayers via following website: https://www.podatki.gov.pl/wykaz-podatnikow-vat-wyszukiwarka

This should be done via entering VAT ID and I have found following documentation on API: https://wl-api.mf.gov.pl/ 

I have started designing the workflow, however sth does not seem to work.

[BrandonB]

It looks like you can use the API to query this data: https://wl-test.mf.gov.pl/ 

The note here does indicate that there is a rate limit, although you can do this programatically for a set number of entries: https://www.gov.pl/web/kas/api-wykazu-podatnikow-vat 

"API use is limited. Using the "search" method, you can submit 10 queries about a maximum of 30 entities at the same time, while using the "check" method, you can query about 1 entity. Once this limit is exhausted, access to the API is blocked until 0:00."

You would use the download tool in Alteryx to hit one of the endpoints listed in the first link. 

Reviewing your workflow now. 

[apathetichell]

That's a pretty draconian rate limit.

[BrandonB · Accepted solution]

Just built this workflow for you. A couple of things needed tweaked, but also important to note that the testing endpoint doesn't actually return data. Updated to the production endpoint and passed through a real VAT number and its working as expected. Screenshot below and workflow is attached. 

 

[KINGAZAWORATE]

Many thanks! All works as expected!