Ton Console

https://docs.tonconsole.com
Admin
Ton Console is a B2B platform providing technical documentation and guides for developers and...
Tokens:98,251
Snippets:729
Trust Score:6.9
Update:6 days ago
Show doc for...
Tokens:
Raw
### Install graphql-request package

Source: https://docs.tonconsole.com/tonapi/graphql

Command to install the graphql-request library, required for the graphql-request example.

```bash
npm install graphql-request
```

--------------------------------

### Install axios package

Source: https://docs.tonconsole.com/tonapi/graphql

Command to install the axios library in a Node.js environment, required for the axios example.

```bash
npm install axios
```

--------------------------------

### subscribe_trace response example

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example response confirming successful subscription to traces.

```json
{
  "id":1,
  "jsonrpc":"2.0",
  "method":"subscribe_trace",
  "result":"success! 2 new subscriptions created"
}

```

--------------------------------

### Get Jetton Info with TonApiClient

Source: https://docs.tonconsole.com/tonapi/cookbook/working-with-jettons

Initializes the TonApiClient with the TonAPI base URL and optional API key, then fetches Jetton information for a given address. The example shows how to access the preview image, check if the Jetton is blacklisted, and retrieve the metadata name. Requires the @ton-api/client and @ton/core packages.

```TypeScript
import { JettonInfo, JettonVerificationType, TonApiClient } from '@ton-api/client';
import { Address } from '@ton/core';

// if you need to send lots of requests in parallel,
// make sure you use a tonapi token.
const ta = new TonApiClient({
    baseUrl: 'https://tonapi.io'
    // apiKey: 'YOUR_API_KEY',
});

const getJettonItem = async (address: Address): Promise<JettonInfo | null> => {
    const jetton = await ta.jettons.getJettonInfo(address);

    // To get the image for a jetton, use the `preview` field.
    const icon = jetton.preview;

    const isScam = jetton.verification === JettonVerificationType.Blacklist;

    // https://github.com/ton-blockchain/TEPs/blob/master/text/0074-jettons-standard.md
    const name = jetton.metadata.name;

    return jetton
}

getJettonItem(Address.parse('EQCxE6mUtQJKFnGfaROTKOt1lZbDiiX1kCixRv7Nw2Id_sDs'));
```

--------------------------------

### Install TON API and core libraries

Source: https://docs.tonconsole.com/tonapi/dapp/building

Install the @ton-api/client and @ton/core packages via npm.

```bash
npm install @ton-api/client @ton/core
```

--------------------------------

### Install vite-plugin-node-polyfills

Source: https://docs.tonconsole.com/tonapi/dapp/building

Install the vite-plugin-node-polyfills package to provide Buffer polyfill for @ton/core in browser environments.

```bash
npm install vite-plugin-node-polyfills
```

--------------------------------

### subscribe_account response example

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example response confirming successful subscription to account transactions.

```json
{
  "id":1,
  "jsonrpc":"2.0",
  "method":"subscribe_account",
  "result":"success! 2 new subscriptions created"
}

```

--------------------------------

### List webhooks response example

Source: https://docs.tonconsole.com/tonapi/webhooks-api

Example response from GET https://rt.tonapi.io/webhooks, returning all available webhooks. The status field can be online, offline, or suspended; status_updated_at indicates when the status last changed, last_attempt_at shows the last delivery attempt, and status_failed_attempts counts failed deliveries since going offline.

```json
{
  "webhooks": [
    {
      "id": 5,
      "endpoint": "https://your-server.com/webhook",
      "token": "<webhook token>",
      "subscribed_accounts": 10,
      "subscribed_msg_opcodes": 1,
      "subscribed_to_mempool": false,
      "subscribed_to_new_contracts": false,
      "status": "online",
      "status_updated_at": "2026-10-13T10:00:00Z",
      "last_attempt_at": "2026-10-13T10:05:00Z",
      "last_online_at": "2026-10-13T10:05:00Z",
      "status_failed_attempts": 0,
      "add_transaction_info": false,
      "add_account_info": false
    }
  ]
}
```

--------------------------------

### SSE response for new blocks (GET /v2/sse/blocks)

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example response from the SSE endpoint for new blocks. The event is 'message' with an id and data containing block details (workchain, shard, seqno, root_hash, file_hash).

```text
event: message
id: 1702660194645470966
data: {"workchain":0,"shard":"8000000000000000","seqno":40695756,"root_hash":"4506cf117b96acf84717ec4b57d5d46011e94d5722681c3e4ecc8eb54932e7f8","file_hash":"97d993d43df9da463b349a6008baf3b7df229686489150a770a9fd1ffcb2d3f5"}
```

--------------------------------

### Install TonConnect UI React

Source: https://docs.tonconsole.com/tonapi/dapp/building

Installs the @tonconnect/ui-react library required for TonConnect integration.

```bash
npm install @tonconnect/ui-react
```

--------------------------------

### subscribe_block response example

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example response confirming a successful subscription to blocks.

```json
{
   "id": 1,
   "jsonrpc": "2.0",
   "method": "subscribe_block",
   "result": "success! you have subscribed to blocks"
 }

```

--------------------------------

### subscribe_block request example

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example request to subscribe to new blocks, optionally specifying a workchain via the params argument.

```json
 {
   "id": 1,
   "jsonrpc": "2.0",
   "method": "subscribe_block",
   "params": [
     "workchain=-1"
   ]
 }

```

--------------------------------

### subscribe_trace request example

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example request to subscribe to traces involving a list of accounts.

```json
{
  "id":1,
  "jsonrpc":"2.0",
  "method":"subscribe_trace",
  "params":[
    "-1:5555555555555555555555555555555555555555555555555555555555555555",
    "-1:3333333333333333333333333333333333333333333333333333333333333333"
  ]
}

```

--------------------------------

### subscribe_account request example

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example request to subscribe to account transactions, with optional operations filter.

```json
{
  "id":1,
  "jsonrpc":"2.0",
  "method":"subscribe_account",
  "params":[
    "-1:5555555555555555555555555555555555555555555555555555555555555555",
    "-1:3333333333333333333333333333333333333333333333333333333333333333;operations=JettonTransfer,0x0524c7ae"
  ]
}

```

--------------------------------

### Install OpenAPI Generator CLI via npm

Source: https://docs.tonconsole.com/tonapi/sdk

Install the OpenAPI Generator CLI globally using npm. This is a prerequisite for generating an SDK from the TonAPI OpenAPI specification.

```bash
npm install @openapitools/openapi-generator-cli -g
```

--------------------------------

### SSE request for traces (GET /v2/sse/accounts/traces)

Source: https://docs.tonconsole.com/tonapi/streaming-api

GET request to stream traces for a comma-separated list of accounts. The 'accounts' parameter can be 'ALL' to stream all traces.

```text
GET https://tonapi.io/v2/sse/accounts/traces?accounts=<comma-separated-list-of-accounts>
```

--------------------------------

### Get usage statistics response

Source: https://docs.tonconsole.com/tonapi/webhooks-api

Example JSON response from GET https://rt.tonapi.io/usage-stats. Shows the current billing period start, account subscriptions count, and webhooks delivered/failed counts.

```json
{
  "period_started_at": "2026-10-01T00:00:00Z",
  "account_subscriptions": 10,
  "webhooks_delivered": 1000,
  "webhooks_failed": 5
}
```

--------------------------------

### Create table getmethods.get_next_proof_info

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the table for the get_next_proof_info get method, storing next proof and timing information.

```sql
create table getmethods.get_next_proof_info (
	account_id text NOT NULL,
	next_proof bigint NOT NULL,
	last_proof_time bigint NOT NULL,
	max_span bigint NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### Get webhook logs response

Source: https://docs.tonconsole.com/tonapi/webhooks-api

Response example for GET https://rt.tonapi.io/webhooks/{webhook_id}/logs?offset=0. Contains next_offset for pagination and logs with message, event_type, and timestamp. event_type can be account_tx, msg_opcode, new_contract, mempool_msg, or suspended.

```json
{
  "next_offset": 12345,
  "logs": [
    {
      "message": "unexpected status code: 500",
      "event_type": "account_tx",
      "timestamp": "2026-10-13T10:05:00Z"
    }
  ]
}
```

--------------------------------

### Run Development Server with npm run dev

Source: https://docs.tonconsole.com/tonapi/dapp/building

Starts the development server for the dApp. After running, the dApp will be accessible at http://localhost:3000.

```bash
npm run dev
```

--------------------------------

### Get a webhook's subscriptions response

Source: https://docs.tonconsole.com/tonapi/webhooks-api

Example JSON response from GET https://rt.tonapi.io/webhooks/{webhook_id}/account-tx/subscriptions?offset=0&limit=10. Shows subscription details including account ID, last delivered LT, failure time, failed LT, and failed attempts.

```json
{
  "account_tx_subscriptions": [
    {
        "account_id": "0:6ccd325a858c379693fae2bcaab1c2906831a4e10a6c3bb44ee8b615bca1d220",
        "last_delivered_lt": 2900000001,
        "failed_at": "<time of failure>",
        "failed_lt": 2900000000,
        "failed_attempts": 4
    }
  ]
}
```

--------------------------------

### Initialize React project with Vite

Source: https://docs.tonconsole.com/tonapi/dapp/building

Creates a new React project with TypeScript template using Vite and navigates into the project directory.

```bash
npm create vite@latest tonapi-dapp -- --template react-ts
cd tonapi-dapp
```

--------------------------------

### Generate SDK with OpenAPI Generator (Ruby example)

Source: https://docs.tonconsole.com/tonapi/sdk

Generate an SDK using the TonAPI OpenAPI specification. Change the -g parameter to target a different language. Replace /path/to/output with your desired output directory.

```bash
npx openapi-generator-cli generate -i https://raw.githubusercontent.com/tonkeeper/opentonapi/master/api/openapi.yml -g ruby -o /path/to/output
```

--------------------------------

### Create table getmethods.get_plugin_list

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the table for the get_plugin_list get method, storing wallet and plugin account IDs.

```sql
create table getmethods.get_plugin_list (
	wallet_account_id text NOT NULL,
	plugin_account_id text NOT NULL,
	indexer_last_update_lt bigint
);
```

--------------------------------

### Get NFT Collection Details

Source: https://docs.tonconsole.com/tonapi/cookbook/working-with-nfts

Fetches an NFT collection by address using ta.nft.getNftCollection. The previews array contains image URLs at different resolutions; this example finds the 1500x1500 URL. The metadata name falls back to the item address string. Requires a TonApiClient instance with baseUrl 'https://tonapi.io' and optionally an API key.

```TypeScript
import { TonApiClient, NftCollection } from '@ton-api/client';
import { Address } from '@ton/core';

// if you need to send lots of requests in parallel,
// make sure you use a tonapi token.
const ta = new TonApiClient({
  baseUrl: 'https://tonapi.io',
  // apiKey: 'YOUR_API_KEY',
});

const getNftCollection = async (address: Address): Promise<NftCollection | null> => {
  const nftCollection = await ta.nft.getNftCollection(address);

  // The preview field typically contains an array of image URLs, each representing the same image at a different resolution. For example, you might find resolutions like:
  //
  // 5x5 pixels (very small thumbnail)
  // 100x100 pixels (small thumbnail)
  // 500x500 pixels (medium resolution)
  // 1500x1500 pixels (high resolution)
  // These different sizes allow applications to load the most appropriate image based on the display context, optimizing performance and user experience.

  const largePreview = nftCollection.previews?.find((i) => i.resolution === '1500x1500')?.url;

  // https://github.com/ton-blockchain/TEPs/blob/master/text/0062-nft-standard.md
  const name = nftCollection.metadata?.name || nftItem.address.toString();;

  return nftCollection;
};

getNftCollection(Address.parse('EQC3dNlesgVD8YbAazcauIrXBPfiVhMMr5YYk2in0Mtsz0Bz'));
```

--------------------------------

### Get NFT Item Details with TonApiClient

Source: https://docs.tonconsole.com/tonapi/cookbook/working-with-nfts

Fetches NFT item details by address using the TonApiClient. The preview field contains image URLs at different resolutions; the example finds the 1500x1500 URL. The verified field indicates if the NFT's ownership is genuinely associated with its collection. The trust field can be used to detect scams (TrustType.Blacklist).

```TypeScript
import { TonApiClient, NftItem, TrustType } from '@ton-api/client';
import { Address } from '@ton/core';

// if you need to send lots of requests in parallel,
// make sure you use a tonapi token.
const ta = new TonApiClient({
    baseUrl: 'https://tonapi.io'
    // apiKey: 'YOUR_API_KEY',
});

const getNftItem = async (address: Address): Promise<NftItem | null> => {
    const nftItem = await ta.nft.getNftItemByAddress(address);


    // The preview field typically contains an array of image URLs, each representing the same image at a different resolution. For example, you might find resolutions like:
    //
    // 5x5 pixels (very small thumbnail)
    // 100x100 pixels (small thumbnail)
    // 500x500 pixels (medium resolution)
    // 1500x1500 pixels (high resolution)
    // These different sizes allow applications to load the most appropriate image based on the display context, optimizing performance and user experience.

    const largePreviewUrl = nftItem.previews?.find(i => i.resolution === '1500x1500')?.url;

    // The `verified` field indicates whether the NFT's ownership is genuinely associated with its stated collection. When `verified` is true, it means that the NFT's connection to its collection has been confirmed as legitimate.

    const isVerified = nftItem.verified

    const ownerAddress = nftItem.owner?.address;

    const isScam = nftItem.trust === TrustType.Blacklist;

    // https://github.com/ton-blockchain/TEPs/blob/master/text/0062-nft-standard.md
    const name = nftItem.metadata?.name || nftItem.address.toString();

    return nftItem
}

getNftItem(Address.parse('EQA7h-jYk9RRcwSOjZnvAUcPe0VXhbSeSusMuwxzbxCacCZG'));
```

--------------------------------

### Create get_pool_info__bidask table

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

SQL statement to create the getmethods.get_pool_info__bidask table, which stores pool information for the BidAsk DEX. Columns include account_id, asset_x_native, asset_x_account_id, asset_y_native, asset_y_account_id, bin_step, lp_fee, and indexer_last_update_lt.

```sql
create table getmethods.get_pool_info__bidask (
	account_id text NOT NULL,
	asset_x_native boolean NOT NULL,
	asset_x_account_id text,
	asset_y_native boolean NOT NULL,
	asset_y_account_id text,
	bin_step numeric NOT NULL,
	lp_fee numeric NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### CREATE TABLE getmethods.get_wallet_data

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the get_wallet_data table for wallet data, including balance, owner, and jetton account.

```sql
create table getmethods.get_wallet_data (
	account_id text NOT NULL,
	balance numeric NOT NULL,
	owner_account_id text,
	jetton_account_id text NOT NULL,
	code bytea NOT NULL,
	verified boolean,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### Expiry Timestamp Example

Source: https://docs.tonconsole.com/tonkeeper/deep-linking

Example of a transfer URL with an expiry timestamp.

```text
https://app.keeperwallet.com/transfer/EQD2NmD_lH5f5u1Kj3KfGyTvhZSX0Eg6qp2a5IQUKXxOG21n?amount=100000&text=test&exp=2147483647
```

--------------------------------

### subscribe_trace notification example

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example notification sent when a trace completes.

```json
 {
  "jsonrpc":"2.0",
  "method":"trace",
  "params":{
      "accounts":[
          "0:67a8fc0aea189d79e26f50fa9184842a1ab4f19951286d498ea5a106af375044",
          "0:dd61300e0060f80233363b3b4a0f3b27ad03b19cc4bec6ec798aab0b3e479eba",
          "0:d7907ea9bb1fa580aa82489680004e75fbf2842246219e7dac1cf9ea90fb5cf9",
          "0:8c61ced898b13b6aca6f4cada44080e22aacc49680082cb51c66901cdae57451"
      ],
      "hash":"6176c9b1690a7b6beebd09ff118761ee47f1a8be716506874ed0a1c06bb0fc83"
  }
}

```

--------------------------------

### CREATE TABLE getmethods.get_subscription_info__v2

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the table for the get_subscription_info__v2 get-method. Includes subscription metadata, withdrawal message body, and admin account ID.

```sql
create table getmethods.get_subscription_info__v2 (
	account_id text NOT NULL,
	wallet_account_id text NOT NULL,
	wallet_version bigint NOT NULL,
	admin_account_id text NOT NULL,
	subscription_id bigint NOT NULL,
	metadata bytea,
	withdraw_msg_body bytea,
	withdraw_account_id text NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### subscribe_account notification example

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example notification sent when a transaction is committed to the blockchain.

```json
 {
  "jsonrpc":"2.0",
  "method":"account_transaction",
  "params":{
    "account_id":"-1:5555555555555555555555555555555555555555555555555555555555555555",
    "lt":37121758000003,
    "tx_hash":"586e176bdead2a37d9e372c3725e27c4eab90f5b213c6099c6aadeafc8e4fbc9"
  }
}

```

--------------------------------

### subscribe_block notification example

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example notification sent when a new block is available.

```json
{
   "jsonrpc": "2.0",
   "method": "block",
   "params": {
     "workchain": -1,
     "shard": "8000000000000000",
     "seqno": 34832412,
     "root_hash": "2a6595467ba53f63b1b3528762e0ccf396a135348519a1d08d4d5d9efa9f0521",
     "file_hash": "e6a4f3283fd27531fbda844ec480aa23b12e3ee38e21bc5856dee2a1d4f5328a"
   }
 }

```

--------------------------------

### CREATE TABLE getmethods.get_balances__lockup

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the get_balances__lockup table for lockup wallet balances.

```sql
create table getmethods.get_balances__lockup (
	account_id text NOT NULL,
	ton_balance bigint NOT NULL,
	total_restricted_value bigint NOT NULL,
	total_locked_value bigint NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### CREATE TABLE getmethods.get_full_domain

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the table for the get_full_domain getmethod results. Stores the domain as text.

```sql
create table getmethods.get_full_domain (
	account_id text NOT NULL,
	domain text NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### CREATE TABLE getmethods.get_extensions

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the table for the get_extensions get-method, mapping wallet accounts to extension accounts.

```sql
create table getmethods.get_extensions (
	wallet_account_id text NOT NULL,
	extension_account_id text NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### Transfer Examples - Address Only

Source: https://docs.tonconsole.com/tonkeeper/deep-linking

Examples of transfer URLs with only the address, using different prefixes.

```text
ton://transfer/{ADDRESS}
keeper://transfer/{ADDRESS}
tonkeeper://transfer/{ADDRESS}
https://app.keeperwallet.com/transfer/{ADDRESS}
https://app.tonkeeper.com/transfer/{ADDRESS}
```

--------------------------------

### CREATE TABLE getmethods.get_payment_info__subscription_v2

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the table for the get_payment_info__subscription_v2 get-method, storing subscription payment details and contract state.

```sql
create table getmethods.get_payment_info__subscription_v2 (
	account_id text NOT NULL,
	contract_state integer NOT NULL,
	payment_per_period bigint NOT NULL,
	period bigint NOT NULL,
	charge_date bigint NOT NULL,
	grace_period bigint NOT NULL,
	last_request_time bigint NOT NULL,
	caller_fee bigint NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### CREATE TABLE getmethods.get_nft_api_info

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the get_nft_api_info table for NFT API information.

```sql
create table getmethods.get_nft_api_info (
	account_id text NOT NULL,
	version bigint NOT NULL,
	uri text NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### CREATE TABLE getmethods.get_jetton_data

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the table for the get_jetton_data getmethod results. Includes jetton metadata fields such as total_supply, mintable, admin_account_id, content_layout, content, wallet_code, and url.

```sql
create table getmethods.get_jetton_data (
	account_id text NOT NULL,
	total_supply numeric NOT NULL,
	mintable boolean NOT NULL,
	admin_account_id text,
	content_layout bigint NOT NULL,
	content bytea NOT NULL,
	wallet_code bytea NOT NULL,
	url text,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### Transfer Example - Address + Amount

Source: https://docs.tonconsole.com/tonkeeper/deep-linking

Transfer URL format with address and amount parameter.

```text
{PREFIX}transfer/{ADDRESS}?amount={AMOUNT}
```

--------------------------------

### mempool_message event example

Source: https://docs.tonconsole.com/tonapi/streaming-api

Example of a new-pending-message event with method 'mempool_message'. The 'boc' parameter is a serialized instance of a tlb.Message.

```json
{
  "jsonrpc":"2.0",
  "method":"mempool_message",
  "params":{
    "boc":"te6ccgEBBAEAtwABRYgBvVXMoxQj+kmDtTinWnFdumvpTNo33p48YQKOWyTtUkAMAQGcMZ6id5dkoDZImQ4UC5SqZSN04h/xNpKaEsESJQivKW01aMcWW4qeUUjKm/iZ2nszwBj3uFVcsIr9xFomQvY3DCmpoxdkQjldAAAAcAADAgFkQgAoPvU+sDeRbPQrPGn3bxzd8JnUNGlQcfA/qoFluFxSiRE4gAAAAAAAAAAAAAAAAAEDABIAAAAAaGVsbG8="
  }
}
```

--------------------------------

### CREATE TABLE getmethods.get_storage_params

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the table for the get_storage_params getmethod results. Includes storage parameters such as accept_new_contracts, rate_per_mb_day, max_span, minimal_file_size, and maximal_file_size.

```sql
create table getmethods.get_storage_params (
	account_id text NOT NULL,
	accept_new_contracts boolean NOT NULL,
	rate_per_mb_day bigint NOT NULL,
	max_span bigint NOT NULL,
	minimal_file_size bigint NOT NULL,
	maximal_file_size bigint NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### Create table getmethods.get_sale_data__basic

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the table for the get_sale_data__basic get method, storing basic sale data including marketplace, NFT, and royalty information.

```sql
create table getmethods.get_sale_data__basic (
	account_id text NOT NULL,
	marketplace_account_id text NOT NULL,
	nft_account_id text NOT NULL,
	nft_owner_account_id text,
	royalty_account_id text,
	full_price numeric NOT NULL,
	marketplace_fee bigint NOT NULL,
	royalty_amount bigint NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### GET /webhooks/{webhook_id}/logs

Source: https://docs.tonconsole.com/tonapi/webhooks-api

Returns failed delivery attempts and other webhook events. Pass `next_offset` from the response as `offset` to get the next page.

```APIDOC
## [GET] /webhooks/{webhook_id}/logs

### Description
Returns failed delivery attempts and other webhook events. Pass `next_offset` from the response as `offset` to get the next page.

### Method
GET

### Endpoint
https://rt.tonapi.io/webhooks/{webhook_id}/logs?offset=0

### Parameters
#### Path Parameters
- **webhook_id** (string) - Required - The ID of the webhook.

#### Query Parameters
- **offset** (integer) - Optional - Offset for pagination. Use `next_offset` from the previous response.

### Response
#### Success Response (200)
- **next_offset** (integer) - The offset to use for the next page.
- **logs** (array) - List of log entries.
  - **message** (string) - The log message.
  - **event_type** (string) - One of `account_tx`, `msg_opcode`, `new_contract`, `mempool_msg` or `suspended`.
  - **timestamp** (string) - The timestamp of the event.

#### Response Example
{
  "next_offset": 12345,
  "logs": [
    {
      "message": "unexpected status code: 500",
      "event_type": "account_tx",
      "timestamp": "2026-10-13T10:05:00Z"
    }
  ]
}
```

--------------------------------

### CREATE TABLE getmethods.get_public_key

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the table for the get_public_key getmethod results. Stores the public_key as bytea.

```sql
create table getmethods.get_public_key (
	account_id text NOT NULL,
	public_key bytea NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### CREATE TABLE getmethods.get_subscription_data

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the get_subscription_data table for subscription details, including wallet, beneficiary, amount, period, and timing fields.

```sql
create table getmethods.get_subscription_data (
	account_id text NOT NULL,
	wallet_account_id text,
	beneficiary_account_id text,
	amount bigint NOT NULL,
	period bigint NOT NULL,
	start_time bigint NOT NULL,
	timeout bigint NOT NULL,
	last_payment_time bigint NOT NULL,
	last_request_time bigint NOT NULL,
	failed_attempts bigint NOT NULL,
	subscription_id bigint NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### Create webhook response example

Source: https://docs.tonconsole.com/tonapi/webhooks-api

Example response from POST https://rt.tonapi.io/webhooks, containing the webhook ID and secret token. The webhook ID is used to manage subscriptions.

```json
{
  "webhook_id": 5,
  "token": "<webhook token>"
}
```

--------------------------------

### Invoice webhook payload JSON example

Source: https://docs.tonconsole.com/tonconsole/invoices

Example JSON payload that Tonconsole sends to your webhook endpoint when an invoice status changes. Shows the expected field names and value types.

```json
{
  "id": "string",
  "status": "pending | paid | cancelled | expired",
  "amount": "string",
  "description": "string",
  "date_create": 1234567890,
  "date_expire": 1234567890,
  "date_change": 1234567890,
  "payment_link": "string",
  "pay_to_address": "0:<hash>",
  "paid_by_address": "0:<hash>",
  "overpayment": "string"
}
```

--------------------------------

### Create get_current_bin__bidask table

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

SQL statement to create the getmethods.get_current_bin__bidask table, which stores the current bin for BidAsk pools. Columns include account_id, bin, and indexer_last_update_lt.

```sql
create table getmethods.get_current_bin__bidask (
	account_id text NOT NULL,
	bin numeric NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### Invoice API Response Example

Source: https://docs.tonconsole.com/tonconsole/invoices

Example JSON response from the invoice creation API. It includes the invoice ID, status, amount, description, creation and expiration timestamps, payment link, and pay-to address.

```json
{
  "id": "string",
  "status": "pending",
  "amount": "string",
  "description": "string",
  "date_create": 1234567890,
  "date_expire": 1234567890,
  "payment_link": "string",
  "pay_to_address": "0:<hash>"
}
```

--------------------------------

### CREATE TABLE getmethods.get_auction_info

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

Defines the get_auction_info table for auction information.

```sql
create table getmethods.get_auction_info (
	account_id text NOT NULL,
	max_bid_account_id text,
	max_bid_amount bigint NOT NULL,
	auctions_end_time bigint NOT NULL,
	indexer_last_update_lt bigint NOT NULL
);
```

--------------------------------

### getBlockchainValidators

Source: https://docs.tonconsole.com/tonapi/rest-api/blockchain

Get blockchain validators

```APIDOC
## getBlockchainValidators

### Description
Get blockchain validators

### Method
GET

### Endpoint
/blockchain/validators

### Response
#### Success Response (200)
- **validators** (array of object) - List of validators.

#### Response Example
{
  "validators": []
}
```

--------------------------------

### Create nft.url_metadata table

Source: https://docs.tonconsole.com/tonconsole/analytics/scheme

SQL statement to create the nft.url_metadata table, which stores metadata for jetton masters, NFT collections, and NFT items. Columns include url, metadata, last_offchain_meta_refresh_try, and last_offchain_meta_refresh_success.

```sql
create table nft.url_metadata (
	url text NOT NULL,
	metadata jsonb NOT NULL,
	last_offchain_meta_refresh_try timestamp with time zone DEFAULT '1970-01-01 00:00:01+00'::timestamp with time zone NOT NULL,
	last_offchain_meta_refresh_success timestamp with time zone DEFAULT '1970-01-01 00:00:01+00'::timestamp with time zone NOT NULL
);
```
Tokens:
Raw