Connection with Romanian Tax Administration website for local VAT number validation

[Kingazawora]

Hello

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

I would like to have the same connection to the Romanian VAT check:

https://www.anaf.ro/RegistruTVA/

How this could be done?

Thanks, Kinga

[ArnaldoSandoval]

Hi @Kingazawora 

The Romanian VAT check you posted took me to an interactive page, shown below:

Which is good to verify VAT number manually, what you need is to find their REST APIs, so I googled for "ANAF API" getting a lot of results 🙂 most of them written in Rumanian 😮 this is the first time I see written rumanian 🙂

One of the pages returned by the Google search took me here:

WEB Services - ANAF  and this is its rendered page:

There are some technical information found on this link Technical information , eventually, there are some changes for you to research; what you are looking for is the HTTPS command to retrieve the information you need, like the POST and GET described in this PDF files Cerviciile e-Transport here I reached language limitation.

Once you identify the HTTPS command you have to use, probably you need to request to the ANAF Web Site some access code to consume their API Services (this is standard for any API Services, but it is better done by your company IT or accounting team), once you get the access code, "probably" they will provide some test environment for you to test that the access code is working.

Once you clarify these technical details, your workflow  will implement the "Download" tool found at the "Developer" category, but we will worry about this once you resolve the tecnical details about the API Service to use, and its access code, try to speak with the ANAF support team for guideance.

Hope this helps,

Arnaldo

[ArnaldoSandoval]

@Kingazawora 

Also visit this GitHub page as it contains relevant information for your requirement: ANAF PHP the DOCS links here contains some HTTPS command I mentioned in my previous reply,

hth

Arnaldo

[Kingazawora]

Hi again

I am following on this topic - I have found API documentation on the topic: https://static.anaf.ro/static/10/Anaf/Informatii_R/Servicii_web/doc_WS_V7.txt 

The above indicates following requirements to be fulfilled to connect via API:

Web Service URL (POST): 

https://webservicesp.anaf.ro/PlatitorTvaRest/api/v7/ws/tva


            Request-ul trebuie sa fie trimis prin POST iar formatul este similar cu exemplul de mai jos:

Post Body: 
			[
				{
		    		"cui": _Numar_, "data":"_Data interogarii_"	    
				},
				{
			    	"cui": _Numar_, "data":"_Data interogarii_"	    
				}		
			]

unde ”Data interogarii” este data pentru care se efectuează căutarea.

There is also an example given for the case.

I have tried to build connection workflow to get VAT data of taxpayer, however sth does not seem to work. I attach workflow.

[Kingazawora]

@BrandonB  - could you have a look at the wokflow?

[BrandonB · Accepted solution]

@Kingazawora that's because it is expecting a JSON format payload based on the information you provided in the URL. I have modified the workflow to correctly format the payload and execute an API call. Workflow is attached and image is below:

 

[Kingazawora]

Many thanks!