Business Data with Node.js

For this guide, we're going to assume you're interested in using Datafiniti's business data to do some marketing analysis on hotels. Let's say you're a data scientist that's been tasked with the following:

Collect data on hotels.
Sort the data by state.
Find which states have the most hotels.

Your environment and data needs:

You're working with Node.js.
You want to work with CSV or JSON data.

Here are the steps we'll take:

1. Install the request module for Node

In your terminal, run the following to install the request module for Node:

npm install request

2. Get your API token

The next thing you'll need is your API token. The API token lets you authenticate with Datafiniti API and tells it who you are, what you have access to, and so on. Without it, you can't use the API.

To get your API token, go the Datafiniti Web Portal (https://portal.datafiniti.co), login, and click your settings in the left navigation bar. From there, you'll see a page showing your token. Your API token will be a long string of letters and numbers. Copy the API token or store it somewhere you can easily reference.

For security reasons, your API token will be automatically changed whenever you change your password.

📘
API_key in code
For the rest of this document, we'll use AAAXXXXXXXXXXXX as a substitute example for your actual API token when showing example API calls.

3. Run your first search

The first thing we'll do is do write some code that will run a test search. This test search will give us a sense for what sort of data might be available. Eventually we'll refine our search so that we get back the most relevant data.

Since we want hotels, let's try a simple search that will just give us online listings for hotels.

Write the following code in your code editor (replace the dummy API token with your real API token):

/*
  Illustrates an API call to Datafiniti's Business Database for hotels.
*/
var request = require('request');

// Set your API parameters here.
var API_token = 'AAAXXXXXXXX';
// var format = 'CSV';
var format = 'JSON';
var query = 'categories:hotels';
var num_records = 1;
var download = false;

var request_options = {
  url: 'https://api.datafiniti.co/v4/businesses/search',
  method: 'POST',
  json: {
    'query': query,
    'format': format,
    'num_records': num_records,
    'download': download
  },
  headers: {
    'Authorization': 'Bearer ' + API_token,
    'Content-Type': 'application/json'
  }
}

console.log(request_options);

// Make the API call.
request(request_options, function(error, response, body) {
  if (error) {
    console.log(error);
    console.log(response);
  } else {
    console.log(body);
  }
});

You should get a response similar to this:

{
  "num_found": 139666,
  "total_cost": 1,
  "records": [
    {
      "address": "7030 Amin Dr",
      "categories": [
        "Hotels"
      ],
      "city": "Chattanooga",
      "country": "US",
      "dateAdded": "2016-11-04T23:50:14Z",
      "dateUpdated": "2016-11-04T23:50:14Z",
      "descriptions": [
        {
          "dateSeen": [
            "2016-11-09T19:26:53Z"
          ],
          "sourceURLs": [
            "http://www.hotels.com/ho141351/?locale=en_US&pos=HCOM_US"
          ],
          "value": "No-frills hotel in Hamilton Place with health club"
        }
      ],
      "features": [
        {
          "key": "Services",
          "value": [
            "24-hour front desk, Dry cleaning/laundry service, Laundry facilities, Free newspapers in lobby"
          ]
        },
        {
          "key": "Nearby Attractions",
          "value": [
            "[In Hamilton Place, Hamilton Place Mall (1.1 mi / 1.7 km), Dragon Dreams Museum (2.7 mi / 4.4 km), Tennessee Valley Railroad Museum (3.6 mi / 5.8 km), Concord Golf Club (3.8 mi / 6 km), Brown Acres Golf Course (4 mi / 6.5 km)]"
          ]
        }
      ],
      "imageURLs": [
        "https://exp.cdn-hotels.com/hotels/1000000/120000/117400/117332/117332_95_n.jpg",
        "https://exp.cdn-hotels.com/hotels/1000000/120000/117400/117332/117332_107_n.jpg"
      ],
      "keys": [
        "us/tn/chattanooga/7030amindr/1104338646"
      ],
      "latitude": "35.04281",
      "longitude": "-85.158",
      "name": "Mainstay Suites Chattanooga",
      "numRoom": 77,
      "phones": [
        "8004916126"
      ],
      "postalCode": "37421",
      "province": "TN",
      "reviews": [
        {
          "date": "2013-11-11T00:00:00Z",
          "dateAdded": "2016-11-04T23:50:14Z",
          "dateSeen": [
            "2016-11-06T00:00:00Z",
            "2016-08-12T00:00:00Z"
          ],
          "rating": 2,
          "sourceURLs": [
            "https://www.hotels.com/hotel/141351/reviews%20/"
          ],
          "text": "Hotel was ok. Room not as up to date as I expected.",
          "title": "Was ok",
          "username": "A Traveler"
        },
        {
          "date": "2014-11-03T00:00:00Z",
          "dateAdded": "2016-11-04T23:50:14Z",
          "dateSeen": [
            "2016-08-09T00:00:00Z",
            "2016-08-27T00:00:00Z",
            "2016-07-18T00:00:00Z"
          ],
          "rating": 3,
          "sourceURLs": [
            "https://www.hotels.com/hotel/141351/reviews%20/"
          ],
          "text": "It was adequate for our one night stay there. Staff was very friendly and the room was clean but not very big. I would recommend to someone for a very short stay.",
          "username": "scott"
        }
      ],
      "sourceURLs": [
        "http://www.hotels.com/ho141351/?locale=en_US&pos=HCOM_US",
        "https://www.hotels.com/hotel/141351/reviews%20/"
      ],
      "id": "AVwcsllU_7pvs4fzx-yW"
    }
  ]

Let's break down each of the parameters we sent in our request:

API Call Component	Description
`"query": "categories:hotels"`	`query` tells the API what you want to search. In this case, you're telling the API you want to search by `categories`. Any business that has `hotels` listed in its `categories` field will be returned.
`"num_records": 1`	`num_records` tells the API how many records to return in its response. In this case, you just want to see 1 matching record.
`"format":"xxxx"`	`"format"` tells the API what format to output the data in the response. Can be either `CSV` or `JSON`

Now let's dive through the response the API returned:

Response Field	Description
`"num_found"`	The total number of available records in the database that match your query. If you end up downloading the entire data set, this is how many records you'll use.
`"total_cost"`	The number of credits this request has cost you. Business records only cost 1 credit per record.
`"records"`	The first available matches to your query. If there are no matches, this field will be empty. Within each record returned, you'll see multiple fields shown. This is the data for each record.

Within the records field, you'll see a single business returned with multiple fields and the values associated with that business. The JSON response will show all fields that have a value. It won't show any fields that don't have a value.

Each business record will have multiple fields associated with it. You can see a full list of available fields in our Business Data Schema.

4. Refine your search

If you think about the original query we made, you'll realize we didn't really specify which geography we're interested in. Since we only want US hotels, we should narrow our search appropriately. Modify your code to look like this:

/*
  Illustrates an API call to Datafiniti's Business Database for hotels.
*/
var request = require('request');

// Set your API parameters here.
var API_token = 'AAAXXXXXXXX';
var format = 'CSV';
var query = 'categories:hotels AND country:US';
var num_records = 10;
var download = false;

var request_options = {
  url: 'https://api.datafiniti.co/v4/businesses/search',
  method: 'POST',
  json: {
    'query': query,
    'format': format,
    'num_records': num_records,
    'download': download
  },
  headers: {
    'Authorization': 'Bearer ' + API_token,
    'Content-Type': 'application/json'
  }
}

console.log(request_options);

// Make the API call.
request(request_options, function(error, response, body) {
  if (error) {
    console.log(error);
    console.log(response);
  } else {
    console.log(body);
  }
});

This code is different in a couple ways:

It adds AND country:US to narrow down results to just US hotels.
It sets num_records to 10 so we can look at more sample matches.
It changes the format from json to csv.

Datafiniti lets you construct very refined boolean queries. If you wanted to do more complicated searches, you could use OR operations, negation, and more.

5. Initiate a download of the data

Once we like what we see from the sample matches, it's time to download a larger data set! To do this, we're going to update our code a fair bit (an explanation follows):

🚧
Num_records not specified
When using the API, you will not receive any warning if you are going past your monthly record limit. Keep a track on how many records you have left by checking your account. You are responsible for any overage fees if you go past your monthly limit.

Since we've handled multiple steps of the download process in this code, we won't go into the details here, but we do recommend you familiarize yourself with those steps. Checking them out in our Business Data with Postman and CSV

🚧
Credit limit monitoring
When using the API, you will not receive any warning if you are going past your monthly record limit. Keep a track on how many records you have left by checking your account. You are responsible for monitoring your monthly limit. To learn more about your credit limit please review How Credits Work.

/*
  Illustrates an API call to Datafiniti's Business Database for hotels.
*/
var request = require('request');
var fs = require('fs');

// Set your API parameters here.
var API_token = 'AAAXXXXXXXX';
var view = 'business_basic';
var format = 'JSON';
var query = 'categories:hotels AND country:US';
var num_records = 50;
var download = true;

var request_options = {
  url: 'https://api.datafiniti.co/v4/businesses/search',
  method: 'POST',
  json: {
    'query': query,
    'num_records': num_records,
    'view': view,
    'format': format,
    'download': download
  },
  headers: {
    'Authorization': 'Bearer ' + API_token,
    'Content-Type': 'application/json'
  }
}

console.log(request_options);

// A function to check if a download request has completed
function checkDownloadUntilComplete(options, callback) {
  var download_id = options.download_id;
  var download_options = {
    url: 'https://api.datafiniti.co/v4/downloads/' + download_id,
    method: 'GET',
    headers: {
      'Authorization': 'Bearer ' + API_token,
      'Content-Type': 'application/json'
    }
  }

  request(download_options, function(error, response, body) {
    var num_files_downloaded = 0;
    var download_response = JSON.parse(body);
    console.log('Records downloaded: ' + download_response.num_downloaded);
    if (download_response.status !== 'completed') {
      // NEED A SLEEP FUNCTION HERE!
      checkDownloadUntilComplete(options, callback);
    } else {
      var results = download_response.results;
      console.log(results);
      for (var i = 0; i < results.length; i++) {
        var filename = download_id + '_' + i + '.' + format;
        var file = fs.createWriteStream(filename);
        request(results[i]).pipe(file).on('end', function() {
          console.log('File ' + (i+1) + ' out of ' + results.length + ' saved: ' + filename);
          num_files_downloaded++;
          if (num_files_downloaded === results.length) process.exit();
        });
      }
    }
  });
}

// Initiate the download request.
request(request_options, function (error, response, body) {
    var request_response = body;
    var download_id = request_response.id;

    // Check on status of the download request.
    checkDownloadUntilComplete ({download_id : download_id}, function (error, response) {});
  }
);

A few things to pay attention to in the above code:

We change num_records from 10 to 50. This will download the first 50 matching records. If we wanted to download all matching records, we would remove num_records.
We set the view to business_basic. This will nest fields like categories and features into a single cell (instead splitting them across multiple rows and columns).
We changed download from false to true.

🚧
Num_records
If num_records is not specified, ALL of the records matching the query will be downloaded.

6. Checking your download status

You will be presented with a response JSON different from the previous download being false. Whenever your download is true, Datafiniti will provide a download ID in the response file along with your credits used and a status. Below is an example of the response of your property search API. You can gather the following fields from the response JSON:

status - your status can be: completed, cancelled, queued, or running
num_downloaded - you show the amount of records download so far
property_cost - cost of credit for this download, will update once status = completed
ID - most important to track your download.

{
    "status": "queued",
    "num_downloaded": 0,
    "num_records_suppressed": 0,
    "people_cost": 0,
    "property_cost": 0,
    "product_cost": 0,
    "business_cost": 0,
    "total_cost": 0,
    "fields": [
        {
            "name": "address"
        },
        {
            "name": "apiURLs",
            "flatten": false
        },
        {
            "name": "careerPageURL"
        },
        {
            "name": "categories",
            "flatten": false
        },
        {
            "name": "city"
        },
        {
            "name": "claimed",
            "flatten": false
        },
        {
            "name": "country"
        },
        {
            "name": "cuisines",
            "flatten": false
        },
        {
            "name": "dateAdded"
        },
        {
            "name": "dateUpdated"
        },
        {
            "name": "descriptions",
            "flatten": false
        },
        {
            "name": "domains",
            "flatten": false
        },
        {
            "name": "emails",
            "flatten": false
        },
        {
            "name": "facebookPageURL"
        },
        {
            "name": "faxes",
            "flatten": false
        },
        {
            "name": "features",
            "flatten": false
        },
        {
            "name": "geoLocation"
        },
        {
            "name": "hours",
            "flatten": false
        },
        {
            "name": "imageURLs",
            "flatten": false
        },
        {
            "name": "isClosed"
        },
        {
            "name": "keys",
            "flatten": false
        },
        {
            "name": "languagesSpoken",
            "flatten": false
        },
        {
            "name": "latitude"
        },
        {
            "name": "longitude"
        },
        {
            "name": "menuPageURL"
        },
        {
            "name": "menus",
            "flatten": false
        },
        {
            "name": "name"
        },
        {
            "name": "neighborhoods",
            "flatten": false
        },
        {
            "name": "numEmployeesMin"
        },
        {
            "name": "numEmployeesMax"
        },
        {
            "name": "numRoom"
        },
        {
            "name": "ownershipType"
        },
        {
            "name": "paymentTypes",
            "flatten": false
        },
        {
            "name": "people",
            "flatten": false
        },
        {
            "name": "phones",
            "flatten": false
        },
        {
            "name": "postalCode"
        },
        {
            "name": "priceRangeCurrency"
        },
        {
            "name": "priceRangeMin"
        },
        {
            "name": "priceRangeMax"
        },
        {
            "name": "primaryCategories",
            "flatten": false
        },
        {
            "name": "productsOrServices",
            "flatten": false
        },
        {
            "name": "province"
        },
        {
            "name": "revenueCurrency"
        },
        {
            "name": "revenueMin"
        },
        {
            "name": "revenueMax"
        },
        {
            "name": "reviews",
            "flatten": false
        },
        {
            "name": "rooms",
            "flatten": false
        },
        {
            "name": "sic"
        },
        {
            "name": "sourceURLs",
            "flatten": false
        },
        {
            "name": "stockSymbol"
        },
        {
            "name": "technologiesUsed",
            "flatten": false
        },
        {
            "name": "twitter"
        },
        {
            "name": "websites",
            "flatten": false
        },
        {
            "name": "yearIncorporated"
        },
        {
            "name": "yearOpened"
        }
    ],
    "sort": true,
    "auto_trace": false,
    "only_traceable": false,
    "format": "csv",
    "suppressed_fields": [],
    "enriched_fields": [],
    "query": "categories:shoes AND -categories:shirts AND categories:women AND (brand:* OR manufacturer:*) AND prices:*",
    "num_records": 50,
    "data_type": "product",
    "user": 126609,
    "results": [],
    "date_started": "2025-04-09T20:32:22.163Z",
    "date_updated": "2025-04-09T20:32:22.163Z",
    "_id": 847070,
    "is_suppression_job": false,
    "is_enrichment_job": false,
    "id": "847070"
}

You can track the status of your download via the following method using our GET https://api.datafiniti.co/v4/downloads/:id endpoint

Track your download via the API

The following code can be used to track your download ID:

const axios = require('axios');

const url = 'https://api.datafiniti.co/v4/downloads/811043?api_key=<your_API_key>';
const headers = {
  'Authorization': 'Bearer <your_API_key>',
  'accept': 'application/json'
};

axios.get(url, { headers, timeout: 30000 })
  .then(response => {
    console.log(response.data);
  })
  .catch(error => {
    console.error('Request Error:', error.message);
  });

The response of your code will provide you with the following JSON:

{
  "status": "completed",
  "num_downloaded": 50,
  "num_records_suppressed": 0,
  "people_cost": 0,
  "property_cost": 0,
  "product_cost": 0,
  "business_cost": 50,
  "total_cost": 50,
  "sort": true,
  "auto_trace": false,
  "only_traceable": false,
  "format": "csv",
  "suppressed_fields": [],
  "enriched_fields": [],
  "_id": 710516,
  "query": "categories:hotels AND country:US",
  "num_records": 50,
  "data_type": "business",
  "user": 1226609,
  "results": [
    "https://datafiniti-downloads.s3.amazonaws.com/126609/811043_1.csv?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20250317T200355Z&X-Amz-SignedHeaders=host&X-Amz-Expires=604800&X-Amz-Credential=AKIAZSCI425AD5EKHVNH%2F20250317%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=4c14da1d1df9eb490a0ab7c329b6f60f87c87edda2fe3b1a3dc857ea6e639sdfas6dc"
  ],
  "date_started": "2025-03-17T20:00:46.733Z",
  "date_updated": "2025-03-17T20:03:55.926Z",
  "is_suppression_job": false,
  "is_enrichment_job": false,
  "id": "847070"
}

Track your download via the portal

You can track the status of your Datafiniti download via the portal in the download page here.
For more information please read our Downloading Result Files.
You can match the ID from your API response to the download ID on the page here:

Track via our reference page

You can track the status of your Datafiniti download via the API reference page Get a Download. You can match the ID from your API response to the download ID on the page here:

7. Parse the data

Open the result file(s) in Excel

The download code will save one or more result files to your project folder. Open one of those files in Excel. It will look something like:

Parse the JSON data

The download code will save one or more result files to your project folder.

📘
JSON format download
The JSON data will actually be a text file, instead of a single JSON object. Each line in the text file is a JSON object. We format the data this way because most programming languages won't handle parsing the entire data set as a JSON object with their standard system calls very well.

We'll need to parse the file into an array of JSON objects. We can use code similar to this to handle the parsing:

var fs = require('fs');

// Set the location of your file here.
var file = 'xxxx_x.txt';

// A function to read in each line of the file and pass that line to func
function readLines(input, func) {
	var records = [];
	var remaining = '';

	input.on('data', function(data) {
 		remaining += data;
		var index = remaining.indexOf('\n');
		var last  = 0;
		while (index > -1) {
 			var line = remaining.substring(last, index);
 			last = index + 1;
 			func(line, records);
			index = remaining.indexOf('\n', last);
 		}

 		remaining = remaining.substring(last);
	});

	input.on('end', function() {
 		if (remaining.length > 0) {
 			func(remaining, records);
 		}
		processData(records);
	});
}

// A function that converts a line from the file, parses it to JSON, and stores it an array
function func(data, records) {
	var json = JSON.parse(data);
	records.push(json);
}

// This function is called once all the data has been read from the file.
function processData(records) {
	// Edit these lines to do more with the data.
	console.log(records);
}

var records = [];
var input = fs.createReadStream(file);
readLines(input, func);

You can edit the code in processData above to do whatever you'd like with the data, such as store the data in a database, write it out to your console, etc.

Business Data with Node.js

1. Install the request module for Node

2. Get your API token

📘
API_key in code

3. Run your first search

4. Refine your search

5. Initiate a download of the data

🚧
Num_records not specified

🚧
Credit limit monitoring

🚧
Num_records

6. Checking your download status

Track your download via the API

Track your download via the portal

Track via our reference page

7. Parse the data

Open the result file(s) in Excel

Parse the JSON data

📘
JSON format download

1. Install the request module for Node

2. Get your API token

📘API_key in code

3. Run your first search

4. Refine your search

5. Initiate a download of the data

🚧Num_records not specified

🚧Credit limit monitoring

🚧Num_records

6. Checking your download status

Track your download via the API

Track your download via the portal

Track via our reference page

7. Parse the data

Open the result file(s) in Excel

Parse the JSON data

📘JSON format download

📘
API_key in code

🚧
Num_records not specified

🚧
Credit limit monitoring

🚧
Num_records

📘
JSON format download