Queries all sales invoices.

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

import requests

url = "https://api.jtl-cloud.com/erp/v2/sales-invoices"

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/v2/sales-invoices', 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/v2/sales-invoices",
  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/v2/sales-invoices"

	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/v2/sales-invoices")
  .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/v2/sales-invoices")

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": [
    {
      "salesInvoiceId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "createdByUserId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "customerId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "currencyIso": "<string>",
      "companyId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "companyName": "<string>",
      "vatIdNumber": "<string>",
      "paymentMethodId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "paymentMethodName": "<string>",
      "isDunningBlocked": true,
      "salesInvoiceDate": "2023-11-07T05:31:56Z",
      "valueDate": "2023-11-07T05:31:56Z",
      "salesInvoiceNumber": "<string>",
      "currencyFactor": 123,
      "shippingMethodId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "shippingMethodName": "<string>",
      "isDraft": true,
      "salesChannelId": "<string>",
      "platformId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "shopId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "languageId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "isIntraCommunityDelivery": true,
      "isExemptFromVat": true,
      "ebayUsername": "<string>",
      "salesChannelName": "<string>",
      "isExternalSalesInvoice": true,
      "printExistingSalesInvoice": true,
      "paymentDate": "2023-11-07T05:31:56Z",
      "printDate": "2023-11-07T05:31:56Z",
      "mailDate": "2023-11-07T05:31:56Z",
      "isDunned": true,
      "stillToPay": 123,
      "alreadyPaidAmount": 123,
      "isCompletelyPaid": true,
      "comment": "<string>",
      "customerComment": "<string>",
      "salesInvoiceCorrectionTotalGrossAmount": 123,
      "hasSalesInvoiceCorrection": true,
      "shipmentAddressCompanyName": "<string>",
      "shipmentAddressSalutation": "<string>",
      "shipmentAddressTitle": "<string>",
      "shipmentAddressFirstName": "<string>",
      "shipmentAddressLastName": "<string>",
      "shipmentAddressStreet": "<string>",
      "shipmentAddressAdditionalAddressLine": "<string>",
      "shipmentAddressPostalCode": "<string>",
      "shipmentAddressCity": "<string>",
      "shipmentAddressCountryName": "<string>",
      "shipmentAddressPhoneNumber": "<string>",
      "shipmentAddressMobilePhoneNumber": "<string>",
      "shipmentAddressFaxNumber": "<string>",
      "shipmentAddressEmailAddress": "<string>",
      "shipmentAddressAdditionalCompanyLine": "<string>",
      "shipmentAddressPostId": "<string>",
      "shipmentAddressState": "<string>",
      "shipmentAddressCountryIso": "<string>",
      "billingAddressCompanyName": "<string>",
      "billingAddressSalutation": "<string>",
      "billingAddressTitle": "<string>",
      "billingAddressFirstName": "<string>",
      "billingAddressLastName": "<string>",
      "billingAddressStreet": "<string>",
      "billingAddressAdditionalAddressLine": "<string>",
      "billingAddressPostalCode": "<string>",
      "billingAddressCity": "<string>",
      "billingAddressCountryName": "<string>",
      "billingAddressPhoneNumber": "<string>",
      "billingAddressMobilePhoneNumber": "<string>",
      "billingAddressFaxNumber": "<string>",
      "billingAddressEmailAddress": "<string>",
      "billingAddressAdditionalCompanyLine": "<string>",
      "billingAddressPostId": "<string>",
      "billingAddressState": "<string>",
      "billingAddressCountryIso": "<string>",
      "totalGrossAmount": 123,
      "shippingCountryTotalGrossAmount": 123,
      "totalNetAmount": 123,
      "shippingCountryTotalNetAmount": 123,
      "createdByUserName": "<string>",
      "customerNumber": "<string>",
      "accountsReceivableNumber": 123,
      "customerGroupName": "<string>",
      "paymentDueDateInDays": 123,
      "paymentDueDate": "2023-11-07T05:31:56Z",
      "dunningLevel": 123,
      "dunningDate": "2023-11-07T05:31:56Z",
      "isArchived": true,
      "processColourCode": 123,
      "processColourName": "<string>",
      "platformType": 123,
      "salesOrderNumber": "<string>",
      "isCorrected": true,
      "isCancelled": true,
      "cancelledDate": "2023-11-07T05:31:56Z",
      "cancellationComment": "<string>",
      "cancellationUserName": "<string>",
      "cancellationReason": "<string>",
      "salesOrderId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "externalSalesOrderNumber": "<string>",
      "serviceDateFrom": "2023-11-07T05:31:56Z",
      "serviceDateTo": "2023-11-07T05:31:56Z",
      "lastShippingDate": "2023-11-07T05:31:56Z"
    }
  ],
  "totalPages": 123,
  "hasPreviousPage": true,
  "hasNextPage": true,
  "nextPageNumber": 123,
  "previousPageNumber": 123
}

GET

sales-invoices

Queries all sales invoices.

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

import requests

url = "https://api.jtl-cloud.com/erp/v2/sales-invoices"

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/v2/sales-invoices', 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/v2/sales-invoices",
  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/v2/sales-invoices"

	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/v2/sales-invoices")
  .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/v2/sales-invoices")

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": [
    {
      "salesInvoiceId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "createdByUserId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "customerId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "currencyIso": "<string>",
      "companyId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "companyName": "<string>",
      "vatIdNumber": "<string>",
      "paymentMethodId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "paymentMethodName": "<string>",
      "isDunningBlocked": true,
      "salesInvoiceDate": "2023-11-07T05:31:56Z",
      "valueDate": "2023-11-07T05:31:56Z",
      "salesInvoiceNumber": "<string>",
      "currencyFactor": 123,
      "shippingMethodId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "shippingMethodName": "<string>",
      "isDraft": true,
      "salesChannelId": "<string>",
      "platformId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "shopId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "languageId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "isIntraCommunityDelivery": true,
      "isExemptFromVat": true,
      "ebayUsername": "<string>",
      "salesChannelName": "<string>",
      "isExternalSalesInvoice": true,
      "printExistingSalesInvoice": true,
      "paymentDate": "2023-11-07T05:31:56Z",
      "printDate": "2023-11-07T05:31:56Z",
      "mailDate": "2023-11-07T05:31:56Z",
      "isDunned": true,
      "stillToPay": 123,
      "alreadyPaidAmount": 123,
      "isCompletelyPaid": true,
      "comment": "<string>",
      "customerComment": "<string>",
      "salesInvoiceCorrectionTotalGrossAmount": 123,
      "hasSalesInvoiceCorrection": true,
      "shipmentAddressCompanyName": "<string>",
      "shipmentAddressSalutation": "<string>",
      "shipmentAddressTitle": "<string>",
      "shipmentAddressFirstName": "<string>",
      "shipmentAddressLastName": "<string>",
      "shipmentAddressStreet": "<string>",
      "shipmentAddressAdditionalAddressLine": "<string>",
      "shipmentAddressPostalCode": "<string>",
      "shipmentAddressCity": "<string>",
      "shipmentAddressCountryName": "<string>",
      "shipmentAddressPhoneNumber": "<string>",
      "shipmentAddressMobilePhoneNumber": "<string>",
      "shipmentAddressFaxNumber": "<string>",
      "shipmentAddressEmailAddress": "<string>",
      "shipmentAddressAdditionalCompanyLine": "<string>",
      "shipmentAddressPostId": "<string>",
      "shipmentAddressState": "<string>",
      "shipmentAddressCountryIso": "<string>",
      "billingAddressCompanyName": "<string>",
      "billingAddressSalutation": "<string>",
      "billingAddressTitle": "<string>",
      "billingAddressFirstName": "<string>",
      "billingAddressLastName": "<string>",
      "billingAddressStreet": "<string>",
      "billingAddressAdditionalAddressLine": "<string>",
      "billingAddressPostalCode": "<string>",
      "billingAddressCity": "<string>",
      "billingAddressCountryName": "<string>",
      "billingAddressPhoneNumber": "<string>",
      "billingAddressMobilePhoneNumber": "<string>",
      "billingAddressFaxNumber": "<string>",
      "billingAddressEmailAddress": "<string>",
      "billingAddressAdditionalCompanyLine": "<string>",
      "billingAddressPostId": "<string>",
      "billingAddressState": "<string>",
      "billingAddressCountryIso": "<string>",
      "totalGrossAmount": 123,
      "shippingCountryTotalGrossAmount": 123,
      "totalNetAmount": 123,
      "shippingCountryTotalNetAmount": 123,
      "createdByUserName": "<string>",
      "customerNumber": "<string>",
      "accountsReceivableNumber": 123,
      "customerGroupName": "<string>",
      "paymentDueDateInDays": 123,
      "paymentDueDate": "2023-11-07T05:31:56Z",
      "dunningLevel": 123,
      "dunningDate": "2023-11-07T05:31:56Z",
      "isArchived": true,
      "processColourCode": 123,
      "processColourName": "<string>",
      "platformType": 123,
      "salesOrderNumber": "<string>",
      "isCorrected": true,
      "isCancelled": true,
      "cancelledDate": "2023-11-07T05:31:56Z",
      "cancellationComment": "<string>",
      "cancellationUserName": "<string>",
      "cancellationReason": "<string>",
      "salesOrderId": "b45f6432-2462-4c6f-b00f-1d9d01000000",
      "externalSalesOrderNumber": "<string>",
      "serviceDateFrom": "2023-11-07T05:31:56Z",
      "serviceDateTo": "2023-11-07T05:31:56Z",
      "lastShippingDate": "2023-11-07T05:31:56Z"
    }
  ],
  "totalPages": 123,
  "hasPreviousPage": true,
  "hasNextPage": true,
  "nextPageNumber": 123,
  "previousPageNumber": 123
}

Authorizations

Authorization

string

header

required

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

Headers

x-tenant-id

string<uuid>

required

The tenant ID for the target ERP instance.

Query Parameters

pageNumber

integer<int32>

Number of the page of items to fetch. Defaults to 1 when omitted.

pageSize

integer<int32>

Size of the page specified by PageNumber. Defaults to 100 when omitted.

sortBy

string

Property to sort by. Multiple comma-separated fields are applied in order (OrderBy, then ThenBy).

sortDescending

boolean

Sort in descending order. Defaults to ascending when omitted.

salesInvoiceDateAfter

string<date-time>

Only include items whose SalesInvoiceDate is after (greater than) this value.

salesInvoiceDateBefore

string<date-time>

Only include items whose SalesInvoiceDate is before (less than) this value.

valueDateAfter

string<date-time>

Only include items whose ValueDate is after (greater than) this value.

valueDateBefore

string<date-time>

Only include items whose ValueDate is before (less than) this value.

paymentDateAfter

string<date-time>

Only include items whose PaymentDate is after (greater than) this value.

paymentDateBefore

string<date-time>

Only include items whose PaymentDate is before (less than) this value.

printDateAfter

string<date-time>

Only include items whose PrintDate is after (greater than) this value.

printDateBefore

string<date-time>

Only include items whose PrintDate is before (less than) this value.

mailDateAfter

string<date-time>

Only include items whose MailDate is after (greater than) this value.

mailDateBefore

string<date-time>

Only include items whose MailDate is before (less than) this value.

paymentDueDateAfter

string<date-time>

Only include items whose PaymentDueDate is after (greater than) this value.

paymentDueDateBefore

string<date-time>

Only include items whose PaymentDueDate is before (less than) this value.

dunningDateAfter

string<date-time>

Only include items whose DunningDate is after (greater than) this value.

dunningDateBefore

string<date-time>

Only include items whose DunningDate is before (less than) this value.

cancelledDateAfter

string<date-time>

Only include items whose CancelledDate is after (greater than) this value.

cancelledDateBefore

string<date-time>

Only include items whose CancelledDate is before (less than) this value.

serviceDateFromAfter

string<date-time>

Only include items whose ServiceDateFrom is after (greater than) this value.

serviceDateFromBefore

string<date-time>

Only include items whose ServiceDateFrom is before (less than) this value.

serviceDateToAfter

string<date-time>

Only include items whose ServiceDateTo is after (greater than) this value.

serviceDateToBefore

string<date-time>

Only include items whose ServiceDateTo is before (less than) this value.

lastShippingDateAfter

string<date-time>

Only include items whose LastShippingDate is after (greater than) this value.

lastShippingDateBefore

string<date-time>

Only include items whose LastShippingDate is before (less than) this value.

Response

Paged result.

totalItems

integer<int32>

pageNumber

integer<int32>

pageSize

integer<int32>

items

object[]

Show child attributes

totalPages

integer<int32>

hasPreviousPage

boolean

hasNextPage

boolean

nextPageNumber

integer<int32>

previousPageNumber

integer<int32>

Query Sales Invoice Correction Cancellation Reasons Get Invoice

⌘I

Overview

GraphQL

REST API

Queries all sales invoices.

Authorizations

Headers

Query Parameters

Response