Reporting Endpoints

Introduction

Reporting partners who have signed an agreement with Deliverect can use a reporting endpoint to collect order data from Deliverect. Access to reporting data is not part of any API scope (e.g., POS, Channel, Dispatch).

The data (JSON format) is sent to a specified endpoint in real-time.
Based on specific triggers

Endpoint types:

New Order (full order content)
Status Update (POS/DMA status change info)
Courier Update (Courier updates will be sent when present, take into account not all channels may necessarily provide them)

❗️
Be aware that the Reporting Endpoint has additional charges so please contact your Partner Manager for more information.

Applications

Here are some examples of applications that could use reporting data:

KDS
Data warehousing
Reporting
Business intelligence
Dashboard tools
Delivery manager
Stock management system

Set up the webhooks

Please provide your webhook URLs to our customer success team so they can add them for you.

The webhook URLs can be included at either:

Account level: To receive order data for the account and all channels.
Channel level: To receive order data only for a specific channel.

Order definitions

🛑 Sample Data Below is sample JSON delivered for reporting purposes. Please refer to the link on the order model to understand the attributes to expect in the payload and note any legacy parameters that should be ignored

▶ See Order Model

{
    "_created": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
    "_updated": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
    "_id": "63********************a7",
    "account": "65********************e9",
    "channelOrderId": "T5*****17e",,
    "channelOrderDisplayId": "**17E",
    "posId": "",
    "posReceiptId": "",
    "posLocationId": "",
    "location": "65********************a4",
    "channelLink": "65********************e2",
    "status": 2,
    "statusHistory": [
      {
        "timeStamp": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
        "status": 4,
        "response": "",
        "source": 2
      },
      {
        "timeStamp": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
        "status": 1,
        "response": "",
        "source": 5
      },
      {
        "timeStamp": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
        "status": 2,
        "response": "",
        "source": 1
      }
    ],
    "packaging": {
      "includeCutlery": false
    },
    "by": "",
    "orderType": 2,
    "channel": 7,
    "pos": 10000,
    "rating": [],
    "pickupTime": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
    "deliveryTime": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
    "deliveryIsAsap": true,
    "courier": {
      "deliveryBy": ""
    },
    "courierUpdateHistory": [
      {
        "status": 81,
        "received": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
        "courier": {},
        "arrivalTime": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
        "deliveryTime": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
        "source": 5
      }
    ],
    "customer": {
      "name": "",
      "phoneNumber": "",
      "phoneAccessCode": "",
      "email": ""
    },
    "deliveryAddress": {
      "street": "1 Greenwich Street, New York, NY 10013, US",
      "postalCode": "10013",
      "area": "Manhattan",
      "city": "New York",
      "country": "US",
      "source": "1 Greenwich Street, New York, NY 10013, US, 10013, Manhattan, New York, US",
      "extraAddressInfo": "Front door has bell"
    },
    "orderIsAlreadyPaid": true,
    "taxes": [],
    "payment": {
      "amount": 11580,
      "type": 3,
      "due": 0,
      "rebate": 0
    },
    "note": "",
      "items": [
      {
        "_id": "65********************2c",
        "plu": "658",
        "name": "7UP",
        "sortOrder": 0,
        "price": 300,
        "quantity": 2,
        "productType": 1,
        "remark": "",
        "categoryInfo": {},
        "subItems": [],
        "packaging": {
          "count": 1,
          "reusable": false,
          "packedItems": 0
        },
        "productTags": [],
        "discountReferenceId": 1,
        "discountReferenceIds": [
          1
        ]
      },
      {
        "_id": "65********************2d",
        "plu": "492",
        "name": "Burger + Drink",
        "sortOrder": 0,
        "price": 1290,
        "quantity": 1,
        "productType": 1,
        "remark": "",
        "categoryInfo": {},
        "subItems": [
          {
            "_id": "64********************1h",
            "plu": "742",
            "name": "Big Burger",
            "sortOrder": 0,
            "price": 0,
            "quantity": 1,
            "productType": 1,
            "categoryInfo": {},
            "subItems": [],
            "packaging": {
              "count": 1,
              "reusable": false,
              "packedItems": 0
            },
            "productTags": []
          },
          {
            "_id": "69********************6g",
            "plu": "656",
            "name": "Cola",
            "sortOrder": 0,
            "price": 0,
            "quantity": 1,
            "productType": 1,
            "categoryInfo": {},
            "subItems": [],
            "packaging": {
              "count": 1,
              "reusable": false,
              "packedItems": 0
            },
            "productTags": []
          }
        ],
        "packaging": {
          "count": 1,
          "reusable": false,
          "packedItems": 0
        },
        "productTags": []
      }
    ],
    "decimalDigits": 2,
    "numberOfCustomers": 0,
    "channelOrderRawId": "65********************27",
    "channelOrderHistoryRawIds": [
      "64********************37",
      "63********************27"
    ],
    "serviceCharge": 0,
    "deliveryCost": 0,
    "bagFee": 0,
    "tip": 0,
    "driverTip": 0,
    "discountTotal": -936,
    "discounts": [
      {
        "type": "item_bogof",
        "provider": "restaurant",
        "name": "BOGO",
        "channelDiscountCode": "",
        "referenceId": 1,
        "value": 300,
        "amount": 300,
        "amountRestaurant": 300,
        "amountChannel": 0
      },
      {
        "type": "order_percent_off",
        "provider": "restaurant",
        "name": "PERCENTOFF",
        "channelDiscountCode": "",
        "referenceId": 2,
        "value": 4000,
        "amount": 636,
        "amountRestaurant": 636,
        "amountChannel": 0
      }
    ],
    "capacityUsages": [],
    "resolvedBy": "",
    "brandId": "65********************e8",
    "timezone": "Europe/Madrid",
    "date": 20****7
  }
}

{
    "orderId": "62********************e4",
    "status": 20,
    "timeStamp": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
    "reason": "",
    "channelOrderId": "T5*****17e",
    "location": "61********************r2",
    "isIgnoredPOSStatus": false
}

{
    "received": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
    "orderId": "62********************e4", 
    "pickupTime": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
    "courier": {
        "firstName": "",
        "lastName": "",
        "phoneNumber": "",
        "deliveryBy": "Uber Eats",
        "status": 83
    },
    "updatedOrigin": 2,
    "rawDriverUpdate": "{}",
    "location": "61********************r2"
}

{
    "received": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
    "orderId": "62********************e4",
    "pickupTime": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
    "courier": {
        "firstName": "",
        "lastName": "",
        "phoneNumber": "",
        "status": 83
    },
    "updatedOrigin": 6,
    "rawDriverUpdate": "{}",
    "deliveryTime": "YYYY-MM-DDTHH:mm:ss.SSSSSSZ",
    "location": "65********************a4",
    "deliverySystem": 10,
    "deliveryJobId": "62********************e4"
}

Updated about 1 month ago