We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

VAT - VIES API link

Metadata21
8 - Asteroid

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 

7 REPLIES 7
Luke_C
17 - Castor
17 - Castor

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/8074...

 

apathetichell
20 - Arcturus

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...

Metadata21
8 - Asteroid
Metadata21
8 - Asteroid

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?

 

Metadata21_0-1668082689918.png

 

apathetichell
20 - Arcturus

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.

Metadata21
8 - Asteroid

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

 

Metadata21_0-1670864271994.png

 

apathetichell
20 - Arcturus

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.

Labels
Top Solution Authors