Supported OData Features for SAP Mobile Add-On

The following table lists the OData features that SAP Mobile Add-On supports.

OData Feature

Status

Create

Maps to HTTP POST method

Read

Maps to HTTP GET method

Update

Maps to HTTP PUT method

Delete

Maps to HTTP DELETE method

Query

Maps to HTTP GET method

$select

Specifies a subset of properties to return

$top

Determines the maximum number of records to return

$skip

Sets the number of records to skip before it retrieves records in a collection

$filter

Specifies an expression or function that must evaluate to true for a record to return to the collection

$count

Returns the number of records in a collection

$orderby

Determines which values are used to order a collection of records

$expand

Specifies that related records must be retrieved in line with the record or collection being retrieved. For example, use $expand to retrieve a customer and all orders placed by that customer in a single query.

$inlinecount

Supported

$skiptoken

Supported

$format

Supported

Navigation

Supported

Delta token

Supported

Tombstone

Supported

Complex types

Supported

$batch

Supported

Deep insert

Supported via single post operation and through $batch request using content ID referencing

Custom query options

Not supported

$link

Not supported

$value (media links or attachments)

Supported

ETags / concurrency control

Supported

$filter Details

String functions

  • Supported:

    • bool substringof(string p0, string p1)

  • Not Supported:

    • string trim(string p0)

    • string concat(string p0, string p1)

    • int length(string p0)

    • int indexof(string p0, string p1)

    • string replace(string p0, string find, string replace)

    • bool endswith(string p0, string p1)

    • bool startswith(string p0, string p1)

    • string toupper(string p0)

    • string substring(string p0, int pos)

    • string substring(string p0, int pos, int length)

    • string tolower(string p0)

Partially supported

Date functions

Not supported

Math functions

Not supported

Arithmetic operators

Not supported

Type functions

Not supported

$filter supported on complex type properties within an entity