In the world of blockchain technology, Solana is one of the fast-growing ecosystems. It's a high-performance blockchain that can handle thousands of transactions per second with low transaction fees. With the increasing adoption of Solana, developers are building decentralized applications and tools on top of it. One of the essential features of these tools is the ability to fetch transaction data for a given Solana address. In this article, we'll explain how the FlipsideCrypto SDK can be used to fetch transaction data for a Solana address in a NodeJs application.After creating your project install sdk to your project:<pre><code class="language-javascript">yarn add @flipsidecrypto/sdk </code></pre>Or if you are using npm<pre><code class="language-javascript">npm install @flipsidecrypto/sdk </code></pre>Let’s get started:Import the required dependencies:&nbsp;<pre><code class="language-javascript">import { Flipside, Query, QueryResultSet } from "@flipsidecrypto/sdk" </code></pre>Note: you may need to change path from<pre><code class="language-javascript">"@flipsidecrypto/sdk" </code></pre>to<pre><code class="language-javascript">"@flipsidecrypto/sdk/dist/src" </code></pre>as there is some issue with imports in version 1.1.1.Initialize <code>Flipside</code> with your API key<pre><code class="language-javascript"> const flipside = new Flipside(
 &nbsp; "&lt;YOUR_API_KEY&gt;",
 &nbsp; "https://node-api.flipsidecrypto.com"
 ); &nbsp; </code></pre>Getting API key:To get the api key go to https://sdk.flipsidecrypto.xyz/shroomdk then sign up or login to your account then you can connect your wallet to get the api keys.Your crypto address on which you want to fetch transaction:<pre><code class="language-javascript">const myAddress = "0x...." </code></pre>Create a query object for the <code>query.run</code> function to execute<pre><code class="language-javascript"> const query: Query = {
 &nbsp; sql: `SELECT * FROM SOLANA.core.fact_transfers WHERE (tx_from = '${address}' OR tx_to = '${address}')`,
 ttlMinutes: 10,
 };
 </code></pre>Send the <code>Query</code> to Flipside's query engine and await the results<pre><code class="language-javascript">const result: QueryResultSet = await flipside.query.run(query); </code></pre>The&nbsp;Query&nbsp;object contains both the sql and configuration you can send to the query engine for execution. You can find other parameters which you can modify according to your desired output.<pre><code class="language-javascript"> type Query = {
 // SQL query to execute
 sql: string;
 // The number of minutes to cache the query results
 ttlMinutes?: number;
 // An override on the query result cache.
 // A value of false will re-execute the query.
 cached?: boolean;
 
 // The number of minutes until your query run times out
 timeoutMinutes?: number;
 
 // The number of rows to return from the query result set.
 // If not specified this defaults to 100k. A max of 1m rows/records 
 // will be cached and can be paged thru using the pageNumber parameter.
 pageSize?: number;
 
 // The page to retrieve cached query results from.
 // The default (if not specified) is 1.
 pageNumber?: number;
 };
 </code></pre>In the end this is the hello.ts file that worked for me:<pre><code class="language-javascript"> import express, { Request, Response } from "express";
 import Cors from "cors";
 import { Flipside, Query, QueryResultSet } from "@flipsidecrypto/sdk/dist/src";
 
 const app = express();
 const port = 3009;
 app.use(
 Cors({
 origin: "*",
 methods: "GET,HEAD,PUT,PATCH,POST,DELETE",
 })
 );
 // add json middleware
 app.use(express.json());
 
 app.get("/test", async (req: Request, res: Response) =&gt; {
 const flipside = new Flipside(
 "",
 "https://node-api.flipsidecrypto.com"
 );
 const address = 
 
 //blockchain address : you can use one from https://solscan.io/txs
 
 let queryStr = `SELECT * FROM SOLANA.core.fact_transfers WHERE (tx_from = '${address}' OR tx_to = '${address}')`;
 const query: Query = {
 sql: queryStr,
 ttlMinutes: 10,
 pageSize: 10,
 pageNumber: 1,
 };
 
 const result: QueryResultSet = await flipside.query.run(query);
 
 res.status(200).send({
 data: result,
 });
 });
 
 app.listen(port);</code></pre>

How to use Tailwind with React and create stunning components

About Page

Blog Page

How to use Tailwind with React and create stunning components

Implementation of Web Biometric Authentication on React + Node js

Fetch solana transaction

How to manage state in react

Fetch solana transaction