Introduction

The Open Data Protocol (OData) is a standard API that is used by many Business Intelligence tools, such as Power BI and Tableau, for accessing data. Smap is progressively adding support for OData and we encourage you to use it. Let us know if you find any limitations that you want addressed.

Smap supports version 4 of OData. Tableau Public Desktop for example only supports version 2. Hence when creating an OData service you can specify that an ODATA 2 compatible version be produced.

Data Types

Type	Supported	Smap Type	OData 2 Support	Alternative Provided
String	18.11+	text, select1
Int	18.11+	integer
Double	18.11+	decimal
Date	18.11+	date
DateTimeOffset	18.11+	datetime		Date. Time component is lost. The library we use to generate OData does not support the OData 2 DateTime type which includes time but not time zone.

Expand all relationships

Expand all links to other forms using *.

This is not currently supported by Smap.

Filters

Specify a filter on a request to get data using $filter.

This is not currently supported by Smap.

Limit Rows Returned

Limit the number of rows returned using $top.

This is not currently supported by Smap.

Limit Questions Returned

Limit the number of questions returned using $select.

This is not currently supported by Smap.