Last updated

Example Email ERP Connector Json

This document provides an example of the JSON format used in the Email ERP Connector for order notifications

Example JSON

{
  "orderId": "123456",
  "customer": {
    "billing": {
      "city": "Potsdam",
      "countryCode": "DE",
      "houseNumber": "107",
      "street": "Stahnsdorfer Str.",
      "zipCode": "14482"
    },
    "shipping": {
      "firstName": "John",
      "lastName": "Doe",
      "city": "Potsdam",
      "countryCode": "DE",
      "houseNumber": "107",
      "street": "Stahnsdorfer Str.",
      "zipCode": "14482"
    },
    "ipAddress": "127.0.0.1",
    "email": "someone@example.com",
    "firstName": "John",
    "lastName": "Doe"
  },
  "transaction": {
    "transferId": "tr_4Mx7pKLsEZ8nB3Qu5RT2vP9Y",
    "sourceTransferId": "pi_8GtYz2WsKL9mV4Bp6XJKRn3a",
    "retailerAccount": "acct_5TnVb9D3xwsLk7MQ",
    "date": "2025-05-19 09:21:25",
    "currency": "EUR",
    "amount": 49.95,
    "status": "COMPLETED",
    "paymentMethod": "paypal"
  },
  "products": [
    {
      "id": "frontend/J1A2Y34567",
      "ean": "J1A2Y34567-5",
      "size": "XL",
      "hash": 1031550858,
      "quantity": 1,
      "url": "https://jay-data.com/GT421I0Z12-C171",
      "urlLabel": "",
      "urlNote": "",
      "urlImageId": "",
      "price": "49.95",
      "currency": "EUR",
      "name": "Hoodie",
      "subtitle": "This unisex hoodie is the perfect blend of comfort and style. Made from soft, breathable fabric, it offers a cozy fit for all-day wear. With a relaxed design, adjustable drawstring hood, and a front pocket, it's ideal for layering or lounging. Whether you're out and about or just relaxing at home, this versatile hoodie is a must-have addition to your wardrobe.",
      "description": "This unisex hoodie is the perfect blend of comfort and style. Made from soft, breathable fabric, it offers a cozy fit for all-day wear. With a relaxed design, adjustable drawstring hood, and a front pocket, it's ideal for layering or lounging. Whether you're out and about or just relaxing at home, this versatile hoodie is a must-have addition to your wardrobe.",
      "brand": "Stanley",
      "gender": "",
      "material": "85% Organic Cotton, 15% recycled Polyester",
      "color": "French Navy",
      "country": "",
      "images": [
        {
          "url": "https://s3.eu-central-1.amazonaws.com/production-backend-jay/objects/products/frontend/J1A2Y34567/https%3A//s3.eu-central-1.amazonaws.com/production-backend-jay/objects/products/%253Cfrontend%25252FJ1A2Y34567%253E/2a62cfda-93e0-4c20-89f8-20293a402311.jpg%3FX-Amz-Algorithm%3DAWS4-HMAC-SHA256%26X-Amz-Credential%3DAKIAW4EQAFR7OKG63PLK%252F20250519%252Feu-central-1%252Fs3%252Faws4_request%26X-Amz-Date%3D20250519T090947Z%26X-Amz-Expires%3D86400%26X-Amz-SignedHeaders%3Dhost%26X-Amz-Signature%3Da04fa1510dc8f40743bd951180349d4df2628c87b70ce6402d387add1dca258d?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAW4EQAFR7OKG63PLK%2F20250519%2Feu-central-1%2Fs3%2Faws4_request&X-Amz-Date=20250519T091306Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&X-Amz-Signature=a3fc2f2981831926bbff05759263831158e8854f4a55bbcdb739e99b86ab166f",
          "copyrightText": ""
        }
      ],
      "artefactType": "",
      "fit": "normal",
      "availability": "AVAILABLE",
      "outOfStock": false
    }
  ]
}

Sales

For any questions or inquiries, please contact the Jay Sales Team.