VAT - VIES API link

Hi All,

In need of your tecchy brains...I am not sure where to start or how to link an API to a flow - but basically i have a list (attached) of VAT numbers and country codes and I need to create a workflow that spits out an output with the correct VAT and if possible to say whether is incorrect/correct.

hope this makes sense

link to the API needed

https://www.programmableweb.com/api/vies-vat-rpc-api

VAT to check .xlsx

Data Investigation

Accepted answers

apathetichell

So good news & bad news... Good news - I found this thread and built the attached workflow. Bad news - running 4,000 entries is going to take a LONG time...

Vat Check.yxmd

apathetichell

Tool 10 (input data) includes your file. The resource/endpoint base is appended to each of those records and an endpoint is generated to feed into the download tool. The sample controls how many records/requests you feed into the download tool at one time.

All comments

Luke_C

I don't see any API info in the attachment, each API is a little different but the below article might be helpful:

https://community.alteryx.com/t5/Engine-Works/APIs-for-Beginners-Integrate-All-the-Systems/ba-p/807437

apathetichell

So good news & bad news... Good news - I found this thread and built the attached workflow. Bad news - running 4,000 entries is going to take a LONG time...

Vat Check.yxmd

Metadata21

hi its

https://www.programmableweb.com/api/vies-vat-rpc-api

Metadata21

Hi @apathetichell thank you so much! Will I need to change the country and supply an example VAT and then run it for each country through the input below?

apathetichell

Metadata21

@apathetichell Sorry its me again - how do I resolve this error?

apathetichell

Sorry - not sure - is that a specific record/entity? is there a null or improperly created endpoint somewhere? basically one record is creating an issue and you may need to dig into why.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703