curl --request GET \
--url https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/auxiliary-balance \
--header 'Authorization: Bearer <token>'import requests
url = "https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/auxiliary-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/auxiliary-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/auxiliary-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/auxiliary-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/auxiliary-balance")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/auxiliary-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>"
},
"auxiliary_type": "<string>",
"from": "2023-12-25",
"to": "2023-12-25",
"groups": "<array>",
"totals": {},
"currency_code": "<string>",
"currency_exponent": 123
}{
"message": "<string>"
}{
"message": "<string>",
"errors": {}
}View third-party balance (organization)
Shows the trial balance restricted to customer or supplier accounts, grouped under their parent account (organization space).
curl --request GET \
--url https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/auxiliary-balance \
--header 'Authorization: Bearer <token>'import requests
url = "https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/auxiliary-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/auxiliary-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/auxiliary-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/auxiliary-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/auxiliary-balance")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.exowpee.com/v1/accounting/organization/books/{book}/reports/auxiliary-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>"
},
"auxiliary_type": "<string>",
"from": "2023-12-25",
"to": "2023-12-25",
"groups": "<array>",
"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.
- auxiliary_type is required and must be customer or vendor.
- 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.
Required. Third-party accounts to report on: customer or vendor.
customer, vendor 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
Which third-party accounts the report covers, as requested: customer or vendor.
Start date of the window actually used, ISO 8601 date format.
End date of the window actually used, ISO 8601 date format.
One block per parent account (the customer or vendor control account), each with parent (account_id, code, name; null for accounts without a parent), rows (one per third-party account, with the six trial-balance columns and auxiliary_id) and subtotals of the six columns.
Sum of the six trial-balance columns over all accounts of the report, in minor units of currency_code (divide by 10 to the power currency_exponent).
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.