Query リソース - Box Dev Docs

Query for your items.

Query insight entry

A single computed insight entry, containing its grouping keys (if applicable) and the computed metrics.

属性と例

プロパティ	型	必須	説明
`key`	array of `string`	はい	The grouping key values associated with the entry. Contains one value per `group_by` field for `group` entries, and is empty for `overall` and `other` entries.
`type`	`enum<string>`	はい	The type of insight entry, indicating how the associated metrics are aggregated. 使用可能なオプション: `group`, `overall`, `other`.
`metrics`	`object`	はい	A map of metric aliases to their computed results. For `other` entries, the count is reported under the `totalCountBeyondTopGroups` key.

例

{
  "key": [
    "ContractType1"
  ],
  "type": "group",
  "metrics": {
    "totalContractValue": {
      "type": "sum",
      "values": {
        "sum": 180000
      }
    },
    "countContractType": {
      "type": "count",
      "values": {
        "count": 245
      }
    }
  }
}

Query insights

The computed results of an insights request, as a list of insight entries.

属性と例

プロパティ	型	必須	説明
`insights`	array of Query insight entry	はい	The list of computed insight entries. Each entry corresponds to a group, the overall dataset, or the aggregate of groups outside the top results.

例

{
  "insights": [
    {
      "key": [
        "ContractType1"
      ],
      "type": "group",
      "metrics": {
        "totalContractValue": {
          "type": "sum",
          "values": {
            "sum": 180000
          }
        },
        "countContractType": {
          "type": "count",
          "values": {
            "count": 245
          }
        }
      }
    },
    {
      "key": [
        "ContractType4"
      ],
      "type": "group",
      "metrics": {
        "totalContractValue": {
          "type": "sum",
          "values": {
            "sum": 100000
          }
        },
        "countContractType": {
          "type": "count",
          "values": {
            "count": 185
          }
        }
      }
    },
    {
      "key": [
        "ContractType2"
      ],
      "type": "group",
      "metrics": {
        "totalContractValue": {
          "type": "sum",
          "values": {
            "sum": 200000
          }
        },
        "countContractType": {
          "type": "count",
          "values": {
            "count": 150
          }
        }
      }
    },
    {
      "key": [],
      "type": "other",
      "metrics": {
        "totalCountBeyondTopGroups": {
          "type": "count",
          "values": {
            "count": 165
          }
        }
      }
    }
  ]
}

Query result entry

A single item matching the query. Always includes the item type and id. If a fields parameter was specified in the request, then additional item and/or metadata fields will be provided.

属性と例

プロパティ	型	必須	説明
`id`	`string`	はい	The unique identifier of the matching item.
`type`	`string`	はい	The type of the matching item.

例

{
  "id": "12345",
  "type": "file"
}

Query results

A paginated list of items matching the query, using milestone-based marker pagination.

属性と例

プロパティ	型	必須	説明
`entries`	array of Query result entry	はい	The list of items matching the query predicate.
`next_marker`	`string`	はい	The marker for the start of the next page of results. When `null`, there are no further results available. `null` を指定できます。
`limit`	`integer`	はい	The limit that was used for this request. This will be the same as the limit query parameter unless that value exceeded the maximum value allowed.

例

{
  "entries": [
    {
      "id": "12345",
      "type": "file",
      "box": {
        "item": {
          "name": "My Form"
        }
      },
      "enterprise_12345678": {
        "book": {
          "$parent": "file_12345",
          "$scope": "enterprise_12345678",
          "$template": "book",
          "$version": 4,
          "isbn": "1871263670",
          "purchasePrice": 234.57,
          "publicationYear": "1937"
        }
      }
    }
  ],
  "next_marker": "xppy0jjG1kBRSc7NBBSgQmBz1Gk6VaQdg5Vyb+Ob0iA=",
  "limit": 1
}

​Query insight entry

​Query insights

​Query result entry

​Query results

Query insight entry

Query insights

Query result entry

Query results