Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

API_Connection to the checker of VAT numbers in Slovakia

Kingazawora
7 - Meteor

Hello

 

I am referring to design of the similar solution to this one:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Verification-VAT-numbers-VIES-website/...

 

The website for Slovakia is:

Detail - PFS (financnasprava.sk)

 

When I enter information here:

Kingazawora_1-1673980176564.png

 

I am receiving information like this:

 

Kingazawora_2-1673980214584.png

 

How could I get the information provided by the Slovakian Tax Administration with Alteryx?

 

12 REPLIES 12
Kingazawora
7 - Meteor

I attach workflow that I have started

Kingazawora
7 - Meteor

@DavidSta - Could you help out here?

DavidSta
Alteryx
Alteryx

Hi @Kingazawora,

 

it seems like the website is not that easy to decode.

I don't get how to come from the query to the result page. The next "issue" would be the pagination you need to implement.

 

I think it might be easier to use the OpenData download

https://opendata.financnasprava.sk/en/opendata/show/zoznam-danovych-subjektov-registrovanych-pre-dph...

 

Please see attached a sample Workflow downloading the most recent information.

 

Best regards,

David

Kingazawora
7 - Meteor

Thanks for that!

Kingazawora
7 - Meteor

Hi

When I want to set up the process on a server, the zip file dies not want to save. Is there a way to have this fixed or this is general server error?

Thanks, Kinga

DavidSta
Alteryx
Alteryx

Hi @Kingazawora,

 

for me it is working fine on the Server. Which message do you get? During upload validation or execution?

Kingazawora
7 - Meteor

Hi

 

I am getting following message during execution:

 

Kingazawora_0-1674643077863.png

 

Kingazawora_1-1674643727106.png

 

 

Please note:

-server that our company is using can only sale workflows from 2020.4 version of alteryx

-when I run on my desktop, all is fine

-the file that is being saved should have the side as the one initially downloaded and instead, saves as 17kb so very small size

Kingazawora
7 - Meteor

Kingazawora_0-1674643765484.png

 

DavidSta
Alteryx
Alteryx

I am a little bit confused about the file path your server is complaining about.

In the sample workflow I shared a temporary file is used to process the download. Have you specified a filename/path to store the downloaded file? Which modifications have you done to the workflow? Can you share it?

Labels