Constructing Advanced Business Data Queries in Postman
This will walk you through querying the Business Database using Postman!
1. Select the Business Database
![1.jpg 2560](https://files.readme.io/4ce1624-1.jpg)
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
![3.jpg 2560](https://files.readme.io/6157a11-3.jpg)
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
![4.jpg 2560](https://files.readme.io/9545575-4.jpg)
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
![5---2.jpg 2560](https://files.readme.io/6ecbf86-5---2.jpg)
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
![6.jpg 2560](https://files.readme.io/e88bdae-6.jpg)
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
![7.jpg 2560](https://files.readme.io/8950e11-7.jpg)
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
![8.jpg 2560](https://files.readme.io/6237005-8.jpg)
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.
Updated 10 months ago