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 |
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:
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"
}
}
