OData URIs
From Lianjapedia
Revision as of 08:11, 1 February 2017 by Yvonne.milne (Talk | contribs)
Under Construction
See Also
OData Operators, ODATA_CREATE(), ODATA_DELETE(), ODATA_READ(), ODATA_UPDATE(), Working with JSON and JQL,Working with OData in Lianja Cloud Server
OData URIs
The following arguments are available:
Argument | Description | Example |
---|---|---|
$callback | Specify a callback function that will wrap the data returned. This is used with JSONP calls to bypass SOP issues in the browser |
$callback=your_javascript_function |
$count | Don't return any data just tell me how many records would have been selected | $count |
$filter | Selects only those records that match the specified filter | $filter=contactname eq 'A' and amount gt 0 |
$format | The output format | $format=ado $format=attachment $format=csv $format=excel $format=html $format=img $format=json $format=jsonarray $format=jsongrid |
$metadata | Returns metadata describing the columns in the table; name, type, width and decimals. | $metadata |
$nocount | Don't return the __count member which details the total number of rows that match the query. This improves performance on Virtual Tables |
$nocount |
$orderby | Specify a column or expression that the data should be ordered by | $orderby=contactname |
$rowid | Add the unique rowid into the output ( __rowid ) which can be used to update data later | $rowid |
$select | Selects only the specified columns (or expressions) | $select=customerid,contactname |
$skip | Skips a number of selected records | $skip=50 |
$sql | Evaluate a SQL SELECT statement directly and return the results. | $sql=select * from customers |
$top | Selects the specified number of records | $top=10 |