Query Accounting Data

curl --request GET \
  --url https://api.jtl-cloud.com/erp/accountingData \
  --header 'Authorization: Bearer <token>' \
  --header 'x-tenant-id: <x-tenant-id>'

import requests

url = "https://api.jtl-cloud.com/erp/accountingData"

headers = {
    "x-tenant-id": "<x-tenant-id>",
    "Authorization": "Bearer <token>"
}

response = requests.get(url, headers=headers)

print(response.text)

const options = {
  method: 'GET',
  headers: {'x-tenant-id': '<x-tenant-id>', Authorization: 'Bearer <token>'}
};

fetch('https://api.jtl-cloud.com/erp/accountingData', 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.jtl-cloud.com/erp/accountingData",
  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>",
    "x-tenant-id: <x-tenant-id>"
  ],
]);

$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.jtl-cloud.com/erp/accountingData"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("x-tenant-id", "<x-tenant-id>")
	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.jtl-cloud.com/erp/accountingData")
  .header("x-tenant-id", "<x-tenant-id>")
  .header("Authorization", "Bearer <token>")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.jtl-cloud.com/erp/accountingData")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["x-tenant-id"] = '<x-tenant-id>'
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

{
  "TotalItems": 123,
  "PageNumber": 123,
  "PageSize": 123,
  "Items": [
    {
      "DocumentNumber": "<string>",
      "DocumentId": 123,
      "DocumentDate": "2023-11-07T05:31:56Z",
      "SalesOrderNumber": "<string>",
      "SalesOrderId": 123,
      "ExternalSalesOrderNumber": "<string>",
      "DepartureCountry": {
        "CountryISO": "<string>",
        "StateISO": "<string>"
      },
      "ShipmentCountry": {
        "CountryISO": "<string>",
        "StateISO": "<string>"
      },
      "BillingAddress": {
        "Id": 123,
        "Company": "<string>",
        "Company2": "<string>",
        "FormOfAddress": "<string>",
        "Title": "<string>",
        "FirstName": "<string>",
        "LastName": "<string>",
        "Street": "<string>",
        "Address2": "<string>",
        "PostalCode": "<string>",
        "City": "<string>",
        "State": "<string>",
        "CountryIso": "<string>",
        "VatID": "<string>",
        "PhoneNumber": "<string>",
        "MobilePhoneNumber": "<string>",
        "EmailAddress": "<string>",
        "Fax": "<string>"
      },
      "ShipmentAddress": {
        "Id": 123,
        "Company": "<string>",
        "Company2": "<string>",
        "FormOfAddress": "<string>",
        "Title": "<string>",
        "FirstName": "<string>",
        "LastName": "<string>",
        "Street": "<string>",
        "Address2": "<string>",
        "PostalCode": "<string>",
        "City": "<string>",
        "State": "<string>",
        "CountryIso": "<string>",
        "VatID": "<string>",
        "PhoneNumber": "<string>",
        "MobilePhoneNumber": "<string>",
        "EmailAddress": "<string>",
        "Fax": "<string>"
      },
      "CurrencyIso": "<string>",
      "CompanyId": 123,
      "CompanyVatId": "<string>",
      "CustomerVatId": "<string>",
      "SalesChannelId": "<string>",
      "IsCancelled": true,
      "AccountDataLineItems": [
        {
          "ItemId": 123,
          "Name": "<string>",
          "TaxClassId": 123,
          "GeneralLedgerAccount": "<string>",
          "Quantity": 123,
          "VatRate": 123,
          "VatAmount": 123,
          "TotalDiscountGrossAmount": 123,
          "TotalDiscountNetAmount": 123,
          "TotalGrossAmount": 123,
          "TotalNetAmount": 123,
          "SortOrder": 123
        }
      ]
    }
  ],
  "TotalPages": 123,
  "HasPreviousPage": true,
  "HasNextPage": true,
  "NextPageNumber": 123,
  "PreviousPageNumber": 123
}

{
  "ErrorCode": "<string>",
  "ValidationErrors": {},
  "Errors": {},
  "ErrorMessage": "<string>",
  "Stacktrace": "<string>"
}

GET

accountingData

Query Accounting Data

curl --request GET \
  --url https://api.jtl-cloud.com/erp/accountingData \
  --header 'Authorization: Bearer <token>' \
  --header 'x-tenant-id: <x-tenant-id>'

import requests

url = "https://api.jtl-cloud.com/erp/accountingData"

headers = {
    "x-tenant-id": "<x-tenant-id>",
    "Authorization": "Bearer <token>"
}

response = requests.get(url, headers=headers)

print(response.text)

const options = {
  method: 'GET',
  headers: {'x-tenant-id': '<x-tenant-id>', Authorization: 'Bearer <token>'}
};

fetch('https://api.jtl-cloud.com/erp/accountingData', 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.jtl-cloud.com/erp/accountingData",
  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>",
    "x-tenant-id: <x-tenant-id>"
  ],
]);

$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.jtl-cloud.com/erp/accountingData"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("x-tenant-id", "<x-tenant-id>")
	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.jtl-cloud.com/erp/accountingData")
  .header("x-tenant-id", "<x-tenant-id>")
  .header("Authorization", "Bearer <token>")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.jtl-cloud.com/erp/accountingData")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["x-tenant-id"] = '<x-tenant-id>'
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

{
  "TotalItems": 123,
  "PageNumber": 123,
  "PageSize": 123,
  "Items": [
    {
      "DocumentNumber": "<string>",
      "DocumentId": 123,
      "DocumentDate": "2023-11-07T05:31:56Z",
      "SalesOrderNumber": "<string>",
      "SalesOrderId": 123,
      "ExternalSalesOrderNumber": "<string>",
      "DepartureCountry": {
        "CountryISO": "<string>",
        "StateISO": "<string>"
      },
      "ShipmentCountry": {
        "CountryISO": "<string>",
        "StateISO": "<string>"
      },
      "BillingAddress": {
        "Id": 123,
        "Company": "<string>",
        "Company2": "<string>",
        "FormOfAddress": "<string>",
        "Title": "<string>",
        "FirstName": "<string>",
        "LastName": "<string>",
        "Street": "<string>",
        "Address2": "<string>",
        "PostalCode": "<string>",
        "City": "<string>",
        "State": "<string>",
        "CountryIso": "<string>",
        "VatID": "<string>",
        "PhoneNumber": "<string>",
        "MobilePhoneNumber": "<string>",
        "EmailAddress": "<string>",
        "Fax": "<string>"
      },
      "ShipmentAddress": {
        "Id": 123,
        "Company": "<string>",
        "Company2": "<string>",
        "FormOfAddress": "<string>",
        "Title": "<string>",
        "FirstName": "<string>",
        "LastName": "<string>",
        "Street": "<string>",
        "Address2": "<string>",
        "PostalCode": "<string>",
        "City": "<string>",
        "State": "<string>",
        "CountryIso": "<string>",
        "VatID": "<string>",
        "PhoneNumber": "<string>",
        "MobilePhoneNumber": "<string>",
        "EmailAddress": "<string>",
        "Fax": "<string>"
      },
      "CurrencyIso": "<string>",
      "CompanyId": 123,
      "CompanyVatId": "<string>",
      "CustomerVatId": "<string>",
      "SalesChannelId": "<string>",
      "IsCancelled": true,
      "AccountDataLineItems": [
        {
          "ItemId": 123,
          "Name": "<string>",
          "TaxClassId": 123,
          "GeneralLedgerAccount": "<string>",
          "Quantity": 123,
          "VatRate": 123,
          "VatAmount": 123,
          "TotalDiscountGrossAmount": 123,
          "TotalDiscountNetAmount": 123,
          "TotalGrossAmount": 123,
          "TotalNetAmount": 123,
          "SortOrder": 123
        }
      ]
    }
  ],
  "TotalPages": 123,
  "HasPreviousPage": true,
  "HasNextPage": true,
  "NextPageNumber": 123,
  "PreviousPageNumber": 123
}

{
  "ErrorCode": "<string>",
  "ValidationErrors": {},
  "Errors": {},
  "ErrorMessage": "<string>",
  "Stacktrace": "<string>"
}

Authorizations

Authorization

string

header

required

The access token received from the authorization server in the OAuth 2.0 flow.

Headers

x-companyid

string

The Company-Id (int or uuid) of the company on whose behalf the request is executed.

x-tenant-id

string<uuid>

required

The tenant ID for the target ERP instance.

Query Parameters

from

string<date-time>

Filters documents starting from a specific date and time

string<date-time>

Filters documents up to a specific date and time

companyId

integer<int32>

Gets the unique identifier for the firm. Represents a key for identifying a firm within the application.

type

enum<integer>

Specifies the type of document. 0 = Invoice, 1 = Credit, 2 = Invoice correction, 3 = Invoice cancellation, 4 = credit cancellation, 5 = invoice correction cancellation 0 = Invoice, 1 = Credit, 2 = InvoiceCorrection, 3 = InvoiceCancellation, 4 = CreditCancellation, 5 = InvoiceCorrectionCancellation, 6 = Liquidation, 7 = LiquidationCancellation

Available options:

0,

1,

2,

3,

4,

5,

6,

7

exportCurrencyInDepartureCountry

boolean

If true, exports total sums in the currency of the departure country

pageNumber

integer<int32>

Number of the page of items to fetch.

pageSize

integer<int32>

Size of the page that is specified by pageNumber.

Response

Provides a detailed overview of all non-pending sales orders, including invoices, credits, invoice corrections, invoice cancellations, credit cancellations, and invoice correction cancellations, along with their associated line items

Represents a paginated list of items

TotalItems

integer<int32>

required

Gets or sets the total number of items available in the data source.

PageNumber

integer<int32>

required

Gets or sets the current page number in the paginated list.

PageSize

integer<int32>

required

Gets or sets the number of items per page in the paginated list.

Items

object[]

required

Gets or sets the collection of items contained in the paged list.

Show child attributes

TotalPages

integer<int32>

Gets the total number of pages based on the total number of items and the page size.

HasPreviousPage

boolean

Gets a value indicating whether there is a previous page available in the paginated list.

HasNextPage

boolean

Gets a value indicating whether there is a next page available.

NextPageNumber

integer<int32>

Gets the number of the next page if there is one; otherwise, returns the total number of pages.

PreviousPageNumber

integer<int32>

Gets the number of the previous page. If there is no previous page, it returns 1.

ERP (JTL-Wawi)Query Accounting Data

⌘I

Overview

REST API

Query Accounting Data

Authorizations

Headers

Query Parameters

Response