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.