Advertisement
vicos

Descarca datele unui agent economic cu OpenApi

Nov 27th, 2014
358
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Function GeTertOpenApi(tcCodFiscal As String) HelpString "Descarca datele unui tert de pe ANAF fara Captcha"
  2.     lcURL='http://openapi.ro/api/companies/'+tcCodFiscal+'.json'
  3.     *
  4.     loHttp.Open("GET", lcURL, .F.)
  5.     loHttp.Send()
  6.     jsonString=loHttp.ResponseText
  7.     If Not Empty(jsonString)
  8.         *
  9.         Local oTert, jSon
  10.         Set Procedure To qdfoxJSON.prg AddiTive
  11.         JSONStart()
  12.         oTert=JSON.Parse(jsonString)
  13.         Create Cursor Date_Tert CodePage=1250  (Proprietate C (240), Valoare C (240))
  14.         Insert Into Date_Tert(Proprietate, Valoare) Values('Denumire', ReplaceDiacritics(oTert.Name))
  15.         Insert Into Date_Tert(Proprietate, Valoare) Values('Adresa', ReplaceDiacritics(oTert.Address)+[ ]+ReplaceDiacritics(oTert.City) )
  16.         Insert Into Date_Tert(Proprietate, Valoare) Values('Localitate', ReplaceDiacritics(oTert.City))
  17.         Insert Into Date_Tert(Proprietate, Valoare) Values('Judetul', ReplaceDiacritics(oTert.State))
  18.         Insert Into Date_Tert(Proprietate, Valoare) Values('Numar de', oTert.Registration_Id)
  19.         Insert Into Date_Tert(Proprietate, Valoare) Values('Telefon', Nvl(oTert.Phone, ''))
  20.         Insert Into Date_Tert(Proprietate, Valoare) Values('Taxa pe valoarea', iif(oTert.Vat='1', 'DA', 'NU'))
  21.         *
  22.         Return .T.
  23.         *
  24.     Else
  25.         *
  26.         Return .F. 
  27.         *
  28.     EndIf  
  29.     *
  30. EndFunc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement