Journal Transactions Report (Detailed)

Production

GET

/api2/reports/journal_transactions

The journal lines of the period, grouped as the report page prints them, with a subtotal per group and a total per currency.

Mirrors /owner/reports/report/journal_transactions?summary=0 (Accounting > Reports > Journal Transactions, Details tab). The Summary tab is the separate journals report.

One row per journal line, grouped by group_by (default Journal Number). Every figure is in the base currency, so there is one currency block. Debit and credit are raw numbers and are not rounded: group subtotals and totals are the sums of the rows, as on the report page. Account codes are strings. Draft journals and hidden accounts are never included.

Not paginated. More than 3000 matching lines is answered 400 rather than truncated; narrow the range with from_date and to_date, or filter by account, source or branch. The refusal carries validation_errors.rows.

Requires the View all journals permission, and an API key must be enabled for machine access.

Request

Authorization

OAuth 2.0

Password

Add the parameter

Authorization

to Headers，whose value is to concatenate the Token after the Bearer.

Example:

Authorization: Bearer ********************

Token URL: https://www.daftra.com/v2/oauth/token

API Key

Add parameter in header

apikey

Example:

apikey: ********************

API Key

Add parameter in cookie

OISystem

Example:

OISystem: ********************

Query Params

Header Params

Responses

🟢200

application/json

The journal lines.

Bodyapplication/json

🟠400Error400

🟠401Error401

🟠403Error403

🟠404Error404

🟠405Error405

🔴500Error500

🔴503Error503

Request Example

Shell

JavaScript

Java

Swift

curl --location '/api2/reports/journal_transactions?from_date=2026-01-01&to_date=2026-01-31&source=&journal_account_id=&show_all_transaction=&cost_center_id=&tags=&tags_match=&branch_id=&work_order_id=&selected_journal_ids=&group_by=' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer ' \
--header 'apikey: ' \
--header 'Content-Type: application/json'

Response Example

200 - Example 1

{
    "result": "successful",
    "code": 200,
    "data": {
        "report": {
            "key": "journal_transactions",
            "title": "string",
            "mode": "journals",
            "group_by": "string",
            "base_currency": "string"
        },
        "filters": {
            "from_date": "2019-08-24",
            "to_date": "2019-08-24",
            "source": "string",
            "journal_account_id": [
                0
            ],
            "show_all_transaction": true,
            "cost_center_id": [
                0
            ],
            "tags": [
                0
            ],
            "tags_match": "string",
            "branch_id": [
                0
            ],
            "work_order_id": 0,
            "selected_journal_ids": [
                0
            ]
        },
        "columns": [
            {
                "key": "string",
                "label": "string"
            }
        ],
        "currencies": [
            {
                "currency": "string",
                "totals": {
                    "debit": 0,
                    "credit": 0
                },
                "groups": [
                    {
                        "key": "string",
                        "account_id": 0,
                        "subtotals": {
                            "debit": 0,
                            "credit": 0
                        },
                        "rows": [
                            {
                                "id": 0,
                                "number": "string",
                                "date": "2019-08-24",
                                "account_id": 0,
                                "account": "string",
                                "account_code": "string",
                                "description": "string",
                                "source": "string",
                                "source_type": "string",
                                "entity_id": 0,
                                "debit": 0,
                                "credit": 0,
                                "is_selected_account": true,
                                "branch": "string",
                                "cost_centers": "string",
                                "tags": "string",
                                "property1": "string",
                                "property2": "string"
                            }
                        ]
                    }
                ]
            }
        ],
        "meta": {
            "currency_count": 0,
            "group_count": 0,
            "row_count": 0
        }
    }
}

Ledger Report

Journals Report