curl --request GET \
--url https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance \
--header 'Authorization: Bearer <token>'import requests
url = "https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"book": {
"type": "<string>",
"id": "<string>"
},
"from": "2023-12-25",
"to": "2023-12-25",
"rows": [
{
"account_id": "<string>",
"code": "<string>",
"name": "<string>",
"class": "<string>",
"": [
"<unknown>"
]
}
],
"totals": {},
"currency_code": "<string>",
"currency_exponent": 123
}{
"message": "<string>"
}{
"message": "<string>",
"errors": {}
}View trial balance (organization)
Shows the trial balance of one book over a period (organization space).
curl --request GET \
--url https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance \
--header 'Authorization: Bearer <token>'import requests
url = "https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/trial-balance")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"book": {
"type": "<string>",
"id": "<string>"
},
"from": "2023-12-25",
"to": "2023-12-25",
"rows": [
{
"account_id": "<string>",
"code": "<string>",
"name": "<string>",
"class": "<string>",
"": [
"<unknown>"
]
}
],
"totals": {},
"currency_code": "<string>",
"currency_exponent": 123
}{
"message": "<string>"
}{
"message": "<string>",
"errors": {}
}journal_entries.viewreports
Conditions
- The accounting module must be part of the organization’s plan.
- In the organization space, the caller needs an accounting access grant on the book.
- At least one of fiscal_year_id or fiscal_period_id must be sent; a from/to range alone is refused with a validation error.
- to must be on or after from.
Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Path Parameters
Identifier of the book the report covers (27-character KSUID string): the organization itself or one of its companies of the session organization.
Query Parameters
Identifier of a fiscal year of this book (27-character KSUID string). At least one of fiscal_year_id or fiscal_period_id is required (a from/to range alone is refused). A from/to pair sent with a year takes precedence over the year.
Identifier of a fiscal period of this book (27-character KSUID string). Takes precedence over the fiscal year and over from/to.
Start of the range, a date in ISO 8601 format. Used together with to; a range given alone is ignored.
End of the range, a date in ISO 8601 format, on or after from. Used together with from.
Response
The book the report covers. In the client space it is the session client's book; in the organization space it is the book named in the URL.
Show child attributes
Show child attributes
Start date of the window actually used, in ISO 8601 date format. It is the start of the requested period, the requested from, or the start of the requested fiscal year.
End date of the window actually used, in ISO 8601 date format.
One row per account that has an opening balance or a movement, ordered by account code. Each row has account_id, code, name, class (first digit of the code) and the six columns opening_debit, opening_credit, period_debit, period_credit, closing_debit and closing_credit. Amounts are in minor units of currency_code (divide by 10 to the power currency_exponent).
Show child attributes
Show child attributes
Sum of each of the six columns over all rows, in minor units of currency_code. Debit and credit totals agree for a balanced book.
ISO 4217 code of the currency of every amount in the report.
Number of decimal places of the currency (0 for XOF). An amount in minor units divided by 10 to this power gives the amount in the currency.