Introduction
With the JSON integration, you can automatically send customer, order, and product data to Xendy from your own system or webshop. This keeps your data up to date daily and allows you to segment, personalize, and use automations based on real-time information.
What do you need?
You provide three URLs where Xendy can retrieve the data in JSON format:
- customers.json (customer data)
- orders.json (order data)
- products.json (product data)
These URLs must be secured with an authentication header so that only verified systems have access.
Examples
Example customers.json
[{
“email”: “customer@example.com”,
“first_name”: “John”,
“last_name”: “Doe”,
“phone”: “+31612345678”,
“xendy_vip_status”: “gold”
}
]
Example orders.json
[{
“email”: “customer@example.com”,
“order_date”: “2025-09-07”,
“order_id”: “12345”,
“product_id”: “sku123”,
“quantity”: 2,
“line_amount”: 49.98
},
{
“email”: “customer@example.com”,
“order_date”: “2025-09-07”,
“order_id”: “12345”,
“product_id”: “sku987”,
“quantity”: 1,
“line_amount”: 19.99
},
{
“email”: “anothercustomer@example.com”,
“order_date”: “2025-09-06”,
“order_id”: “54321”,
“product_id”: “sku555”,
“quantity”: 3,
“line_amount”: 74.97
}
]
Example products.json
[{
“product_id”: “sku123”,
“name”: “Blue Hoodie”,
“price”: 24.99,
“product_link”: “https://yourstore.com/product/blue-hoodie”,
“image_url”: “https://yourstore.com/media/blue-hoodie.jpg”,
“xendy_category”: “winter collection”
}
]
Required fields and additional fields
The fields without the xendy_ prefix in the examples are required. These core fields (such as email, order_date, product_id, line_amount) are necessary for the integration to function properly and for the data to synchronize correctly with Xendy.
You can add additional fields with the xendy_ prefix when you want to send more data to Xendy. Examples include xendy_vip_status, xendy_coupon, or xendy_channel.
These additional fields are automatically recognized in Xendy and appear under ‘Filter rules’ in ‘Dynamic segments’. You can also use these fields in an email.
Setting up a custom integration in Xendy
You cannot set up a custom integration yourself yet. Once you have configured the three URLs plus authentication header, you can share them with support@xendy.me. Please also include the URL of your webshop. Setting up your integration takes approximately 1–2 days.
How often is data retrieved?
Xendy automatically retrieves the data from your custom webshop once per day during the night. This keeps your data up to date without you having to do anything. If the data cannot be retrieved, you will proactively receive a notification via email.
Frequently Asked Questions
Xendy automatically retrieves the data from your custom webshop once per day during the night. This keeps your data up to date without you having to do anything. If the data cannot be retrieved, you will proactively receive a notification via email.
