SlicingDice Documentation

SlicingDice API Docs

Welcome to the SlicingDice API 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

Column creation tool

At SlicingDice we work hard to make our documentation and API simpler and easier to understand and use. This is why we created this interactive column creation tool below.

You can use this tool to better understand how to create any type of column on SlicingDice.

In order to use this tool you only need to add columns and their types in the spreadsheet below and a column creation API command will be dynamically generated for you, based on the columns present on the spreadsheet. If you already have a JSON column creation command and you want to validate if it is correct, paste the JSON below and the spreadsheet will automatically represent your columns.

Data insertion and query demo tool

Check also our query demo tool or insertion demo tool to dynamically create examples of insertion / queries based on demo data.

Usage instructions:
There are two ways of using this tool: automatic data type identification or manually defining the column's data types.

  1. Automatic data type identification for the column creation using some data on the spreadsheet, as described on the columns auto creation documentation.

    • Use the first row of the spreadsheet for the column's names.
    • For an event column, you can insert multiple events for the same column, by adding a new line (Crtl + Enter) inside the same cell, as shown on the clicks event column below. Use this format New York - 2017-05-09T12:54:12Z to define the value (New York) and the date/time (2017-05-09T12:54:12Z) for the event.
    • For an attribute column containing a list of values, you only need to insert one value per line, inside the same cell, as shown on the visited-cities attribute column below.
    • You can also insert new columns and rows in the spreadsheet by right-clicking it.
  1. Adding columns and manually defining their data types, using the second row of the spreadsheet.

    • Use the first row of the spreadsheet for the column's name.
    • Use the second row of the spreadsheet for the column's API name.
    • Use the third row of the spreadsheet for the column's description (optional).
    • Use the fourth row of the spreadsheet for the column's data type, that can be one of the values from the list: string, string-event, integer, integer-event, decimal, decimal-event, boolean, date, unique-id or enumerated.
    • For an attribute column, use the sixth row of the spreadsheet to define the column's storage, that can either be a list-of-values or the latest-value.
    • You can also insert new columns in the spreadsheet by right-clicking it.

Please, select the way you prefer to use this tool using the Tool mode select box below.

Column creation tool