Displaying Data on the Cloud

To access real-time mint data, Chainbase offers a convenient solution. The first step involves displaying the data on a cloud platform. Follow the steps below:

Log in to your Chainbase dashboard.

Execute the following SQL query to retrieve the required data:

SELECT
    COUNT(*) AS mints,
    nft_contract_address,
    collection
FROM
    nft.nft_mints
WHERE
    block_time > "2023-06-02"
GROUP BY
    nft_contract_address,
    collection
ORDER BY
    mints DESC
LIMIT 20

This query retrieves the count of mints, NFT contract address, and collection from the nft_mints table. It filters the data based on a specific block time, groups the results by the NFT contract address and collection, and finally, sorts the data in descending order of mints, limiting the output to 20 records.

Generating the API

Once you have the SQL query to retrieve the desired data, the next step involves generating an API request to fetch the real-time NFT data. Follow the steps below:

Step 1: Install Node.js and the Axios library if you haven't already.

Step 2: Use the following code snippet to make the API call:

const axios = require('axios');

axios.post('https://api.chainbase.online/v1/dw/query', {
    "query": "SELECT\ncount(*) as mints,\nnft_contract_address,\ncollection\nFROM\nnft.nft_mints\nWHERE block_time > \"2023-06-02\"\nGROUP BY nft_contract_address, collection\nORDER BY mints DESC\nLIMIT 20"
}, {
    headers: {
        'x-api-key': 'your-chainbase-api'
    }
})
    .then(response => {
        const data = response.data.data;
        console.log(data);
    })
    .catch(error => {
        console.error(error);
    });

This code snippet utilizes the Axios library to send a POST request to the Chainbase API endpoint (https://api.chainbase.online/v1/dw/query). The SQL query is included in the request payload, and the 'x-api-key' header is used for authentication.

Retrieving and Printing Real-Time NFT Data

After making the API call, you will receive a response containing the real-time NFT data. Follow the steps below to extract and print the data:

Access the retrieved data from the response using response.data.data.

Display the data by printing it on the console log.

Run node 'filename'.js

meta: [
{ name: 'mints', type: 'UInt64' },
{ name: 'nft_contract_address', type: 'String' },
{ name: 'collection', type: 'String' }
],
result: [
{
collection: 'XTREME PIXELS',
mints: '22826',
nft_contract_address: '0x0c9663115b36fa95d18e71d59054117bcb0342ef'
},
{
collection: 'Pixel Faces',
mints: '16006',
nft_contract_address: '0x9e2f487ac8025665df21342077430cdde5ce628e'
},
{
collection: 'CashmereLabs Testnet Early Adopter',
mints: '13620',
nft_contract_address: '0x3a40312a1c376aecf855ef784371d1fb1aa2d25d'
},
{
collection: 'BENENA!',
mints: '9999',
nft_contract_address: '0x7879b07ecbd4723359a8ef6b77e67ea383c623ed'
},

Integrating the Code

To integrate the code into your project, follow these steps:

1. Ensure that you have the necessary dependencies installed, such as Node.js and Axios.
2. Copy the code snippet provided in the previous section and paste it into the appropriate part of your project, such as a server or script file.
3. Make sure to include the required API key in the 'x-api-key' header for authentication. Replace the placeholder key with your valid API key.

Exploring Real-Time NFT Data

With the code in place and the real-time NFT data retrieved from Chainbase, you have the opportunity to explore and analyze the data further. Consider the following possibilities:

Customize the SQL Query: Modify the SQL query to fetch different types of data based on your specific requirements. You can adjust the filters, grouping, sorting, or limit conditions to retrieve the desired information.

Perform Additional Operations: Extend the code to perform additional operations on the retrieved data. You can implement calculations, aggregations, or data transformations to gain deeper insights.

Visualize the Data: Utilize data visualization libraries or tools to create meaningful visual representations of the real-time NFT data. Graphs, charts, or interactive dashboards can aid in understanding patterns and trends.

Build Applications: Use the retrieved data to build applications or services that leverage real-time NFT information. This can include portfolio trackers, analytics platforms, or marketplaces.

By exploring and analyzing the real-time NFT data, you can uncover valuable insights and make informed decisions in the dynamic world of NFTs.

Conclusion

Accessing real-time mint data is essential for comprehending the dynamic nature of NFTs. By utilizing our API and following the specified steps, you can effortlessly showcase, retrieve, and manipulate real-time NFT data. The provided code snippet, in conjunction with personalization and further exploration, enables you to acquire valuable insights and develop innovative applications in the NFT realm.

FAQs

Q1: Can I use a different programming language to make the API call?

Certainly! While the code provided uses Node.js and Axios, you can use other programming languages and libraries that support HTTP requests to interact with the Chainbase API.

Q2: How can I modify the SQL query to retrieve data for a different time range?

To fetch data for a different time range, you can modify the block_time condition in the SQL query. Simply update the date to the desired range while maintaining the format as "YYYY-MM-DD".

Q3: Is the provided API key valid for testing purposes?

No, the API key provided is only an example. You can obtain a free API key from our website for authentication and access to our API.

Q4: Where can I get more information about Chainbase and its API?

For more information about Chainbase and API, visit our official website or documentation. We will provide detailed information about authentication, API endpoints, data structures, and any limitations or usage guidelines.

About Chainbase

Chainbase is an all-in-one data infrastructure for Web3 that allows you to index, transform, and use on-chain data at scale. By leveraging enriched on-chain data and streaming computing technologies across one data infrastructure, Chainbase automates the indexing and querying of blockchain data, enabling developers to accomplish more with less effort.

Want to learn more about Chainbase?

Visit our website chainbase.com Sign up for a free account, and Check out our documentation.

Website｜Blog｜Twitter｜Discord｜Link3