Connector guide5-minute read10 MCP tools7 languages

How to Connect JTL-Wawi to Microsoft Copilot — via MCP

JTL-Wawi — the e-commerce ERP behind a large share of German online retail. Read customers, items, stock, sales orders and shipments from your on-premises JTL-Wawi via the JTL API Server. REST v1, bearer token.

HCBy HelpCode teamUpdated 5 min read Open-source on GitHub

No credit card · 7-day trial · Self-host alternative available

JTL-Wawi

JTL-Wawi

JTL-Wawi — the e-commerce ERP behind a large share of German online retail. Read customers, items, stock, sales orders and shipments from your on-premises JTL-Wawi via the JTL API Server. REST v1, Wawi API key.

tools

10

Region

DE

Category

ERP

Authentication

API Key

Required env vars

JTL_WAWI_URLJTL_WAWI_API_KEYJTL_WAWI_APP_IDJTL_WAWI_APP_VERSION
Install in one click on Cloud

7-day free trial · No credit card

  • 7-day free trial
    No credit card required
  • GDPR & SOC 2 ready
    EU data residency, audit logs
  • Open-source on GitHub
    Open source · AGPL-3.0
  • Works with ChatGPT, Claude, Gemini
    Any MCP-compatible client

Skip the install. Get this working in under 2 minutes.

Start a free trial on cloud.anythingmcp.com, add the JTL-Wawi in one click, then point your AI client (Claude, ChatGPT, Copilot or Cursor) at the generated MCP endpoint. No Docker, no git clone, zero engineering experience required.

Start free trial

Summary

JTL-Wawi — the e-commerce ERP behind a large share of German online retail. Read customers, items, stock, sales orders and shipments from your on-premises JTL-Wawi via the JTL API Server. REST v1, bearer token.

Try asking

Example prompts for JTL-Wawi

Click any prompt to copy it. Paste into Claude, ChatGPT, Cursor, Gemini, Copilot or OpenClaw to run it against this connector.

JTL-Wawi · live via MCP
Share
Opus 4.7

Claude is AI and can make mistakes. Please double-check responses.

💡 No install? Use cloud.anythingmcp.com directly. Sign in, click Connectors → JTL-Wawi, paste your credentials, mint an MCP API key — done. No Docker, no git clone, no local server.

JTL-Wawi + Microsoft Copilot

JTL-Wawi — the e-commerce ERP behind a large share of German online retail. Read customers, items, stock, sales orders and shipments from your on-premises JTL-Wawi via the JTL API Server. REST v1, bearer token.

Prerequisites

See the full setup instructions baked into the connector (visible in the in-app store when you select the connector). The required environment variables for this connector are:

JTL_WAWI_URL, JTL_WAWI_API_KEY, JTL_WAWI_APP_ID, JTL_WAWI_APP_VERSION

Step 1 — Get credentials

JTL-Wawi is on-premises Windows software and does not speak HTTP on its own. The REST API is served by the separate JTL API Server (sometimes called the Wawi API / JTL-Wawi API), which you install alongside the Wawi database.

  1. Install the JTL API Server on the machine that reaches your JTL-Wawi MSSQL database, and start its service.
  2. Register an app: in JTL-Wawi open Admin → App registration and start the registration, then send POST /api/eazybusiness/authentication with the app's details (AppId, DisplayName, Description, Version, ProviderName, ProviderWebsite, MandatoryApiScopes) and an x-challengecode header. …

Step 2 — Install the adapter

curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d

Step 3 — Add the connector in Microsoft Copilot

Your server URL: in AnythingMCP, open MCP Servers → the server this connector is on, and copy its URL (https://cloud.anythingmcp.com/mcp/…). Use it wherever this guide shows YOUR_SERVER_ID.

Microsoft Copilot uses MCP servers through agents built in Copilot Studio: you add AnythingMCP to an agent as a tool, then publish the agent to Microsoft 365 Copilot and Teams. Copilot Studio connects from Microsoft's cloud over Streamable HTTP, which AnythingMCP supports.

  1. In Copilot Studio, open your agent (or create one), go to Tools and choose Add a tool → New tool → Model Context Protocol.
  2. Enter a Server name (for example AnythingMCP), a Server description that says what the connector does, and the Server URL https://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID. Copilot Studio uses the description to decide when to call the server.
  3. Under authentication, choose API key, set Type to Header and the header name to X-API-Key, then select Create.
  4. In Add tool, choose Create a new connection, paste an MCP API key from AnythingMCP (MCP Servers → your server → API keys) and select Add to agent.
  5. Try it in the agent's Test pane: ask for something that needs the JTL-Wawi tools.
  6. Select Publish, then Channels → Microsoft 365 and Microsoft Teams, keep Make agent available in Microsoft Copilot selected and choose Add channel. See agent in Teams installs it for you; in Microsoft 365 Copilot, type @ and pick the agent.

Prefer per-user sign-in? Choose OAuth 2.0 → Dynamic discovery instead of an API key: each user then signs in to AnythingMCP the first time the agent calls it.

Self-hosting? Use your instance's public HTTPS address instead of https://cloud.anythingmcp.com. Copilot Studio connects from Microsoft's cloud, so localhost does not work.

Available tools

ToolWhat it does
jtl_wawi_list_warehousesList the warehouses (Lager) configured in JTL-Wawi with their id, name and type
jtl_wawi_list_itemsList articles from the item master with their SKU, name, prices, EAN and manufacturer
jtl_wawi_get_itemRead one article in full: its SKU, descriptions, dimensions, prices, categories and supplier links
jtl_wawi_get_item_stockRead the per-warehouse stock of one article: quantity on hand, reserved, and available
jtl_wawi_list_customersList customers with their customer number, company, contact name, address and customer group
jtl_wawi_get_customerRead one customer in full: billing and delivery addresses, payment and shipping defaults, and the customer group they belong to
jtl_wawi_list_sales_ordersList sales orders with their order number, customer, date, payment and shipping status and total
jtl_wawi_get_sales_orderRead one sales order in full: its line items with SKU, quantity and price, the addresses, and the payment and shipping state
jtl_wawi_list_shipmentsList shipments with their tracking number, carrier, date and the sales order they belong to — the answer to 'has it gone out yet'
jtl_wawi_list_sales_order_line_itemsRead the line items of one sales order: SKU, name, quantity ordered, delivered and returned, net and gross price, discount and tax rate

FAQ

Which Copilot is this for? Microsoft 365 Copilot at work, through agents built in Copilot Studio. The Microsoft Copilot app for personal accounts has no option to add your own MCP server.

What do I need? A work account with access to Copilot Studio (a license or a trial) to build the agent. People who use it in Microsoft 365 Copilot or Teams need access to the agent: share it with them, or ask an admin to publish it to the organization. If your organization applies data policies to Power Platform connectors, they cover MCP servers too.

The agent doesn't call the tools. Check that the header name is exactly X-API-Key and that the key belongs to the same MCP server as the URL, and make the server description specific: Copilot Studio uses it to decide when to call the server. Publish the agent again after each change; in an open chat, type "start over" to get the new version.

Next steps

Was this guide helpful?

Your JTL-Wawi agent is one click away.

Install the connector, paste the key, prompt Microsoft Copilot. Free for 7 days, no credit card.

Related guides

Connectors

How to Connect JTL-Wawi to Meta Muse — via MCP

JTL-Wawi — the e-commerce ERP behind a large share of German online retail. Read customers, items, stock, sales orders and shipments from your on-premises JTL-Wawi via the JTL API Server. REST v1, bearer token.

Connectors

How to Connect JTL-Wawi to ChatGPT — via MCP

JTL-Wawi — the e-commerce ERP behind a large share of German online retail. Read customers, items, stock, sales orders and shipments from your on-premises JTL-Wawi via the JTL API Server. REST v1, bearer token.

Connectors

How to Connect JTL-Wawi to Claude — via MCP

JTL-Wawi — the e-commerce ERP behind a large share of German online retail. Read customers, items, stock, sales orders and shipments from your on-premises JTL-Wawi via the JTL API Server. REST v1, bearer token.

Connectors

How to Connect JTL-Wawi to Cursor — via MCP

JTL-Wawi — the e-commerce ERP behind a large share of German online retail. Read customers, items, stock, sales orders and shipments from your on-premises JTL-Wawi via the JTL API Server. REST v1, bearer token.

Connectors

How to Connect JTL-Wawi to Gemini — via MCP

JTL-Wawi — the e-commerce ERP behind a large share of German online retail. Read customers, items, stock, sales orders and shipments from your on-premises JTL-Wawi via the JTL API Server. REST v1, bearer token.

Connectors

JTL-Wawi to MCP — Drive JTL-Wawi from any AI Agent

JTL-Wawi — the e-commerce ERP behind a large share of German online retail. Read customers, items, stock, sales orders and shipments from your on-premises JTL-Wawi via the JTL API Server. REST v1, bearer token.