Difference between revisions of "ODATA READ()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
− | |||
==Purpose== | ==Purpose== | ||
OData-compatible function to read records | OData-compatible function to read records | ||
Line 23: | Line 22: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
+ | // Use URI arguments to select the required records | ||
+ | // Here 5 customers records are returned starting from record 10 | ||
+ | odata_read("/southwind/customers?$skip=10&$top=5") | ||
+ | |||
// OData-compatible functions | // OData-compatible functions | ||
odata_read("/southwind/shippers") | odata_read("/southwind/shippers") |
Revision as of 12:44, 1 February 2017
Contents
Purpose
OData-compatible function to read records
Syntax
ODATA_READ(<cURI> [,<cFilename>])
See Also
APPEND BLANK, APPEND FROM, APPEND FROM ARRAY, DELETE (NoSQL), DELETE (SQL), INSERT, JSON_DECODE(), JSON_DECODE_FILE(), JSON_ENCODE(), OData Operators, OData URIs, ODATA_CREATE(), ODATA_DELETE(), ODATA_UPDATE(), PRINT_JSON(), SELECT, UPDATE
Description
The ODATA_READ() function is used to read records. The data is returned as JSON.
Parameter | Required | Description |
---|---|---|
<cURI> | Yes | The OData URI - see OData URIs for full details. |
<cFilename> | No | Name of file to which data will be saved. |
Example
// Use URI arguments to select the required records // Here 5 customers records are returned starting from record 10 odata_read("/southwind/customers?$skip=10&$top=5") // OData-compatible functions odata_read("/southwind/shippers") odata_read("/southwind/shippers","readresults.txt") ? filetostr("readresults.txt") cCreateString = '{"shipperid":4,"companyname":"Acme Inc.","phone":"(503) 555-1234"}' odata_create("/southwind/shippers",cCreateString) odata_read("/southwind/shippers") cUpdateString = '{"phone":"(503) 555-5678", "__olddata":{"shipperid":4}}' odata_update("/southwind/shippers",cUpdateString) odata_read("/southwind/shippers") cDeleteString = '{"shipperid":4}' odata_delete("/southwind/shippers",cDeleteString) odata_read("/southwind/shippers")