Collections allow for storing different types of data in your IoT solution.
By going into our IoT System and clicking collections we can view our different data stores.
To create a collection click the “Add Collection” button and provide a name,type and source of data and click create.
Its possible to alter the schema of the collection by clicking Edit Columns. With the dialog open we can add columns to it. Enter a one word column name, and select the corresponding data type from the dropdown. Click Done when finished.
Now that schema is altered, lets add an item to the collection by clicking on the + add row button.
The new item has a unique item_id generated and the other columns are empty.We can then provide values for each item in the collection.To enter data into the row, click the cell corresponding to the row and column.
Each collection is available for users and devices to access via Portals, APIs and SDKs, but by default the collection has all access privileges turned off. By going to the settings on the collection we can provide update the associated role access. In this case we are going to give Authenticated users the ability to read, create, update and delete from this collection. Now we can use a very basic API call from a curl statement to access this collection. Notice the authtoken that is valid for authenticated user. When we submit this call we get back the full dataset, but if alter the key to be invalid the request will come back with security error
The user table can easily be filtered from the developer console. On the users page click the filter icon, select the column and the complete the filter criteria. Click filter and now see the data according your rules. To remove the filter, click the filter icon and choose “Clear All” and then reapply the filter.
Click “Delete Collection” and click Confirm when the prompt comes up.
Click on the gear next to the collection name and then click ‘Edit/View Details’
Remove an existing column:
WARNING: Data will be permanently deleted.
Go to ‘Edit Columns’ and click on the trashcan next to the column you want to delete
Remove an existing data row:
WARNING: Data will be permanently deleted. Click the checkmark icon to the left of the row that is to be deleted. Select “- Row” above the table display.
To delete all rows, click Delete all and confirm.