API ressource transactions in an account

GET https://service.runmyaccounts.com/api/{version}/clients/{clientname}/charts/{accno}/transactions

Parameters/filters:

Parameter Description Mandatory Example
accno Filter by account number. You can use character x as wildcard. Ex. 15xx filters all account from 1500 to 1599

x -> all accounts
xxxxx -> all accounts with 5 characters
xxxxxx -> all accounts with 6 characters

Yes 15xx
from_date Include transaction from date (yyyy-MM-dd) 2019-01-01
to_date Include transaction until date (yyyy-MM-dd), default is today 2019-05-31
include_openings Include opening balances to list true
include_closings Include closing balances to list true

Examples

Example without departments:

https://service.runmyaccounts.com/api/latest/clients/apitest/charts/10xx/transactions?api_key=d1bvbxkI8f1bnMBJ4sZiC-xupl4fOEzf

XML:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<transactions number_of_transaction="5">
    <transaction>
        <id>10204</id>
        <chart id="0" accno="1000" link="" allow_gl="false" is_active="true">
            <taxes/>
        </chart>
        <transdate>2015-10-22T00:00:00+02:00</transdate>
        <reference>R-001</reference>
        <description></description>
        <amount>-50.0</amount>
        <module>ar</module>
        <source></source>
        <entry_id>102</entry_id>
        <memo></memo>
        <notes></notes>
        <intnotes></intnotes>
        <department id="10319" name="Entwickliung" role="P"/>
        <accno>1000</accno>
    </transaction>
    <transaction>
        <id>10246</id>
        <chart id="0" accno="1020" link="" allow_gl="false" is_active="true">
            <taxes/>
        </chart>
        <transdate>2017-03-02T00:00:00+01:00</transdate>
        <reference>A1.3</reference>
        <description></description>
        <amount>-106.92</amount>
        <module>ar</module>
        <source></source>
        <entry_id>145</entry_id>
        <memo></memo>
        <notes></notes>
        <intnotes></intnotes>
        <department id="10319" name="Entwickliung" role="P"/>
        <accno>1020</accno>
    </transaction>
    <transaction>
        <id>10247</id>
        <chart id="0" accno="1021" link="" allow_gl="false" is_active="true">
            <taxes/>
        </chart>
        <transdate>2017-03-03T00:00:00+01:00</transdate>
        <reference>A1.4</reference>
        <description></description>
        <amount>-3.58</amount>
        <module>ar</module>
        <source></source>
        <entry_id>159</entry_id>
        <notes></notes>
        <intnotes></intnotes>
        <department id="10321" name="Operations" role="P"/>
        <accno>1021</accno>
    </transaction>
    <transaction>
        <id>10247</id>
        <chart id="0" accno="1021" link="" allow_gl="false" is_active="true">
            <taxes/>
        </chart>
        <transdate>2017-03-03T00:00:00+01:00</transdate>
        <reference>A1.4</reference>
        <description></description>
        <amount>-50.0</amount>
        <module>ar</module>
        <source></source>
        <entry_id>157</entry_id>
        <memo></memo>
        <notes></notes>
        <intnotes></intnotes>
        <department id="10321" name="Operations" role="P"/>
        <accno>1021</accno>
    </transaction>
    <transaction>
        <id>10249</id>
        <chart id="0" accno="1020" link="" allow_gl="false" is_active="true">
            <taxes/>
        </chart>
        <transdate>2017-10-07T00:00:00+02:00</transdate>
        <reference>K-001</reference>
        <description></description>
        <amount>108.0</amount>
        <module>ap</module>
        <source></source>
        <entry_id>167</entry_id>
        <memo></memo>
        <notes></notes>
        <intnotes></intnotes>
        <accno>1020</accno>
    </transaction>
</transactions>

JSON:

{
"transactions": {
"transaction": [
{
"id": "10204",
"chart": {
"taxes": "",
"_id": "0",
"_accno": "1000",
"_link": "",
"_allow_gl": "false",
"_is_active": "true"
},
"transdate": "2015-10-22T00:00:00+02:00",
"reference": "R-001",
"description": "",
"amount": "-50.0",
"module": "ar",
"source": "",
"entry_id": "102",
"memo": "",
"notes": "",
"intnotes": "",
"department": {
"_id": "10319",
"_name": "Entwickliung",
"_role": "P"
},
"accno": "1000"
},
{
"id": "10246",
"chart": {
"taxes": "",
"_id": "0",
"_accno": "1020",
"_link": "",
"_allow_gl": "false",
"_is_active": "true"
},
"transdate": "2017-03-02T00:00:00+01:00",
"reference": "A1.3",
"description": "",
"amount": "-106.92",
"module": "ar",
"source": "",
"entry_id": "145",
"memo": "",
"notes": "",
"intnotes": "",
"department": {
"_id": "10319",
"_name": "Entwickliung",
"_role": "P"
},
"accno": "1020"
},
{
"id": "10247",
"chart": {
"taxes": "",
"_id": "0",
"_accno": "1021",
"_link": "",
"_allow_gl": "false",
"_is_active": "true"
},
"transdate": "2017-03-03T00:00:00+01:00",
"reference": "A1.4",
"description": "",
"amount": "-3.58",
"module": "ar",
"source": "",
"entry_id": "159",
"notes": "",
"intnotes": "",
"department": {
"_id": "10321",
"_name": "Operations",
"_role": "P"
},
"accno": "1021"
},
{
"id": "10247",
"chart": {
"taxes": "",
"_id": "0",
"_accno": "1021",
"_link": "",
"_allow_gl": "false",
"_is_active": "true"
},
"transdate": "2017-03-03T00:00:00+01:00",
"reference": "A1.4",
"description": "",
"amount": "-50.0",
"module": "ar",
"source": "",
"entry_id": "157",
"memo": "",
"notes": "",
"intnotes": "",
"department": {
"_id": "10321",
"_name": "Operations",
"_role": "P"
},
"accno": "1021"
},
{
"id": "10249",
"chart": {
"taxes": "",
"_id": "0",
"_accno": "1020",
"_link": "",
"_allow_gl": "false",
"_is_active": "true"
},
"transdate": "2017-10-07T00:00:00+02:00",
"reference": "K-001",
"description": "",
"amount": "108.0",
"module": "ap",
"source": "",
"entry_id": "167",
"memo": "",
"notes": "",
"intnotes": "",
"accno": "1020"
}
],
"_number_of_transaction": "5"
}
}

 

War dieser Artikel hilfreich?
Dislike 0
Ansichten: 691
Nach oben scrollen