SlicingDice Documentation

SlicingDice - The All-in-One Solution Documentation

Welcome to the SlicingDice documentation. You'll find comprehensive guides and documentation to help you start working with SlicingDice as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    Guides

7. Query using the API

Analytics-focused queries

Below you can find all analytics-focused queries currently supported.

Count entities

Know how many unique entities you have in a particular dimension satisfy the query conditions.

Check documentation for count entities queries.

  • Endpoint: https://api.slicingdice.com/v1/query/count/entity

Count events

Know the number of times some data was inserted for event columns in a particular dimension.

Check documentation for count events queries.

  • Endpoint: https://api.slicingdice.com/v1/query/count/event

Aggregations

Generate insights from the data stored at SlicingDice by calculating metrics and crossing data from different columns to generate pivot tables.

Check documentation for aggregations queries.

  • Endpoint: https://api.slicingdice.com/v1/query/aggregation

Top values

Know what are the most common values for a specific column and how many times was the value inserted into it.

Check documentation for top values queries.

  • Endpoint: https://api.slicingdice.com/v1/query/top_values

Exists

Check whether the given entity IDs exist in a dimension.

Check documentation for exists queries.

  • Endpoint: https://api.slicingdice.com/v1/query/exists/entity

Total

Know how many unique entities you have in a particular set of dimensions (or in the whole database).

Check documentation for total queries.

  • Endpoint: https://api.slicingdice.com/v1/query/entity/total

Data extraction queries

Differently from analytics-focused queries, data extraction methods allow you to retrieve data stored from the database. Below you can find all data extraction queries currently supported.

Result

Allows you to retrieve data from columns you have stored.

Check documentation for result queries.

  • Endpoint: https://api.slicingdice.com/v1/data_extraction/result

Score

Allows you to retrieve data while receiving the entities' relative importance given a set of conditions.

Check documentation for score queries.

  • Endpoint: https://api.slicingdice.com/v1/data_extraction/score

Special queries

Geolocation

Allows you to retrieve geolocation data from geolocation columns you have stored.

Check documentation for geolocation queries.


Please note that API responses may be paginated to speed up data retrieval from the database. Check the pagination documentation to learn how to handle pagination.

Pro Tip

Remember that there is no cost for using test databases to make data insertions and queries before inserting real data to your production database.

Ready-to-use examples

All SlicingDice's clients/SDK has many ready-to-use examples on their Github repositories.
Check our client/SDK page to know more.