GET päring (Aruanded)

Allikas: Excellent || Opendoc
Redaktsioon seisuga 6. august 2018, kell 08:39 kasutajalt Tanel (arutelu | kaastöö) (Uus lehekülg: '==GET (for reports)== ===Request=== ===With authorization=== <syntaxhighlight> http://username:password@ipAddress:portNumber/WebGETAPI.hal?company=compNumber&report=reportName </...')
(erin) ←Vanem redaktsioon | Viimane redaktsiooni (erin) | Uuem redaktsioon→ (erin)
Mine navigeerimisribale Mine otsikasti

GET (for reports)

Request

With authorization

http://username:password@ipAddress:portNumber/WebGETAPI.hal?company=compNumber&report=reportName

Required parameters:

  • compNumber is the sequence number of the company in Hansa DB starting from 1
  • reportName is the internal Books report name

Optional parameters (default value will be selected by Books if missing):

  • periodStart in format dd.mm.yyyy
  • periodEnd in format dd.mm.yyyy

Example:

http://testuser:testpassword@localhost:8989/WebGETAPI.hal?company=1&report=MainRn

Report "Kannete arv perioodis"

Report name = TransNumberRn

Available parameters:

  • compNumber -  the sequence number of the company in Hansa DB starting from 1
  • periodStart – Perioodi algus (format dd.mm.yyyy)
  • periodEnd- Perioodi lõpp format (dd.mm.yyyy)
  • allComp
    • Value “0” or not presented returns only company specified in parameter compNumber.
    • Value “1” returns all companies
  • byEmpl
    • Value “0” or not presented returns numbers for all employees.
    • Value “1” returns numbers by employee.
  • byTRDate
    • Value “0” or not presented returns numbers based on date of registration.
    • Value “1” returns numbers by Transaction date.
    • If invoice is inserted on 15.04.2018 and invoice date is 28.02.2018, then “0” tracks it in april, “1” in february.

Sample query for UKU:

https://api:api@s001.excellent.ee:6443/WebGETAPI.hal?company=1&report=TransNumberRn&periodStart=01.03.2018&periodEnd=31.03.2018&allComp=1&byEmpl=0

Response body format

*In HTML format*