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

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
18 - Pollux

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
18 - Pollux

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
18 - Pollux

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