Portal: Advanced Querying

How to Use More Schema Fields in the Portal

Datafiniti now has the all the schema fields available as both GUI inputs or API inputs. You can use either of our Filter Builder or API builder tool. Let's take a look!

1. Picking a Data Type

2. Writing Your Own URL Query

We can us this functionality to directly control the query with either relying on the "Feature Builder" GUI or query with exact API commands. For this example, let's say we want to get iPhone products, but don't want to have any products that are categorized as accessories or cases. Ordinarily, we wouldn't be able to set the filters via the portal filter builder, but by this can only be done by our API command builder

I've updated the query to reflect our needs by typing this directly into the address bar after query=:

name:(iphone) AND -categories:(accessor* OR case*)

3. Special Cases

Let's say you're looking for information on Burger Kings from the Business database. Since the name has two words in it, you would want to put it in quotes like name:"Burger King". This ensures that Datafiniti processes the name in its entirety, otherwise, you'll get results back that have Burger in the name OR King in the name.

Here is an example through the "Filter Builder":

Here is the same Example using the API Builder:

Lets say you want to search for places in Austin, Texas that were update as of January 2022. This can be done typically by adding a date range to the dateUpdated field with a beginning date and a wildcard end date. This will ensure that any record with that range will be populate in the results. Let's see how it can be done.

Here is an example through the "Filter Builder":

Here is an example through the API Builder:

Lets say you want to search for product from amazon where the review rating is above 4. This would use a greater than logic operator to define the reviews.rating to anything greater than 4. Let's see how it can be done.

Here is the example through the "Filter Builder":

Here is the same example with the API Builder: