{"id":21825,"date":"2021-06-27T14:07:10","date_gmt":"2021-06-27T14:07:10","guid":{"rendered":"https:\/\/www.erplybooks.com\/?page_id=21825"},"modified":"2023-07-11T09:00:17","modified_gmt":"2023-07-11T09:00:17","slug":"andmeladu","status":"publish","type":"page","link":"https:\/\/www.erplybooks.com\/et\/andmeladu\/","title":{"rendered":"Andmeladu"},"content":{"rendered":"

Andmeladu<\/span><\/h1>\n

 <\/p>\n

ERPLY Books andmeladu saab kasutada API kadu. See v\u00f5imaldab s\u00fcnkroniseerida\u00a0<\/span>andmed oma andmelattu kahel erineval viisil:\u00a0<\/span><\/p>\n

    \n
  1. Aruandegeneraator<\/span><\/li>\n
  2. K\u00fcsida pearaamatu API kaudu<\/span><\/li>\n<\/ol>\n

    Antud juhendis kirjeldame, kuidas andmeladu pearaamatu API-ga kasutada. Aruandegeneraatori API-st ligip\u00e4\u00e4semiseks vaata juhendit siit<\/a>.\u00a0<\/span><\/p>\n

     <\/p>\n

    Pearaamatu API \u00fcldinfo<\/span><\/h3>\n

    Andmelao p\u00e4ring on j\u00e4rgmine:<\/b><\/p>\n

    N\u00e4idis URL:<\/span> https:\/\/api.erplybooks.com\/api\/account_entries\/v2<\/span><\/p>\n

    Request Method:<\/span> GET<\/span><\/p>\n

     <\/p>\n

    Parameetrid:<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    accountId<\/span><\/td>\nString<\/span><\/td>\nKonto id-d. Mitme lisamiseks eralda id-d vertikaalse kriipsuga |<\/span><\/td>\n<\/tr>\n
    customerId<\/span><\/td>\nString<\/span><\/td>\nKliendi\/Hankija id-d. Mitme lisamiseks eralda id-d vertikaalse kriipsuga |<\/span><\/td>\n<\/tr>\n
    dateFrom<\/span><\/td>\nString<\/span><\/td>\nyyyy-MM-dd<\/span><\/td>\n<\/tr>\n
    dateTo<\/span><\/td>\nString<\/span><\/td>\nyyyy-MM-dd<\/span><\/td>\n<\/tr>\n
    projectId<\/span><\/td>\nString<\/span><\/td>\nDimensiooni id-d. Mitme lisamiseks eralda id-d vertikaalse kriipsuga |<\/span><\/td>\n<\/tr>\n
    taxRateId<\/span><\/td>\nlong<\/span><\/td>\nK\u00e4ibemaksu id<\/span><\/td>\n<\/tr>\n
    typeCode<\/span><\/td>\nString<\/span><\/td>\nKande t\u00fc\u00fcp<\/span><\/td>\n<\/tr>\n
    idMoreThan<\/span><\/td>\nlong<\/span><\/td>\nAnna k\u00f5ik uued kanded alates sellest v\u00e4\u00e4rtusest<\/span><\/td>\n<\/tr>\n
    deletedIdMoreThan<\/span><\/td>\nlong<\/span><\/td>\nAnna k\u00f5ik kustutatud kanded alates sellest v\u00e4\u00e4rtusest<\/span><\/td>\n<\/tr>\n
    changedSince<\/span><\/td>\nlong<\/span><\/td>\nMillisekundid alates millest n\u00e4ita muudatusi<\/span><\/td>\n<\/tr>\n
    getProjectGroupMap<\/span><\/td>\nboolean<\/span><\/td>\nKui see on true, siis n\u00e4itab projektigruppe eraldi key-value paaridena<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

     <\/p>\n

    Struktuur:\u00a0<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    long<\/span><\/td>\nid<\/span><\/td>\nkanderea id<\/span><\/td>\n<\/td>\n<\/tr>\n
    long<\/span><\/td>\naccountId<\/span><\/td>\nkanderea konto id<\/span><\/td>\n<\/td>\n<\/tr>\n
    long<\/span><\/td>\ntransactionEntryId<\/span><\/td>\nn\u00e4itab millises kandes see kande rida on<\/span><\/td>\n<\/td>\n<\/tr>\n
    String<\/span><\/td>\naccountNumber<\/span><\/td>\nkonto number<\/span><\/td>\n<\/td>\n<\/tr>\n
    String<\/span><\/td>\ndescription<\/span><\/td>\nkanderea kirjeldus<\/span><\/td>\n<\/td>\n<\/tr>\n
    Date<\/span><\/td>\nopDate<\/span><\/td>\nkanderea kuup\u00e4ev<\/span><\/td>\nyyyy-MM-dd<\/span><\/td>\n<\/tr>\n
    Decimal<\/span><\/td>\ninitialBalance<\/span><\/td>\nalgsaldo<\/span><\/td>\n<\/td>\n<\/tr>\n
    Decimal<\/span><\/td>\ndebitSum<\/span><\/td>\ndeebit summa<\/span><\/td>\n<\/td>\n<\/tr>\n
    Decimal<\/span><\/td>\ncreditSum<\/span><\/td>\nkreedit summa<\/span><\/td>\n<\/td>\n<\/tr>\n
    Decimal<\/span><\/td>\nclosingBalance<\/span><\/td>\nl\u00f5ppsaldo<\/span><\/td>\n<\/td>\n<\/tr>\n
    String<\/span><\/td>\ntypeCode<\/span><\/td>\nkande t\u00fc\u00fcp<\/span><\/td>\nKui tahad t\u00e4psemalt n\u00e4ha, kus nad on defineeritud, siis saab seda eraldi vaadata API dictionary all siin<\/a>\u00a0<\/span><\/td>\n<\/tr>\n
    String<\/span><\/td>\ncode<\/span><\/td>\nkande kood<\/span><\/td>\n<\/td>\n<\/tr>\n
    List <Long><\/span><\/td>\nprojects<\/span><\/td>\nprojekt<\/span><\/td>\nKuvab k\u00f5ikide dimensioonide id-sid. Vaata projects p\u00e4ringut, kui soovid leida vasted: https:\/\/api.erplybooks.com\/api\/projects<\/span><\/td>\n<\/tr>\n
    long<\/span><\/td>\nprojectId<\/span><\/td>\nprojekti id<\/span><\/td>\nEsimene dimensioon. Kui on mitu, siis seda v\u00e4lja tuleks eirata<\/span><\/td>\n<\/tr>\n
    String<\/span><\/td>\ntransactionDescription<\/span><\/td>\nkande kirjeldus<\/span><\/td>\n<\/td>\n<\/tr>\n
    String<\/span><\/td>\nprojectName<\/span><\/td>\nprojekti nimi<\/span><\/td>\n<\/td>\n<\/tr>\n
    String<\/span><\/td>\ncontactName<\/span><\/td>\nkontakti nimi<\/span><\/td>\n<\/td>\n<\/tr>\n
    String<\/span><\/td>\ndocumentNumber<\/span><\/td>\ndokumendi number<\/span><\/td>\n<\/td>\n<\/tr>\n
    long<\/span><\/td>\ndocumentId<\/span><\/td>\ndokumendi id<\/span><\/td>\n<\/td>\n<\/tr>\n
    long<\/span><\/td>\ncontactId<\/span><\/td>\nkontakti id<\/span><\/td>\n<\/td>\n<\/tr>\n
    long<\/span><\/td>\npaymentId<\/span><\/td>\nmaksmise id<\/span><\/td>\n<\/td>\n<\/tr>\n
    long<\/span><\/td>\ntaxRateId<\/span><\/td>\nkm liigi id<\/span><\/td>\n<\/td>\n<\/tr>\n
    List<Key-Value><\/span><\/td>\nprojectGroups<\/span><\/td>\nprojektigrupp<\/span><\/td>\nList<Map.Entry<String, String>> – key-value paarid projektigruppidest, kus key=projektigrupp ja value=projekti nimi<\/span><\/p>\n

    NB!<\/strong> Seda n\u00e4idatakse ainult siis, kui on kaasas p\u00e4ringu parameeter: <\/span>getProjectGroupMap=true<\/b><\/td>\n<\/tr>\n

    long<\/span><\/td>\ndeletedAccountEntryId<\/span><\/td>\nkustutatud kande id<\/span><\/td>\nKustutatud pearaamatu kandeid saab k\u00e4tte, kui teha eraldi p\u00e4ring eraldi andmebaasi<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

     <\/p>\n

    Pearaamatu API-t saab kasutada kolme erinevat moodi:\u00a0<\/span><\/p>\n