🚀 Introducing Brand New Custom Requests to the TON Blockchain!

Today, we are excited to release a new update to the dTON Graphql API, featuring two major enhancements:

Advanced Filters for All Tables

Now, all tables (transactions, accounts, groups) support advanced filters, including:

• exact: Exact match (default, e.g., seqno: 1)
• contains: Case-sensitive containment test
• in: In a given list
• gt / gte: Greater than / Greater than or equal to
• lt / lte: Less than / Less than or equal to
• range: In a given range [val_from, val_to]
• isnull: Corresponds to SQL IS NULL and IS NOT NULL
• and / or / not

Docs: Advanced Filters

Aggregations for Transactions and Accounts Tables

Perform aggregations on any custom fields with operators such as:

• count: Counts the number of items
• sum: Sums the values of a field
• min / max: Finds the minimum value / max: Finds the maximum value
• avg: Calculates the average value
• argMax / argMin: Finds the value of another field corresponding to the max / min valu
• least: Finds the least value among specified fields
• quantile: Calculates the quantile value of a field

Docs: Aggregations

Empower Your Applications with Unlimited Request Types

Use Cases:

• Number of users by smart contract usage
• Sum of jettons or tons for custom filters
• Count of usage by OP code
• And many more…

While the dTON Graphql API is still in experimental mode and does not support paid tariffs, we are offering 30 RPS free for all users until our next update, which will introduce profiles with paid features for all our products.

Try the new update now: dTON Graphql

Stay with @dtontech, we believe in and love our users!

P.S. Image is auto generated by ChatGPT4 🤤