Postman: Business Data

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

1. Select the Business Database

Click on "Search Business Data" to get started.Click on "Search Business Data" to get started.

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)".Click on the "Body" tab and make sure you have "Raw" selected and that your text is set to "JSON(application/JSON)".

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 "Body" window will have 2 fields in it already. Hitting "Send" will query the Business Database for all records with a ```key```.

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 values--tripadvisor.com and booking.com--as 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.You can search with different fields together inside the ```" "``` of your query string using ```AND``` or ```OR```. The ```( )``` tells the API to process both values--tripadvisor.com and booking.com--as 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.

You can search with different fields together inside the " " of your query string using AND or OR. The ( ) tells the API to process both values--tripadvisor.com and booking.com--as 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.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.

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.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.

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.

๐Ÿ“˜

View

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!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!

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.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.

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.