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.
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:
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.
Search for a specific payment status.0=UnPayed | 1=PartialPayed | 2=Payed
Search for a specific payment status.0=DeliveryNotComplete | 1=DeliveryComplete | 2=DeliveryCompleteWithoutNote
This is the name of your application, in this case "MyApp/1.0.0". It is used to identify your application.
This is where the version number of your application is entered, in this case "1.0.0".
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'
curl -i -X GET \
'https://developer.jtl-software.com/_mock/products/erpapi/1.0-cloud/openapi/salesOrders?billingNumber=string&colorId=0&companyId=0&createdSince=2019-08-24T14%3A15%3A22Z&createdUntil=2019-08-24T14%3A15%3A22Z&createdUserId=0&customerId=0&deliveredDate=2019-08-24T14%3A15%3A22Z&deliveryCompleteStatus=0&ebayUsername=string&externalOrderNumber=string&isCancelled=true&isExternalInvoice=true&itemId=0&onHoldReasonId=0&pageNumber=0&pageSize=0&paymentMethodId=0&paymentStatus=0&salesChannelId=string&salesOrderNumber=string&shippingMethodId=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'
Returns all non-pending sales orders.
Gets or sets the total number of items available in the data source.
Gets or sets the collection of items contained in the paged list.
The external number of the sales order.
Name of the state in the departure country.
ISO code of the currency of the departure country.
Description of the Company.
Additional company information
Street name in the customer's address
Additional address information
Postal code of the customer's address
Name of city in the customer's address
Name of state in the customer's address
Landline phone number
Mobile phone number
Description of the Company.
Additional company information
Street name in the customer's address
Additional address information
Postal code of the customer's address
Name of city in the customer's address
Name of state in the customer's address
Landline phone number
Mobile phone number
The date when the order was created.
The payment method of the sales order.
The payment status of the sales order0=UnPayed | 1=PartialPayed | 2=Payed
The total gross amount of the sales order.
ISO code of the currency of the sales order.
The currency factor in the order at the time the order is created.
Date of payment that paid off the sales order.
The amount that is left to pay for this sales order.
The payment target of the sales order in days.
The cash discount of the sales order.
The shipping method of the sales order.
The delivery status of the sales order.0=DeliveryNotComplete | 1=DeliveryComplete | 2=DeliveryCompleteWithoutNote
The shipping priority of the sales order.
The notified shipping date of the sales order.
The estimated delivery date of the sales order.
The date when the sales order was delivered.
The ID of the on hold reason of the sales order.
Indicates if the invoice of the order was created in an external system, like Amazon VCS.
A customer comment on the sales order.
Indicates if the order has been cancelled. There is a special endpoint for cancelling sales orders.
The id of the reason for cancelling the sales order.
A comment that adds further information to the cancellation.
Gets the total number of pages based on the total number of items and the page size.
Gets a value indicating whether there is a previous page available in the paginated list.
Gets the number of the next page if there is one; otherwise, returns the total number of pages.
{ "TotalItems": 0, "PageNumber": 0, "PageSize": 0, "Items": [ { … } ], "TotalPages": 0, "HasPreviousPage": true, "HasNextPage": true, "NextPageNumber": 0, "PreviousPageNumber": 0 }
This is the name of your application, in this case "MyApp/1.0.0". It is used to identify your application.
This is where the version number of your application is entered, in this case "1.0.0".
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'
The sales order to create.
The date when the order was created.
A customer comment on the sales order.
curl -i -X POST \
'https://developer.jtl-software.com/_mock/products/erpapi/1.0-cloud/openapi/salesOrders?disableAutomaticWorkflows=true&renameSalesOrderNumberWhenAlreadyExists=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 '{
"Number": "A1004465",
"ExternalNumber": "D456-64894-132",
"BillingNumber": "RE-202404-10000",
"CompanyId": 1,
"DepartureCountry": {
"CountryISO": "DE",
"State": "Berlin",
"CurrencyIso": "EUR",
"CurrencyFactor": 1
},
"CustomerId": 1005,
"CustomerVatID": "DE12345",
"BillingAddress": {
"Company": "Sportbedarf Sommer",
"Company2": "Innovation Division",
"FormOfAddress": "Mr.",
"Title": "Dr.",
"FirstName": "John",
"LastName": "Doe",
"Street": "Main St. 123",
"Address2": "Floor 5, Apt 302",
"PostalCode": "12345",
"City": "Example City",
"State": "Example State",
"CountryIso": "DE",
"VatID": "DE123456789",
"PhoneNumber": "+49 1234 445556661",
"MobilePhoneNumber": "+49 160 123 4567",
"EmailAddress": "example@email.com",
"Fax": "+49 1234 4455566615"
},
"Shipmentaddress": {
"Company": "Sportbedarf Sommer",
"Company2": "Innovation Division",
"FormOfAddress": "Mr.",
"Title": "Dr.",
"FirstName": "John",
"LastName": "Doe",
"Street": "Main St. 123",
"Address2": "Floor 5, Apt 302",
"PostalCode": "12345",
"City": "Example City",
"State": "Example State",
"CountryIso": "DE",
"VatID": "DE123456789",
"PhoneNumber": "+49 1234 445556661",
"MobilePhoneNumber": "+49 160 123 4567",
"EmailAddress": "example@email.com",
"Fax": "+49 1234 4455566615"
},
"SalesOrderDate": "2023-02-01T12:45:00.0000000+00:00",
"SalesOrderPaymentDetails": {
"PaymentMethodId": 12,
"CurrencyIso": "EUR",
"CurrencyFactor": 1,
"PaymentTarget": 0,
"CashDiscount": 5,
"CashDiscountDays": 2
},
"SalesOrderShippingDetail": {
"ShippingMethodId": 3,
"ShippingPriority": 5,
"ShippingDate": "2023-01-15T13:00:00.0000000+00:00",
"EstimatedDeliveryDate": "2023-01-16T13:00:00.0000000+00:00",
"OnHoldReasonId": 1,
"ExtraWeight": 0.1
},
"ColorcodeId": 2,
"Comment": "an additional order comment",
"CustomerComment": "an additional customer comment",
"LanguageIso": "DE"
}'
The created sales order.
ISO code of the currency of the departure country.
Additional company information
Name of state in the customer's address
The date when the order was created.
The payment method of the sales order.
The payment status of the sales order0=UnPayed | 1=PartialPayed | 2=Payed
The total gross amount of the sales order.
ISO code of the currency of the sales order.
The currency factor in the order at the time the order is created.
Date of payment that paid off the sales order.
The amount that is left to pay for this sales order.
The payment target of the sales order in days.
The cash discount of the sales order.
The shipping method of the sales order.
The delivery status of the sales order.0=DeliveryNotComplete | 1=DeliveryComplete | 2=DeliveryCompleteWithoutNote
The shipping priority of the sales order.
The notified shipping date of the sales order.
The estimated delivery date of the sales order.
The date when the sales order was delivered.
The ID of the on hold reason of the sales order.
Indicates if the invoice of the order was created in an external system, like Amazon VCS.
A customer comment on the sales order.
Indicates if the order has been cancelled. There is a special endpoint for cancelling sales orders.
The id of the reason for cancelling the sales order.
A comment that adds further information to the cancellation.
{ "Id": 123, "Number": "A1004465", "ExternalNumber": "D456-64894-132", "BillingNumber": "RE-202404-10000", "CompanyId": 1, "DepartureCountry": { "CountryISO": "DE", "State": "Berlin", "CurrencyIso": "EUR", "CurrencyFactor": 1 }, "CustomerId": 1005, "CustomerVatID": "DE12345", "MerchantVatID": "DE12345", "BillingAddress": { "Id": 100, "Company": "Sportbedarf Sommer", "Company2": "Innovation Division", "FormOfAddress": "Mr.", "Title": "Dr.", "FirstName": "John", "LastName": "Doe", "Street": "Main St. 123", "Address2": "Floor 5, Apt 302", "PostalCode": "12345", "City": "Example City", "State": "Example State", "CountryIso": "DE", "VatID": "DE123456789", "PhoneNumber": "+49 1234 445556661", "MobilePhoneNumber": "+49 160 123 4567", "EmailAddress": "example@email.com", "Fax": "+49 1234 4455566615" }, "Shipmentaddress": { "Id": 100, "Company": "Sportbedarf Sommer", "Company2": "Innovation Division", "FormOfAddress": "Mr.", "Title": "Dr.", "FirstName": "John", "LastName": "Doe", "Street": "Main St. 123", "Address2": "Floor 5, Apt 302", "PostalCode": "12345", "City": "Example City", "State": "Example State", "CountryIso": "DE", "VatID": "DE123456789", "PhoneNumber": "+49 1234 445556661", "MobilePhoneNumber": "+49 160 123 4567", "EmailAddress": "example@email.com", "Fax": "+49 1234 4455566615" }, "SalesOrderDate": "2023-02-01T12:45:00.0000000+00:00", "SalesOrderPaymentDetails": { "PaymentMethodId": 12, "PaymentStatus": "", "TotalGrossAmount": 19.99, "CurrencyIso": "EUR", "CurrencyFactor": 1, "DateOfPayment": "2023-01-15T13:00:00.0000000+00:00", "StillToPay": 0, "PaymentTarget": 0, "CashDiscount": 5, "CashDiscountDays": 2 }, "SalesOrderShippingDetail": { "ShippingMethodId": 3, "DeliveryCompleteStatus": "", "ShippingPriority": 5, "ShippingDate": "2023-01-15T13:00:00.0000000+00:00", "EstimatedDeliveryDate": "2023-01-16T13:00:00.0000000+00:00", "DeliveredDate": "2023-01-15T13:00:00.0000000+00:00", "OnHoldReasonId": 1, "ExtraWeight": 0.1 }, "ColorcodeId": 2, "IsExternalInvoice": false, "Comment": "an additional order comment", "CustomerComment": "an additional customer comment", "IsCancelled": false, "LanguageIso": "DE", "CancellationDetails": { "CancellationReasonId": -4, "CancellationComment": "Change of mind (once again); we should consider terminating the customer relationship", "Date": "2023-02-01T12:45:00.0000000+00:00" }, "SalesChannelId": "1-1-1", "UserCreatedId": 1, "UserId": 1 }
This is the name of your application, in this case "MyApp/1.0.0". It is used to identify your application.
This is where the version number of your application is entered, in this case "1.0.0".
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'
curl -i -X GET \
'https://developer.jtl-software.com/_mock/products/erpapi/1.0-cloud/openapi/salesOrders/{salesOrderId}' \
-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'
Returns the sales order for the given id.
ISO code of the currency of the departure country.
Additional company information
Name of state in the customer's address
The date when the order was created.
The payment method of the sales order.
The payment status of the sales order0=UnPayed | 1=PartialPayed | 2=Payed
The total gross amount of the sales order.
ISO code of the currency of the sales order.
The currency factor in the order at the time the order is created.
Date of payment that paid off the sales order.
The amount that is left to pay for this sales order.
The payment target of the sales order in days.
The cash discount of the sales order.
The shipping method of the sales order.
The delivery status of the sales order.0=DeliveryNotComplete | 1=DeliveryComplete | 2=DeliveryCompleteWithoutNote
The shipping priority of the sales order.
The notified shipping date of the sales order.
The estimated delivery date of the sales order.
The date when the sales order was delivered.
The ID of the on hold reason of the sales order.
Indicates if the invoice of the order was created in an external system, like Amazon VCS.
A customer comment on the sales order.
Indicates if the order has been cancelled. There is a special endpoint for cancelling sales orders.
The id of the reason for cancelling the sales order.
A comment that adds further information to the cancellation.
{ "Id": 123, "Number": "A1004465", "ExternalNumber": "D456-64894-132", "BillingNumber": "RE-202404-10000", "CompanyId": 1, "DepartureCountry": { "CountryISO": "DE", "State": "Berlin", "CurrencyIso": "EUR", "CurrencyFactor": 1 }, "CustomerId": 1005, "CustomerVatID": "DE12345", "MerchantVatID": "DE12345", "BillingAddress": { "Id": 100, "Company": "Sportbedarf Sommer", "Company2": "Innovation Division", "FormOfAddress": "Mr.", "Title": "Dr.", "FirstName": "John", "LastName": "Doe", "Street": "Main St. 123", "Address2": "Floor 5, Apt 302", "PostalCode": "12345", "City": "Example City", "State": "Example State", "CountryIso": "DE", "VatID": "DE123456789", "PhoneNumber": "+49 1234 445556661", "MobilePhoneNumber": "+49 160 123 4567", "EmailAddress": "example@email.com", "Fax": "+49 1234 4455566615" }, "Shipmentaddress": { "Id": 100, "Company": "Sportbedarf Sommer", "Company2": "Innovation Division", "FormOfAddress": "Mr.", "Title": "Dr.", "FirstName": "John", "LastName": "Doe", "Street": "Main St. 123", "Address2": "Floor 5, Apt 302", "PostalCode": "12345", "City": "Example City", "State": "Example State", "CountryIso": "DE", "VatID": "DE123456789", "PhoneNumber": "+49 1234 445556661", "MobilePhoneNumber": "+49 160 123 4567", "EmailAddress": "example@email.com", "Fax": "+49 1234 4455566615" }, "SalesOrderDate": "2023-02-01T12:45:00.0000000+00:00", "SalesOrderPaymentDetails": { "PaymentMethodId": 12, "PaymentStatus": "", "TotalGrossAmount": 19.99, "CurrencyIso": "EUR", "CurrencyFactor": 1, "DateOfPayment": "2023-01-15T13:00:00.0000000+00:00", "StillToPay": 0, "PaymentTarget": 0, "CashDiscount": 5, "CashDiscountDays": 2 }, "SalesOrderShippingDetail": { "ShippingMethodId": 3, "DeliveryCompleteStatus": "", "ShippingPriority": 5, "ShippingDate": "2023-01-15T13:00:00.0000000+00:00", "EstimatedDeliveryDate": "2023-01-16T13:00:00.0000000+00:00", "DeliveredDate": "2023-01-15T13:00:00.0000000+00:00", "OnHoldReasonId": 1, "ExtraWeight": 0.1 }, "ColorcodeId": 2, "IsExternalInvoice": false, "Comment": "an additional order comment", "CustomerComment": "an additional customer comment", "IsCancelled": false, "LanguageIso": "DE", "CancellationDetails": { "CancellationReasonId": -4, "CancellationComment": "Change of mind (once again); we should consider terminating the customer relationship", "Date": "2023-02-01T12:45:00.0000000+00:00" }, "SalesChannelId": "1-1-1", "UserCreatedId": 1, "UserId": 1 }