Get All

using RestSharp;


var options = new RestClientOptions("http://localhost:56350/api/v1/Product");
var client = new RestClient(options);
var request = new RestRequest("");
var response = await client.GetAsync(request);

Console.WriteLine("{0}", response.Content);

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_PORT => "56350",
  CURLOPT_URL => "http://localhost:56350/api/v1/Product",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

{
  "odata.metadata": "<string>",
  "odata.nextLink": "<string>",
  "value": [
    {}
  ]
}

Get All

OData list of all Product.

Can be sorted and further filtered using OData conventions:

Product?$select=col1,col2,abc/col3
Product?$filter=col1 eq ‘foo’ and startswith(col2, ‘baz’)
Product?$orderby=abc/col3,col1
Product?$top=1000
Product?$mode=full

OData returns XML or JSON carriers depending on the Accept headers.

Calls the Archive service using the “Product” archive.

Filter Operators:

ints: eq =, ne, le, lt, gt, ge, set, equals, greater, less, unequals, between

strings: contains, is, notBegins, notContains, isNot

associate: associateIsOneOf, associateIsNotOneOf,

list ids: oneOf, NotOneOf,

dates: before, date, after, dateBetween, beforeToday

Unary ops: currentAssociate, beforeToday, today, afterToday, lastWeek, thisWeek, nextWeek, lastMonth, thisMonth, nextMonth, lastQuarter, thisQuarter, nextQuarter, thisHalf, thisYear

Funcs: substringof(a,b), startswith(a,b), endswith(a,b), this(f,period), next(f,n,period), previous(f,n,period), thisAndNext(f,n,period), thisAndPrevious(f,n,period), thisAndPreviousAndNext(f,period)

Get All

using RestSharp;


var options = new RestClientOptions("http://localhost:56350/api/v1/Product");
var client = new RestClient(options);
var request = new RestRequest("");
var response = await client.GetAsync(request);

Console.WriteLine("{0}", response.Content);

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_PORT => "56350",
  CURLOPT_URL => "http://localhost:56350/api/v1/Product",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

{
  "odata.metadata": "<string>",
  "odata.nextLink": "<string>",
  "value": [
    {}
  ]
}

Headers

Accept-Language

string

Convert string references and multi-language values into a specified language (iso2) code.

SO-Language

string

Convert string references and multi-language values into a specified language (iso2) code. Overrides Accept-Language value.

SO-Culture

string

Number, date formatting in a specified culture (iso2 language) code. Partially overrides SO-Language/Accept-Language value. Ignored if no Language set.

SO-TimeZone

string

Specify the timezone code that you would like date/time responses converted to.

SO-AppToken

string

The application token that identifies the partner app. Used when calling Online WebAPI from a server.

Query Parameters

$select

string

Comma separated list of column names to return. "nameDepartment,fullname,category". Can also use aggregation functions and modifiers: "Count(category):Footer"

$filter

string

Expression to restrict the results. e.g.: "name begins 'foo' and category gt 1"

$orderBy

string

Comma separated list of column names to sort by, with optional direction. "name asc,fullname,category desc"

$entities

string

Comma separated list of entity names to use. Default = "". "contact, person"

$top

integer<int32>

Number of rows to return in results

$skip

integer<int32>

Number of rows from database to skip before returning results

$mode

enum<string>

FULL (with raw values and hints for each value) or SLIM (just the display values)

Available options:

Slim,

Wide,

Full

$options

string

Provider specific options. e.g: "GrandTotal=true"

$context

string

Provider specific context parameter.

$format

string

Set XML or JSON output format; override the format determined from Accept header.

$jsonSafe

boolean

Make output names into JSON safe property names. Replace all unsafe characters with _ underscore.

$output

enum<string>

Return Logical or Display values in SLIM mode. Logical returns true/false for booleans, Display returns icon hints. Dates are always returned as ISO strings.

Available options:

Logical,

Display

Response

Easy to use archive results - just a flat list of values.

odata.metadata

string

odata.nextLink

string

value

object[]

Show child attributes