Sign in
stats_service

Get an intersection between accounts

post/api/v1/services/stats/cosmos/graph

Query parameters

chain'mainnet' | 'testnet'

chain

addressesstring required
Example:EQ..fz,EQ...fa

Addresses

only_betweenboolean
project_idinteger required

Project ID

repeat_intervalinteger

cyclic execution of requests

Response

Query result

idstring required
namestring
status'executing' | 'success' | 'error' required
type'graph' | 'base_query' | 'chat_gpt_query'
urlstring
meta_urlstring
spent_timeinteger
last_repeat_dateinteger
total_repetitionsinteger
total_usd_costnumber
usd_costnumber
errorstring
all_data_in_previewboolean
testnetboolean required
is_gptboolean
date_createinteger required

Example response

{
  "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

Changed in 12 of the 50 revisions of this API.3324

  • 356252841f50123See the full diff
    • ▲

      removed the required property / from the response with the status

      response-required-property-removed

    • ●

      removed the optional property from the response with the status

      response-optional-property-removed

    • ●

      removed the optional property from the response with the status

      response-optional-property-removed

    • ○

      added the optional property to the response with the status

      response-optional-property-added

    • ○

      added the optional property to the response with the status

      response-optional-property-added

    • ○

      added the required property / to the response with the status

      response-required-property-added

    This revision also has 2 changes that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog

  • 8f2ab3ccc15b1See the full diff
    • ○

      added the non-success response with the status

      response-non-success-status-added

  • dc03bb6c514d2See the full diff
    • ○

      added the optional property to the response with the status

      response-optional-property-added

    • ○

      added the optional property / to the response with the status

      response-optional-property-added

  • dbd561304b3b2See the full diff
    • ○

      added the new optional query request parameter chain

      new-optional-request-parameter

    • ○

      added the required property to the response with the status

      response-required-property-added

  • fc9bd368b4231See the full diff
    • ●

      added the new chat_gpt_query enum value to the response property for the response status

      response-property-enum-value-added

  • f87ef13adb5f3See the full diff
    • ○

      added the optional property to the response with the status

      response-optional-property-added

    • ○

      added the optional property to the response with the status

      response-optional-property-added

    • ○

      added the optional property to the response with the status

      response-optional-property-added

  • e83620df75421See the full diff
    • ○

      added the optional property / to the response with the status

      response-optional-property-added

  • b179482c50fc2See the full diff
    • ○

      added the optional property to the response with the status

      response-optional-property-added

    • ○

      added the optional property / to the response with the status

      response-optional-property-added

  • 068f1873edc41See the full diff
    • ○

      added the optional property / to the response with the status

      response-optional-property-added

  • fd7dc5b14a121See the full diff
    • ○

      added the optional property to the response with the status

      response-optional-property-added