> For the complete documentation index, see [llms.txt](https://developer.esw.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://developer.esw.com/adobe-commerce-magento/integration/retrieve-esw-order-data.md).

# Retrieve ESW Order Data

ESW order confirmation data includes transaction details that can be used for reporting, reconciliation, and downstream integrations.

This is useful when you need to review ESW values such as taxes, duties, and order-level checkout data after the Adobe Commerce order has been created.

### Where the ESW data is stored

The ESW extension stores order confirmation data in the Adobe Commerce order record.

You can retrieve it through the native Adobe Commerce REST Orders API.

The ESW payload is returned in the `extension_attributes` block for:

* the order
* each order item, when item-level ESW data is available

### Retrieve order data through the REST API

Use the standard Adobe Commerce order endpoint:

```http
GET {domain}/rest/V1/orders/{order_id}
```

Authentication is required before you can access the order data.

For Adobe Commerce REST authentication details, refer to the official [Adobe Commerce Web API documentation](https://developer.adobe.com/commerce/webapi/rest/).

### What to expect in the response

The response contains the standard Adobe Commerce order structure plus ESW-specific data in `extension_attributes`.

Use this data when you need to:

* reconcile tax and duty amounts
* inspect ESW order confirmation values
* pass ESW financial data into reporting or middleware flows

For related order creation behavior, see [Order Creation](/adobe-commerce-magento/adobe-commerce-extension-integration/getting-started/order-creation.md).

### Example response

```json
{
  "items": [
    {
      "tax_invoiceid": "",
      "tax_percent": 15,
      "updated_at": "2024-04-02 13:42:45",
      "weee_tax_applied": "[]",
      "weight": 1,
      "extension_attributes": {
        "esw_order_item": [
          "{\"productCode\":\"24-lB04\",\"hsCode\":\"4202929000\",\"title\":\"Push It Messenger Bag\",\"productUnitPriceInfo\":{\"price\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"65.99\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"65.99\"}},\"discounts\":[{\"discount\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"0.00\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"0.00\"}},\"beforeDiscountPrice\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"47.22\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"65.99\"}}}],\"imageUrl\":\"https://.../pub/media/catalog/product/.../blue-0.jpg\",\"color\":\"black\",\"metadataItems\":[{\"name\":\"sku\",\"value\":\"24-lB04\"}],\"cartItemAdditionRulesApplied\":[{\"value\":\"Product has a lead time of 24 days\"}]}",
          "{\"fromEshopWorld\":\"2024-04-12T00:00:00Z\"}",
          "{\"subtotalBeforeTaxesAndDiscountsApplicable\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"47.22\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"65.99\"}},\"subtotalAfterCartDiscount\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"47.22\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"65.99\"}},\"cartDiscount\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"0.00\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"0.00\"}},\"subtotal\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"47.22\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"65.99\"}},\"tax\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"14.67\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"0.00\"}},\"deliverySurcharge\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"0.00\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"0.00\"}},\"deliveryTax\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"0.00\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"0.00\"}},\"administration\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"0.00\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"0.00\"}},\"duty\":{\"retailer\":{\"currency\":\"USD\",\"amount\":\"0.00\"},\"shopper\":{\"currency\":\"CAD\",\"amount\":\"0.00\"}}}"
        ]
      },
      "billing_address": {},
      "payment": {}
    }
  ]
}
```

### Expected result

After the integration is working:

* Adobe Commerce orders include ESW confirmation data
* ESW values can be retrieved through the native REST API
* downstream systems can use the returned data for reporting and reconciliation


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://developer.esw.com/adobe-commerce-magento/integration/retrieve-esw-order-data.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.