Data Tables Actions#

https://api.losant.com/applications/APPLICATION_ID/data-tables

Below are the various requests that can be performed against the Data Tables resource, as well as the expected parameters and the potential responses.

Get#

Returns the data tables for an application

Method And Url #

GET https://api.losant.com/applications/APPLICATION_ID/data-tables

Authentication #

A valid api access token is required to access this endpoint. The token must include at least one of the following scopes: all.Application, all.Application.read, all.Organization, all.Organization.read, all.User, all.User.read, dataTables.*, or dataTables.get.

Request Path Components #

Path Component	Description	Example
APPLICATION_ID	ID associated with the application	575ec8687ae143cd83dc4a97

Request Query Parameters #

Name	Required	Description	Default	Example
sortField	N	Field to sort the results by. Accepted values are: name, id, creationDate, lastUpdated	name	sortField=name
sortDirection	N	Direction to sort the results by. Accepted values are: asc, desc	asc	sortDirection=asc
page	N	Which page of results to return	0	page=0
perPage	N	How many items to return per page	1000	perPage=10
filterField	N	Field to filter the results by. Blank or not provided means no filtering. Accepted values are: name		filterField=name
filter	N	Filter to apply against the filtered field. Supports globbing. Blank or not provided means no filtering.		filter=my*table

Request Headers #

Name	Required	Description	Default
Authorization	Y	The token for authenticating the request, prepended with Bearer

Curl Example #

curl -H 'Content-Type: application/json' \
    -H 'Accept: application/json' \
    -H 'Authorization: Bearer YOUR_API_ACCESS_TOKEN' \
    -X GET \
    https://api.losant.com/applications/APPLICATION_ID/data-tables

Successful Responses #

Code	Type	Description
200	Data Tables	Collection of data tables

Error Responses #

Code	Type	Description
400	Error	Error if malformed request
404	Error	Error if application was not found

Post#

Create a new data table for an application

Method And Url #

POST https://api.losant.com/applications/APPLICATION_ID/data-tables

Authentication #

A valid api access token is required to access this endpoint. The token must include at least one of the following scopes: all.Application, all.Organization, all.User, dataTables.*, or dataTables.post.

Request Path Components #

Path Component	Description	Example
APPLICATION_ID	ID associated with the application	575ec8687ae143cd83dc4a97

Request Headers #

Name	Required	Description	Default
Authorization	Y	The token for authenticating the request, prepended with Bearer

Request Body #

The body of the request should be serialized JSON that validates against the Data Table Post schema. For example, the following would be a valid body for this request:

{
  "name": "My Data Table",
  "columns": [
    {
      "name": "myColumn1",
      "dataType": "string",
      "constraint": "unique"
    }
  ]
}

Curl Example #

curl -H 'Content-Type: application/json' \
    -H 'Accept: application/json' \
    -H 'Authorization: Bearer YOUR_API_ACCESS_TOKEN' \
    -X POST \
    -d '{"name":"My Data Table","columns":[{"name":"myColumn1","dataType":"string","constraint":"unique"}]}' \
    https://api.losant.com/applications/APPLICATION_ID/data-tables

Successful Responses #

Code	Type	Description
201	Data Table	Successfully created data table

Error Responses #

Code	Type	Description
400	Error	Error if malformed request
404	Error	Error if application was not found