About Gnosis Chain (GC)
For users
For Stakers
For developers
For validators
Contact & Media Info
API & SQL Access with AnyBlock Analytics
AnyBlock Analytics (eth.events) offers access to GC through ElasticSearch and the ability to query a SQL Database.
Login to create an account
2) You will receive an API key and SQL username/password.
ElasticSearch
- Your API key is used to replace
$mytokenin standard queries. - Queries to the GC use the xdai eth.events endpoint: https://api.eth.events/ethereum/xdai/mainnet/es/
- Documentation regarding ElasticSearch API calls is available here: https://www.anyblockanalytics.com/docs/elastic
For example, this curl query will show us data about the last 2 blocks.
1
curl -X POST \
2
https://api.eth.events/ethereum/xdai/mainnet/es/block/search/ \
3
-H 'Authorization: Bearer $mytoken' \
4
-H 'Content-Type: application/json' \
5
-d '{
6
"sort": {
7
"number.num": "desc"
8
},
9
"size": 2
10
}'
Copied!
SQL Access
2) Click on Server -> Create -> Server
3) In the General Tab, choose a Name for your server instance
4) Go to the Connection Tab, and fill in the information from your AnyBlock Analytics Account and click Save:
Host name.address
sql.anyblock.tools
Port
45432
Maintenance database
ethereum_ethereum_mainnet (or another db from the list)
Username
<your_username>
Password
<your_password>
5) You will see a list of all databases.
- 1.Click on ethereum_poa_xdai to interact with xDai data.
- 2.To Query the DB, go to Tools -> Query Tool
Access the Query Tool
6) Try a Query!
- 1.Check you are in the GC xDai database
- 2.Enter your Query (this query shows info about the most recent block)
- 3.Click the lighting icon to execute
- 4.Output from query
Run query with the lightning icon
7) Explore different queries and information in the SQL documentation and tutorials available here: https://www.anyblockanalytics.com/blog/basic-sql-usage-examples/
Example Query to find transactions for the EternalStorageProxy token contract
1
SELECT * FROM tx
2
WHERE tx.to = '0x7301CFA0e1756B71869E93d4e4Dca5c7d0eb0AA6'
3
LIMIT 50
Copied!
Last modified 3mo ago
Export as PDF
Copy link