Postman: Business Data

Get Business Records from the Database

Video Walkthrough

This video will show you how to use the Datafiniti API collection in Postman to search our extensive database for Business records!


Business Data Schema

You can find a full list of the business data schema fields in our developer docs.

Visual Step-By-Step Walkthrough

This will walk you through querying the Business Database using Postman!

1. Select the Business Database


Click on "Search Business Data" to get started.

2. Setting the Stage


Click on the "Body" tab and make sure you have "Raw" selected and that your text is set to "JSON(application/JSON)".

3. Running a Query


The "Body" window will have 2 fields in it already. Hitting "Send" will query the Business Database for all records with a key.


The "Wild Card"

Using * in your query will search for any possible value that could fill that spot. In the above case, it is essentially saying "Find all records that have a key value set to anything"

You can query the database using most of the fields in the Business Data Schema.

4. Narrowing The Search


You can search with different fields together inside the " " of your query string using AND or OR. The ( ) tells the API to process both and the sourceURLs of the record. Because they are connected with OR, we will see records that have one or the other. Had we used AND, only records with both sourceURLs would be shown.

5. Using "" Inside the Query String


To refine your query more, you may want to search for a specific word and not allow for any variations on it. To do that, you put it inside quotes. However, because you are already inside the main quotes of your string, you need to escape the new quotes by adding \ in front of each " inside the main quotation marks. See the treatment of \"Torchy's\" in the above example for clarification.

6. Additional Specifications


In addition to the "query" and "num_records", there are other values you can specify in the body text. You can set "download" to either be true or false, "format" to either be "CSV" or "JSON", and you can call any "view" you have saved to your account.



Setting your "view" not only changes the layout of your result file, but also changes how you see the records in Postman.

7. Custom Views on the Fly


If you'd like to create a custom view that you don't want to save, you can customize it inside the "view" field before running your query!


Custom View Formatting

When creating the "view" object, put the entire thing inside of [ ], with each field being called inside of { }. If you are listing multiple fields, put a comma after each one except for the last one. See the screenshot above for an example.

8. Getting Your Download ID


When you send the request with a "download": true it will start downloading your files. You will need your download ID to access them, which you can find here.