Neu JTL WAWI APIs

[ritu.rbg]

Hi, are there any APIs available in JTL Wawi, where I can get the information of JTL-wawi shop's orders. I have checked, this is available in JTL shop. But I'm not sure about JTL wawi.
I believe JTL connectors are used to connect any online shop with the JTL Wawi shop. But my requirement is different. As soon an order arrives in wawi shop, I want to fetch the information of JTL-wawi's order to save it to my own mysql database to provide further drop shipping services. Please help.

Thanks,

 

[Thomas_T]

Because JTL works with a SQL database and a standalone SQL server, it is faster and easier if you query the data in your third party application directly from the database.

 

[ergowebshop]

Just as Thomas said.
Btw. you'll find orders in the table "Verkauf.tAuftrag" and via the table "Verkauf.tAuftragPosition" it's linked to the articles in "dbo.tArtikel".

 

[ritu.rbg]

Just as Thomas said.
btw you'll find orders in the table "Sales.tOrder" and via the table "Sales.tOrderItem" it's linked to the articles in "dbo.tItem".

I have a different web application at different web server, where I want to pull the information of orders of JTL Wawi shop by using APIs. I want to ask if JTL Wawi provides any kind of APIs to third party applications, where we can pull its data to different web platforms.

 

[ritu.rbg]

In short, I need REST-API for working with the JTL-Wawi Database.

 

[Thomas_T]

There are several methods to use REST und MS-SQL. Use Google 😉
For example: https://hevodata.com/learn/sql-server-rest-api-integration/