--- title: Examples slug: examples icon: 🏗️ docTags: createdAt: 2024-09-27T12:55:54.257Z --- :::hint{type="info"} - If you got timeout error - please, try on other filters or use paid token ::: # Basic ::::ExpandableHeading ## Get TON balance Result is nano TON - divide by 10\*\*9 to get TON :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n raw_account_states(address__friendly: \"EQDrLq-X6jKZNHAScgghh0h1iog3StK71zn8dcmrOj8jPWRA\"){\n account_storage_balance_grams\n }\n}\n" } ``` ::: :::: ::::ExpandableHeading ## Get transactions for account :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n raw_transactions(\n address__friendly: \"Ef9VVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVbxn\"\n order_by: \"lt\"\n order_desc: true\n lt_gt: \"40379620000003\" # pass last lt from prev request here\n page_size: 150 # max transactions per 1 request\n ) {\n address\n workchain\n lt\n }\n}" } ``` ::: :::: ::::ExpandableHeading ## Get transactions count for smart contract hash or by OP code :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n raw_account_states(\n order_by: \"account_storage_balance_grams\"\n order_desc: true,\n account_deleted: 0\n account_storage_balance_grams__gt: 100000000000\n ){\n balance: account_storage_balance_grams\n address\n workchain\n last_tx_at: gen_utime\n }\n}" } ``` ::: :::: ::::ExpandableHeading ## Batch load a LOT of transactions :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n raw_account_states(\n order_by: \"account_storage_balance_grams\"\n order_desc: true,\n account_deleted: 0\n account_storage_balance_grams__gt: 100000000000\n ){\n balance: account_storage_balance_grams\n address\n workchain\n last_tx_at: gen_utime\n }\n}" } ``` ::: :::: ::::ExpandableHeading ## Get TOP accounts by balance over all network :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n raw_account_states(\n order_by: \"account_storage_balance_grams\"\n order_desc: true,\n account_deleted: 0\n account_storage_balance_grams__gt: 100000000000\n ){\n balance: account_storage_balance_grams\n address\n workchain\n last_tx_at: gen_utime\n }\n}" } ``` ::: :::: # NFTs ::::ExpandableHeading ## Get all NFTs of wallet :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n raw_account_states(\n parsed_nft_owner_address_address__friendly: \"EQDrLq-X6jKZNHAScgghh0h1iog3StK71zn8dcmrOj8jPWRA\"\n order_by: \"parsed_nft_index\"\n order_desc: true\n parsed_nft_true_nft_in_collection: 1 # Check that collection approve NFT with such address\n account_state_state_init_code_method_name: \"get_nft_data\"\n account_deleted: 0 \n page_size: 10\n page: 0\n ){\n nft_address: address\n nft_workchain: workchain\n nft_index: parsed_nft_index\n \n \tcollection_address: parsed_nft_collection_address_address\n collection_workchain: parsed_nft_collection_address_workchain\n }\n}" } ``` ::: :::: ::::ExpandableHeading{isOpen="true"} ## Get all nft items for collection :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n raw_account_states(\n account_state_state_init_code_method_name: \"get_nft_data\"\n parsed_nft_collection_address_address__friendly: \"EQBPa7td5VDwGltzeSzsp32MkzqzlqHjAOsKtaX0mkMJhq_B\"\n order_by: \"parsed_nft_index\"\n order_desc: true\n parsed_nft_true_nft_in_collection: 1, # Check that collection approve NFT with such address\n account_deleted: 0 # Account not deleted\n ){\n nft_address: address\n nft_workchain: workchain\n nft_index: parsed_nft_index\n \n \tcollection_address: parsed_nft_collection_address_address\n collection_workchain: parsed_nft_collection_address_workchain\n \n parsed_nft_content_storage_type\n parsed_nft_content_offchain_url\n }\n}" } ``` ::: :::: # Jettons ::::ExpandableHeading{isOpen="true"} ## Get all wallets for Jetton :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n raw_account_states(\n account_state_state_init_code_method_name: \"get_nft_data\"\n parsed_nft_collection_address_address__friendly: \"EQBPa7td5VDwGltzeSzsp32MkzqzlqHjAOsKtaX0mkMJhq_B\"\n order_by: \"parsed_nft_index\"\n order_desc: true\n parsed_nft_true_nft_in_collection: 1, # Check that collection approve NFT with such address\n account_deleted: 0 # Account not deleted\n ){\n nft_address: address\n nft_workchain: workchain\n nft_index: parsed_nft_index\n \n \tcollection_address: parsed_nft_collection_address_address\n collection_workchain: parsed_nft_collection_address_workchain\n \n parsed_nft_content_storage_type\n parsed_nft_content_offchain_url\n }\n}" } ``` ::: :::: ::::ExpandableHeading{isOpen="true"} ## Positive Jetton wallets top-up sum and average :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n groupTransactions(\n by: [\"gen_utime__toYYYYMMDD\"]\n aggregations: [\n {field: \"parsed_jetton_wallet_balance_diff\", operation: \"sum\"},\n {field: \"parsed_jetton_wallet_balance_diff\", operation: \"avg\"}]\n filter_by: {\n or__: [{address_friendly: \"EQAFbVItAokA9p0I1SaZd2PEg7FZQIp449mTcAsD_Qrlfa9a\"}], \n gen_utime__gte: \"2024-07-01 00:00:00\",\n gen_utime__lt: \"2024-08-01 00:00:00\"\n parsed_jetton_wallet_balance_diff__gt: 0 # only positive balance topup\n }\n ) {\n parsed_jetton_wallet_balance_diff__sum\n parsed_jetton_wallet_balance_diff__avg\n }\n}" } ``` ::: :::: ::::ExpandableHeading ## Get all balances of Jetton wallets for user :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n raw_account_states(\n parsed_jetton_wallet_owner_address_address__friendly: \"UQDfmsDtWQP5D_YkXX-XlULvs4HivRaKY38ftT2hS5yAAIma\" # owner address\n account_deleted: 0 # account not deleted\n parsed_jetton_wallet_data_is_approved: 1 # wallet is real\n order_by: \"parsed_jetton_wallet_balance\"\n order_desc: true\n ){\n # Jetton address (concat workcahin:address for RAW form)\n parsed_jetton_wallet_jetton_address_address\n parsed_jetton_wallet_jetton_address_workchain\n \n # Balance of jetton\n parsed_jetton_wallet_balance\n }\n}" } ``` ::: :::: ::::ExpandableHeading ## Top jettons by locked balances This example is available only for authorized users because of long request time. :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n wall_locks: groupAccountStates(\n by: [\"parsed_jetton_wallet_jetton_address_workchain\", \"parsed_jetton_wallet_jetton_address_address\"]\n filter_by: {\n parsed_jetton_owner_code_hash: \"12D793F9C449BEF45C7BB43685DE21D4E03C7118B5D38F0BF3C7B9BEB497900D\" # All jettons with lock smart contract owner\n }\n aggregations: [\n {field: \"parsed_jetton_wallet_balance\", operation: \"sum\"}, # Sum of locked balances \n {operation: \"count\"} # Count of lock contracts\n ]\n order_by: \"parsed_jetton_wallet_balance__sum\"\n order_desc: true\n ) {\n parsed_jetton_wallet_jetton_address_workchain\n parsed_jetton_wallet_jetton_address_address\n count\n parsed_jetton_wallet_balance__sum\n }\n}" } ``` ::: :::: ::::ExpandableHeading ## TOP Jettons by holders count This example is available only for authorized users because of long request time. :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n wall_locks: groupAccountStates(\n by: [\"parsed_jetton_wallet_jetton_address_workchain\", \"parsed_jetton_wallet_jetton_address_address\"]\n filter_by: {\n parsed_jetton_owner_code_hash: \"12D793F9C449BEF45C7BB43685DE21D4E03C7118B5D38F0BF3C7B9BEB497900D\" # All jettons with lock smart contract owner\n }\n aggregations: [\n {field: \"parsed_jetton_wallet_balance\", operation: \"sum\"}, # Sum of locked balances \n {operation: \"count\"} # Count of lock contracts\n ]\n order_by: \"parsed_jetton_wallet_balance__sum\"\n order_desc: true\n ) {\n parsed_jetton_wallet_jetton_address_workchain\n parsed_jetton_wallet_jetton_address_address\n count\n parsed_jetton_wallet_balance__sum\n }\n}" } ``` ::: :::: ::::ExpandableHeading ## Jetton wallet trend balance by day :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n raw_account_states(\n parsed_jetton_wallet_owner_address_address__friendly: \"UQDfmsDtWQP5D_YkXX-XlULvs4HivRaKY38ftT2hS5yAAIma\" # owner address\n account_deleted: 0 # account not deleted\n parsed_jetton_wallet_data_is_approved: 1 # wallet is real\n order_by: \"parsed_jetton_wallet_balance\"\n order_desc: true\n ){\n # Jetton address (concat workcahin:address for RAW form)\n parsed_jetton_wallet_jetton_address_address\n parsed_jetton_wallet_jetton_address_workchain\n \n # Balance of jetton\n parsed_jetton_wallet_balance\n }\n}" } ``` ::: :::: ::::ExpandableHeading ## Find jetton wallets count for jetton (count of actual accounts by filters) This example is available only for authorized users because of long request time. :::GraphiQL ```json { "endpoint": "https://dton.io/graphql/", "query": "{\n groupAccountStates(\n by: [\"parsed_jetton_wallet_jetton_address_workchain\", \"parsed_jetton_wallet_jetton_address_address\"]\n filter_by: {\n parsed_jetton_wallet_data_is_approved: 1, # Account wallet data is approved by jetton\n account_deleted: 0, # Account is not deleted\n parsed_jetton_wallet_jetton_address_address__friendly: \"EQALfk9nvSBhxD41SmFO3aM3R51CINSPs-ZUTAO2fz7bIJB8\"} # Master jetton address\n aggregations: [{operation: \"count\"}]\n ) {\n count\n }\n}" } ``` ::: ::::