> ## Documentation Index
> Fetch the complete documentation index at: https://developers.mioesim.com/llms.txt
> Use this file to discover all available pages before exploring further.

# GET /api_esim/queryEsimOrder — Query SIM card order list

> List eSIM and physical SIM card orders with rich filtering: by order number, ICCID, status, date range, card type, and external IDs. Paginated.

This is the recommended endpoint for querying orders. It supports both eSIM and physical SIM cards and provides more filter options than the legacy [Query Orders](/api-reference/query-orders) endpoint.

```
GET https://bpm.mioesim.com/api_esim/queryEsimOrder
```

## Request parameters

<ParamField query="token" type="string" required>Session token.</ParamField>
<ParamField query="sign" type="string" required>Request signature.</ParamField>
<ParamField query="orderNum" type="string">Filter by specific order number.</ParamField>
<ParamField query="iccid" type="string">Filter by a single ICCID.</ParamField>
<ParamField query="subTime" type="string">Order creation time range. Format: `YYYY/MM/DD-YYYY/MM/DD`. Defaults to the past 3 months if all parameters are omitted.</ParamField>
<ParamField query="sTime" type="string">Plan start date range. Format: `YYYY/MM/DD-YYYY/MM/DD`.</ParamField>
<ParamField query="eTime" type="string">Plan end date range. Format: `YYYY/MM/DD-YYYY/MM/DD`.</ParamField>
<ParamField query="status" type="string">Filter by order status code. See [Order Statuses](/reference/order-statuses).</ParamField>
<ParamField query="packetName" type="string">Filter by package name (e.g. `Asia 8`).</ParamField>
<ParamField query="cardType" type="string">`0` = eSIM, `1` = physical SIM.</ParamField>
<ParamField query="orderMode" type="string">`0` = self-owned card, `1` = courier delivery, `2` = pickup.</ParamField>
<ParamField query="outerOrderId" type="string">Your external order ID.</ParamField>
<ParamField query="outerItemId" type="string">Your external line item ID.</ParamField>
<ParamField query="pageNo" type="integer">Page number. Default: 1.</ParamField>
<ParamField query="pageSize" type="integer">Results per page. Default: 30.</ParamField>

## Response fields

<ResponseField name="data" type="object">
  <Expandable title="fields">
    <ResponseField name="total" type="integer">Total matching orders.</ResponseField>
    <ResponseField name="page" type="integer">Current page.</ResponseField>

    <ResponseField name="rows" type="array">
      Array of order objects.

      <Expandable title="Order fields">
        <ResponseField name="orderNum" type="string">Order number.</ResponseField>
        <ResponseField name="skuId" type="integer">SKU ID.</ResponseField>
        <ResponseField name="skuName" type="string">SKU product name.</ResponseField>
        <ResponseField name="count" type="integer">Quantity.</ResponseField>
        <ResponseField name="createTime" type="string">Order creation time.</ResponseField>
        <ResponseField name="status" type="integer">Order status.</ResponseField>
        <ResponseField name="totle" type="string">Total price.</ResponseField>
        <ResponseField name="cardType" type="integer">`0` = eSIM, `1` = physical SIM.</ResponseField>
        <ResponseField name="flowType" type="integer">`0` = renewable, `1` = not renewable.</ResponseField>
        <ResponseField name="renew" type="integer">`0` = main order, `1` = renewal.</ResponseField>
        <ResponseField name="pflag" type="boolean">Whether this is a main order.</ResponseField>
        <ResponseField name="packageList" type="array">Plan details per card (iccid, flows, unit, days, usedMb, status, beginDate, endDate).</ResponseField>
      </Expandable>
    </ResponseField>
  </Expandable>
</ResponseField>

## Example

<CodeGroup>
  ```bash cURL theme={null}
  curl "https://bpm.mioesim.com/api_esim/queryEsimOrder?token=YOUR_TOKEN&subTime=2024/12/01-2024/12/31&cardType=0&sign=YOUR_SIGN"
  ```

  ```json Success theme={null}
  {
    "code": "0",
    "message": "success",
    "data": {
      "total": 1,
      "page": 1,
      "rows": [
        {
          "orderNum": "EP20241224002723",
          "skuId": 114,
          "skuName": "Turkey",
          "count": 1,
          "createTime": "2024-12-24 17:30:14.0",
          "status": 0,
          "totle": "2.27",
          "cardType": 1,
          "flowType": 0,
          "renew": 0,
          "pflag": true,
          "packageList": [
            {
              "id": 740667,
              "flows": 1,
              "unit": "GB",
              "days": 1,
              "usedMb": 0.0,
              "name": "1GB DayPass",
              "iccid": "8937204017182391881",
              "status": 0
            }
          ]
        }
      ]
    }
  }
  ```
</CodeGroup>
