Download csv without abbreviating 1,000,000 into 1M

GraphQL API
1

Hello
I am trying to download tx amount, when usng this query and downloading results as csv i get 1,000,000 abbreviated to 1M and 1,000,000,000 abbreviated into 1G, is there a way to get the exact number without abbreviation?

                    query ($network: EthereumNetwork!,
                            $address: String!,
                            $limit: Int!,
                            $offset: Int!
                            $from: ISO8601DateTime,
                            $till: ISO8601DateTime){
                ethereum(network: $network){
                  transfers(options:{desc: "block.timestamp.time"  asc: "currency.symbol" limit: $limit, offset: $offset},
                    date: {since: $from till: $till },
                    amount: {gt: 0},
                    sender: {is: $address}) {

                    block {
                      timestamp {
                        time (format: "%Y-%m-%d %H:%M:%S")
                      }
                      height
                    }
                    address: receiver {
                      address
                      annotation
                    }
                    currency {
                      address
                      symbol
                    }
                    amount
                    transaction {
                      hash
                    }
                    external
                  }
                }
              }
2

firefox_yTo0nijUr7
firefox_yTo0nijUr71517×836 57.1 KB

when pressing play in query editor it shows whole number without abbreviation but when pressing apply and download csv file its abbreviated.
thanks for any help

3

Yes, it’s a UI thing, you can write a simple JS code that will solve this.

@sayon Please create a tutorial on how to get Bitquery API data as CSV. Also share simple JS code.

4

I’ll start right away with the same

5 
const FileSystem = require('fs')
const { writeFile } = require('fs').promises;
const fetch = require('node-fetch')

function convertJSONTOCSV(objArray){
    var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
    var str = '';
    for (var i = 0; i < array.length; i++) {
        var line = '';
        for (var index in array[i]) {
            if (line != '') {line += ','}
            line += array[i][index];
        }
        str += line + '\r\n';
    }
    return str;
}

async function writeCSV (fileName, data) {
  try {
  	await writeFile(fileName, data, 'utf8'); 
  } catch (err) {
    console.log(err);
  }
}

async function generateCSV(){
	const query = `YOUR GRAPHQL QUERY `;
	const url = "https://graphql.bitquery.io/";
	const opts = {
	    method: "POST",
	    headers: {
	        "Content-Type": "application/json",
	      	"X-API-KEY": "YOUR UNIQUE API KEY"
	    },
	    body: JSON.stringify({
	        query
	    })
	};
	const results = await fetch(url, opts).then(res => res.json())
	
	const objectArray = results.data.ethereum.dexTrades

	// data in JSON format
	// console.log(objectArray.map(it=>console.log(it)))

	const jsonObject = JSON.stringify(objectArray)
	const data = convertJSONTOCSV(jsonObject)
	writeCSV('results.csv', data)
}

generateCSV();