TOtonkeeper
stats_service

Get sql history queries

Changed on
get/api/v1/services/stats/queries/history

Request

  • Base URL
    http://localhost:8888
  • Auth
    none declared

Query parameters

project_idinteger required

Project ID

offsetinteger
Example:100

Offset

limitinteger
Example:50

Limit

typeStatsQueryType[]
is_repetitiveboolean
chain'mainnet' | 'testnet'

chain

Response

History of queries

countinteger required

Example response

{
  "count": 10,
  "items": [
    {
      "id": "03cfc582-b1c3-410a-a9a7-1f3afe326b3b",
      "name": "test query",
      "query": {
        "name": "test query",
        "sql": "select id from accounts limit 1",
        "gpt_message": "give me random id from accounts table",
        "repeat_interval": 10
      },
      "url": "https://sql.io/123.csv",
      "meta_url": "https://sql.io/123_meta.csv",
      "spent_time": 100,
      "last_repeat_date": 1690889913000,
      "total_repetitions": 5,
      "total_usd_cost": 1000000000,
      "usd_cost": 1000000000,
      "error": "invalid something",
      "date_create": 1690889913000
    }
  ]
}

Changes

  • 356252841f50Revision changes
    • breaking

      removed the required property /// from the response with the status

    • warning

      removed the optional property // from the response with the status

    • warning

      removed the optional property // from the response with the status

    • info

      added the optional property // to the response with the status

    • info

      added the optional property // to the response with the status

    • info

      added the required property /// to the response with the status

  • dc03bb6c514dRevision changes
    • info

      added the new optional query request parameter chain

    • info

      added the optional property // to the response with the status

    • info

      added the optional property /// to the response with the status