JTL-WAWI API (Cloud) (1.0)

Introduction

Welcome to the JTL-WAWI technical API documentation. This guide is here to help developers understand how our REST API works and how it can be integrated into your existing systems. We'll delve into the details of authentication and data manipulation processes, providing clear examples along the way. Whether you're a developer or an IT professional, this documentation aims to give you a practical understanding, laying the groundwork for effectively using the JTL-WAWI API to enhance your processes.

Authentication

You register your application with the API by sending a POST request with the required information and corresponding keys. You can find the exact request details at https://developer.jtl-software.com/products/erp/swagger/appregistration. This information has to include the following:

  • AppId
  • DisplayName
  • Description
  • Version
  • ProviderName
  • ProviderWebsite
  • MandatoryApiScopes

This data is crucial for identifying and registering your application with the API. The API uses it to generate a temporary authentication ID that allows your application to access the necessary resources. After successful validation of this information, you will receive the API key required for future authentication and API requests.

Before you can begin the registration process, you must open JTL-Wawi (new interface) and start the registration process under 'Admin->App registration'. Only at this point are you authorised to send the first API call. This step in JTL-Wawi ensures that your application is properly registered and has permission to use the API.

The API will send you an authentication ID in the form of a token. Once you have received this token and successfully completed the registration in JTL-Wawi, you will send another request to the API by including this authentication ID in the URL path.

After successful validation of this second request by the API and confirmation of the correct information, you will be provided with the actual API key. It is important to note that this API key will not be displayed again!

This API key will be used in the future to authenticate requests to the API. It is of utmost importance that you securely store the API key upon receipt, as it cannot be retrieved from any other location in the system.

Download OpenAPI description
Languages
Servers
Mock server
https://developer.jtl-software.com/_mock/products/erpapi/1.0-cloud/openapi/
https://api.jtl-cloud.com/erp/

info

Operations

features

Operations

printer

Operations

company

Operations

supplier

Operations

colorcodes

Operations

item

Operations

property

Operations

returnstate

Planned

Operations

onholdreason

Operations

returnreason

Planned

Operations

saleschannel

Operations

customerGroup

Operations

paymentmethod

Operations

odata

Operations

shippingmethod

Operations

warehouse

Operations

customerCategory

Operations

return

Operations

cancellationreason

Operations

transactionStatus

Operations

invoice

Planned

Operations

customer

Operations

category

Operations

salesorder

Operations

deliverynote

Planned

Operations

appRegistration

Operations

wms

Operations

stock

Operations

Query Stocks Per Item

Request

Query stocks for a specific item, warehouse or storage location

Query
itemIdinteger(int32)

The id of the item that the stock belong to.

warehouseIdinteger(int32)

The id of the warehouse that the stock belong to.

storageLocationIdinteger(int32)

The id of the storage location that the stock belong to.

pageNumberinteger(int32)

Number of the page of items to fetch.

pageSizeinteger(int32)

Size of the page that is specified by pageNumber.

Headers
api-versionstring

The requested API version

x-appidstringrequired

This is the name of your application, in this case "MyApp/1.0.0". It is used to identify your application.

x-appversionstringrequired

This is where the version number of your application is entered, in this case "1.0.0".

x-runasstring

The User-Id as int or uuid to run the Request, a JTL-Wawi user can be specified to perform an API call on their behalf (more details in the documentation, Optional). To use the Header, you must have the needed Scope 'Application.RunAs'

tenant-idstring(uuid)required

Specify the TenantId in GUID Format

x-api-keystring(uuid)required

Specify the ApiKey from RegistrationProcess in Uuid Format

curl -i -X GET \
  'https://developer.jtl-software.com/_mock/products/erpapi/1.0-cloud/openapi/stocks?itemId=0&pageNumber=0&pageSize=0&storageLocationId=0&warehouseId=0' \
  -H 'Authorization: Bearer <YOUR_TOKEN_HERE>' \
  -H 'api-version: string' \
  -H 'tenant-id: 497f6eca-6276-4993-bfeb-53cbbbba6f08' \
  -H 'x-api-key: YOUR_API_KEY_HERE' \
  -H 'x-appid: string' \
  -H 'x-appversion: string' \
  -H 'x-runas: string'

Responses

The requested stock information.

Bodyapplication/json
TotalItemsinteger(int32)required

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

PageNumberinteger(int32)required

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

PageSizeinteger(int32)required

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

ItemsArray of objects(Stock)required

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

Items[].​WarehouseIdinteger(int32)required

Warehouse ID.

Example: 5
Items[].​StorageLocationIdinteger(int32)required

Storage location ID if the warehouse type is JTL-WMS.

Example: 8
Items[].​StorageLocationNamestringrequired

Name of the storage location.

Example: "R15-F12-08"
Items[].​ItemIdinteger(int32)required

Id of the item.

Example: 1001
Items[].​ShelfLifeExpirationDatestring(date-time)required

Shelf life expiration date of the item, if applicable.

Example: "TODO"
Items[].​BatchNumberstringrequired

Batch number of the item if, the item is a batch item.

Example: "20240315A"
Items[].​QuantityTotalnumber(decimal)required

Total quantity of this item at this storage location.

Example: 32
Items[].​QuantityLockedForShipmentnumber(decimal)required

Quantity at this storage location that is locked for shipment, f.e. because the storage location or warehouse is locked for shipment.

Example: 1
Items[].​QuantityLockedForAvailabilitynumber(decimal)required

Quantity at this storage location that is locked for availability, f.e. because the storage location or warehouse is locked for availability.

Example: 0
Items[].​QuantityInPickingListsnumber(decimal)required

Quantity at this storage location that is on picking lists.

Example: 3
TotalPagesinteger(int32)read-only

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

HasPreviousPagebooleanread-only

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

HasNextPagebooleanread-only

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

NextPageNumberinteger(int32)read-only

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

PreviousPageNumberinteger(int32)read-only

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

Response
application/json
{ "TotalItems": 0, "PageNumber": 0, "PageSize": 0, "Items": [ {} ], "TotalPages": 0, "HasPreviousPage": true, "HasNextPage": true, "NextPageNumber": 0, "PreviousPageNumber": 0 }

Stock Adjustment

Request

Adjust the stock of a specific item. Depending from the item and warehouse many more details must be given (f.e. storage location, batch,...).

Query
disableAutomaticWorkflowsboolean

If true, the workflows do not trigger automatic.

Headers
api-versionstring

The requested API version

x-appidstringrequired

This is the name of your application, in this case "MyApp/1.0.0". It is used to identify your application.

x-appversionstringrequired

This is where the version number of your application is entered, in this case "1.0.0".

x-runasstring

The User-Id as int or uuid to run the Request, a JTL-Wawi user can be specified to perform an API call on their behalf (more details in the documentation, Optional). To use the Header, you must have the needed Scope 'Application.RunAs'

tenant-idstring(uuid)required

Specify the TenantId in GUID Format

x-api-keystring(uuid)required

Specify the ApiKey from RegistrationProcess in Uuid Format

Bodyapplication/jsonrequired

The relevant information for the stock change.

WarehouseIdinteger(int32)required

Warehouse ID.

Example: 5
StorageLocationIdinteger(int32)

Storage location ID if the warehouse type is JTL-WMS.

Example: 8
ItemIdinteger(int32)required

Id of the item.

Example: 1001
ShelfLifeExpirationDatestring(date-time)

Shelf life expiration date of the item, if applicable.

Example: "TODO"
BatchNumberstring

Batch number of the item if, the item is a batch item.

Example: "20240315A"
Quantitynumber(double)required

The quantity that should be added to this storage location.

Example: 500
PurchasePriceNetnumber(decimal)

The purchase price of the item.

Example: 45.67
SerialNumbersArray of strings

Serial numbers of the item. The amount of serial numbers must match the quantity and no serial numbers that are already in stock are allowed.

Example: ""
Commentstring

Comment for this stock change.

Example: "Comment for this stock change"
curl -i -X POST \
  'https://developer.jtl-software.com/_mock/products/erpapi/1.0-cloud/openapi/stocks?disableAutomaticWorkflows=true' \
  -H 'Authorization: Bearer <YOUR_TOKEN_HERE>' \
  -H 'Content-Type: application/json' \
  -H 'api-version: string' \
  -H 'tenant-id: 497f6eca-6276-4993-bfeb-53cbbbba6f08' \
  -H 'x-api-key: YOUR_API_KEY_HERE' \
  -H 'x-appid: string' \
  -H 'x-appversion: string' \
  -H 'x-runas: string' \
  -d '{
    "WarehouseId": 5,
    "StorageLocationId": 8,
    "ItemId": 1001,
    "ShelfLifeExpirationDate": "TODO",
    "BatchNumber": "20240315A",
    "Quantity": 500,
    "PurchasePriceNet": 45.67,
    "SerialNumbers": "",
    "Comment": "Comment for this stock change"
  }'

Responses

The created stock.

Bodyapplication/json
WarehouseIdinteger(int32)required

Warehouse ID.

Example: 5
StorageLocationIdinteger(int32)required

Storage location ID if the warehouse type is JTL-WMS.

Example: 8
StorageLocationNamestringrequired

Name of the storage location.

Example: "R15-F12-08"
ItemIdinteger(int32)required

Id of the item.

Example: 1001
ShelfLifeExpirationDatestring(date-time)required

Shelf life expiration date of the item, if applicable.

Example: "TODO"
BatchNumberstringrequired

Batch number of the item if, the item is a batch item.

Example: "20240315A"
QuantityTotalnumber(decimal)required

Total quantity of this item at this storage location.

Example: 32
QuantityLockedForShipmentnumber(decimal)required

Quantity at this storage location that is locked for shipment, f.e. because the storage location or warehouse is locked for shipment.

Example: 1
QuantityLockedForAvailabilitynumber(decimal)required

Quantity at this storage location that is locked for availability, f.e. because the storage location or warehouse is locked for availability.

Example: 0
QuantityInPickingListsnumber(decimal)required

Quantity at this storage location that is on picking lists.

Example: 3
Response
application/json
{ "WarehouseId": 5, "StorageLocationId": 8, "StorageLocationName": "R15-F12-08", "ItemId": 1001, "ShelfLifeExpirationDate": "TODO", "BatchNumber": "20240315A", "QuantityTotal": 32, "QuantityLockedForShipment": 1, "QuantityLockedForAvailability": 0, "QuantityInPickingLists": 3 }

Query Stock Changes

Request

Returns all stock changes for a specific item from a given start date

Query
itemIdinteger(int32)

The id of the item.

startDatestring(date-time)

The start date from which all stock Adjustments until now are returned.

pageNumberinteger(int32)

Number of the page of items to fetch.

pageSizeinteger(int32)

Size of the page that is specified by pageNumber.

Headers
api-versionstring

The requested API version

x-appidstringrequired

This is the name of your application, in this case "MyApp/1.0.0". It is used to identify your application.

x-appversionstringrequired

This is where the version number of your application is entered, in this case "1.0.0".

x-runasstring

The User-Id as int or uuid to run the Request, a JTL-Wawi user can be specified to perform an API call on their behalf (more details in the documentation, Optional). To use the Header, you must have the needed Scope 'Application.RunAs'

tenant-idstring(uuid)required

Specify the TenantId in GUID Format

x-api-keystring(uuid)required

Specify the ApiKey from RegistrationProcess in Uuid Format

curl -i -X GET \
  'https://developer.jtl-software.com/_mock/products/erpapi/1.0-cloud/openapi/stocks/changes?itemId=0&pageNumber=0&pageSize=0&startDate=2019-08-24T14%3A15%3A22Z' \
  -H 'Authorization: Bearer <YOUR_TOKEN_HERE>' \
  -H 'api-version: string' \
  -H 'tenant-id: 497f6eca-6276-4993-bfeb-53cbbbba6f08' \
  -H 'x-api-key: YOUR_API_KEY_HERE' \
  -H 'x-appid: string' \
  -H 'x-appversion: string' \
  -H 'x-runas: string'

Responses

The requested stock changes.

Bodyapplication/json
TotalItemsinteger(int32)required

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

PageNumberinteger(int32)required

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

PageSizeinteger(int32)required

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

ItemsArray of objects(StockChange)required

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

Items[].​ItemIdinteger(int32)required

Id of the item.

Example: 15
Items[].​WarehouseIdinteger(int32)required

Id of the Warehouse.

Example: 1
Items[].​StorageLocationIdinteger(int32)required

Id of the storage location.

Example: 1
Items[].​Quantitynumber(decimal)required

The quantity that was changed.

Example: 100
Items[].​ChangedDatestring(date-time)required

The date when the stock change took place.

Example: "2023-01-15T13:00:00.0000000+00:00"
Items[].​ShelfLifeExpirationDatestring(date-time)required

Shelf life expiration date of the item if the item has one.

Example: "2023-01-15T13:00:00.0000000+00:00"
Items[].​BatchNumberstringrequired

Batch number of the item if the item is a batch item.

Example: "20240315A"
Items[].​Commentstringrequired

Comment for this stock change.

Example: "Comment for this stock change"
Items[].​Usernamestringrequired

Name of the user who made this stock change.

Example: "user1"
TotalPagesinteger(int32)read-only

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

HasPreviousPagebooleanread-only

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

HasNextPagebooleanread-only

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

NextPageNumberinteger(int32)read-only

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

PreviousPageNumberinteger(int32)read-only

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

Response
application/json
{ "TotalItems": 0, "PageNumber": 0, "PageSize": 0, "Items": [ {} ], "TotalPages": 0, "HasPreviousPage": true, "HasNextPage": true, "NextPageNumber": 0, "PreviousPageNumber": 0 }

Query Serial Number Per Warehouse

Request

Query the serial numbers for a specific item and warehouse

Query
itemIdinteger(int32)

The id of the item that the stock belong to.

warehouseIdinteger(int32)

The id of the warehouse.

pageNumberinteger(int32)

Number of the page of items to fetch.

pageSizeinteger(int32)

Size of the page that is specified by pageNumber.

Headers
api-versionstring

The requested API version

x-appidstringrequired

This is the name of your application, in this case "MyApp/1.0.0". It is used to identify your application.

x-appversionstringrequired

This is where the version number of your application is entered, in this case "1.0.0".

x-runasstring

The User-Id as int or uuid to run the Request, a JTL-Wawi user can be specified to perform an API call on their behalf (more details in the documentation, Optional). To use the Header, you must have the needed Scope 'Application.RunAs'

tenant-idstring(uuid)required

Specify the TenantId in GUID Format

x-api-keystring(uuid)required

Specify the ApiKey from RegistrationProcess in Uuid Format

curl -i -X GET \
  'https://developer.jtl-software.com/_mock/products/erpapi/1.0-cloud/openapi/stocks/serialnumbers?itemId=0&pageNumber=0&pageSize=0&warehouseId=0' \
  -H 'Authorization: Bearer <YOUR_TOKEN_HERE>' \
  -H 'api-version: string' \
  -H 'tenant-id: 497f6eca-6276-4993-bfeb-53cbbbba6f08' \
  -H 'x-api-key: YOUR_API_KEY_HERE' \
  -H 'x-appid: string' \
  -H 'x-appversion: string' \
  -H 'x-runas: string'

Responses

The requested serial numbers for the item and warehouse.

Bodyapplication/json
TotalItemsinteger(int32)required

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

PageNumberinteger(int32)required

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

PageSizeinteger(int32)required

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

ItemsArray of objects(SerialNumber)required

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

Items[].​WarehouseIdinteger(int32)required

Id of the Warehouse.

Example: 5
Items[].​StorageLocationIdinteger(int32)required

Id of the storage location if the warehouse type is JTL-WMS.

Example: 8
Items[].​ItemIdinteger(int32)required

Id of the item.

Example: 1001
Items[].​SerialNumbersArray of stringsrequired

Serial numbers of the item.

Example: ""
TotalPagesinteger(int32)read-only

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

HasPreviousPagebooleanread-only

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

HasNextPagebooleanread-only

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

NextPageNumberinteger(int32)read-only

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

PreviousPageNumberinteger(int32)read-only

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

Response
application/json
{ "TotalItems": 0, "PageNumber": 0, "PageSize": 0, "Items": [ {} ], "TotalPages": 0, "HasPreviousPage": true, "HasNextPage": true, "NextPageNumber": 0, "PreviousPageNumber": 0 }

accountingData

Planned

Operations

tax

Operations

offer

Operations

creditnote

Operations