---
title: "Execute Advanced Query"
method: POST
path: "/PenguinStats/api/v2/result/advanced"
tags: ["Result"]
---

# Execute Advanced Query

`POST /PenguinStats/api/v2/result/advanced`

## Request body

- TypesAdvancedQueryRequest
  - `queries` TypesAdvancedQuery[], required
    - `end` integer
    - `interval` integer
    - `isPersonal` boolean
    - `itemIds` string[]
    - `server` string, required
    - `sourceCategory` string
    - `stageId` string, required
    - `start` integer

## Response `200`

Drop Matrix Response: when `interval` has been left undefined.

- object
  - `advanced_results` V2DropMatrixQueryResult[]
    - `matrix` V2OneDropMatrixElement[]
      - `end` integer
      - `itemId` string
      - `quantity` integer
      - `stageId` string
      - `start` integer
      - `stdDev` number
      - `times` integer

## Other responses

- `202` — Trend Response: when `interval` has been defined a value greater than `0`. Notice that this response still responds with a status code of `200`, but due to swagger limitations, to denote a different response with the same status code is not possible. Therefore, a status code of `202` is used, only for the purpose of workaround.
- `500` — An unexpected error occurred

## Changes

- **2023-05-06** `234b883fc044` — 1 info
  - endpoint added
- **2021-12-02** `8a0f5cfc9d22` — 1 breaking
  - api path removed without deprecation

[Change history](https://skmtc.dev/penguin-statistics/apis/penguin-statistics-api/changes/PenguinStats/api/v2/result/advanced/post.md)

---

[API](https://skmtc.dev/penguin-statistics/apis/penguin-statistics-api.md) · [All operations](https://skmtc.dev/penguin-statistics/apis/penguin-statistics-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/penguin-statistics/penguin-statistics-api/revisions/c63a93555782/schema)