Exposes data + entity metadata v
Scroll down for code samples, example requests and responses. Select a language for code samples from the tabs above or the mobile navigation menu.
This service is located at /odata/v4/-data/
Entity Data Model
Legend
Base URLs:
Data
The actual data, organized by column name
Retrieves a list of data.
Code samples
# You can also use wget
curl -X GET /odata/v4/-data/Data \
-H 'Accept: application/json'GET /odata/v4/-data/Data HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Data',
{
method: 'GET',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.get '/odata/v4/-data/Data',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.get('/odata/v4/-data/Data', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('GET','/odata/v4/-data/Data', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Data");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("GET");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("GET", "/odata/v4/-data/Data", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}GET /Data
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| $top | query | integer | false | Show only the first n items, see Paging - Top |
| $skip | query | integer | false | Skip the first n items, see Paging - Skip |
| $search | query | string | false | Search items by search phrases, see Searching |
| $filter | query | string | false | Filter items by property values, see Filtering |
| $count | query | boolean | false | Include count of items, see Count |
| $orderby | query | array[string] | false | Order items by property values, see Sorting |
| $select | query | array[string] | false | Select properties to be returned, see Select |
Enumerated Values
| Parameter | Value |
|---|---|
| $orderby | dummy |
| $orderby | dummy desc |
| $orderby | record/column |
| $orderby | record/column desc |
| $orderby | record/data |
| $orderby | record/data desc |
| $select | dummy |
| $select | record |
Example responses
200 Response
{
"@count": 0,
"value": [
{
"dummy": "string",
"record": [
{
"column": "string",
"data": "string"
}
]
}
]
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 200 | OK | Retrieved data | Inline |
| 4XX | Unknown | Error | error |
Response Schema
Status Code 200
Collection of Data
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| » @count | any | false | none | The number of entities in the collection. Available when using the $count query option. |
anyOf
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| »» anonymous | number | false | none | none |
or
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| »» anonymous | string | false | none | none |
continued
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| » value | [DataService.Data] | false | none | none |
| »» The actual data, organized by column name | DataService.Data | false | none | none |
| »»» dummy | string | false | none | none |
| »»» record | [allOf] | false | none | none |
| »»»» Data_record | DataService.Data_record¦null | false | none | none |
| »»»»» column | string¦null | false | none | none |
| »»»»» data | string¦null | false | none | none |
Creates a single datum.
Code samples
# You can also use wget
curl -X POST /odata/v4/-data/Data \
-H 'Content-Type: application/json' \
-H 'Accept: application/json'POST /odata/v4/-data/Data HTTP/1.1
Content-Type: application/json
Accept: application/jsonconst inputBody = '{
"dummy": "string",
"record": [
{
"column": "string",
"data": "string"
}
]
}';
const headers = {
'Content-Type':'application/json',
'Accept':'application/json'
};
fetch('/odata/v4/-data/Data',
{
method: 'POST',
body: inputBody,
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Content-Type' => 'application/json',
'Accept' => 'application/json'
}
result = RestClient.post '/odata/v4/-data/Data',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Content-Type': 'application/json',
'Accept': 'application/json'
}
r = requests.post('/odata/v4/-data/Data', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Content-Type' => 'application/json',
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('POST','/odata/v4/-data/Data', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Data");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("POST");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Content-Type": []string{"application/json"},
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("POST", "/odata/v4/-data/Data", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}POST /Data
Body parameter
{
"dummy": "string",
"record": [
{
"column": "string",
"data": "string"
}
]
}Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| body | body | DataService.Data-create | true | The actual data, organized by column name |
Example responses
201 Response
{
"dummy": "string",
"record": [
{
"column": "string",
"data": "string"
}
]
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 201 | Created | Created datum | DataService.Data |
| 4XX | Unknown | Error | error |
Retrieves a single datum.
Code samples
# You can also use wget
curl -X GET /odata/v4/-data/Data('{dummy}') \
-H 'Accept: application/json'GET /odata/v4/-data/Data('{dummy}') HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Data('{dummy}')',
{
method: 'GET',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.get '/odata/v4/-data/Data('{dummy}')',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.get('/odata/v4/-data/Data('{dummy}')', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('GET','/odata/v4/-data/Data('{dummy}')', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Data('{dummy}')");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("GET");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("GET", "/odata/v4/-data/Data('{dummy}')", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}GET /Data('{dummy}')
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| $select | query | array[string] | false | Select properties to be returned, see Select |
| dummy | path | string | true | key: dummy |
Enumerated Values
| Parameter | Value |
|---|---|
| $select | dummy |
| $select | record |
Example responses
200 Response
{
"dummy": "string",
"record": [
{
"column": "string",
"data": "string"
}
]
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 200 | OK | Retrieved datum | DataService.Data |
| 4XX | Unknown | Error | error |
Changes a single datum.
Code samples
# You can also use wget
curl -X PATCH /odata/v4/-data/Data('{dummy}') \
-H 'Content-Type: application/json' \
-H 'Accept: application/json'PATCH /odata/v4/-data/Data('{dummy}') HTTP/1.1
Content-Type: application/json
Accept: application/jsonconst inputBody = '{
"record": [
{
"column": "string",
"data": "string"
}
]
}';
const headers = {
'Content-Type':'application/json',
'Accept':'application/json'
};
fetch('/odata/v4/-data/Data('{dummy}')',
{
method: 'PATCH',
body: inputBody,
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Content-Type' => 'application/json',
'Accept' => 'application/json'
}
result = RestClient.patch '/odata/v4/-data/Data('{dummy}')',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Content-Type': 'application/json',
'Accept': 'application/json'
}
r = requests.patch('/odata/v4/-data/Data('{dummy}')', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Content-Type' => 'application/json',
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('PATCH','/odata/v4/-data/Data('{dummy}')', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Data('{dummy}')");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("PATCH");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Content-Type": []string{"application/json"},
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("PATCH", "/odata/v4/-data/Data('{dummy}')", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}PATCH /Data('{dummy}')
Body parameter
{
"record": [
{
"column": "string",
"data": "string"
}
]
}Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| body | body | DataService.Data-update | true | The actual data, organized by column name |
| dummy | path | string | true | key: dummy |
Example responses
4XX Response
{
"error": {
"code": "string",
"message": "string",
"target": "string",
"details": [
{
"code": "string",
"message": "string",
"target": "string"
}
],
"innererror": {}
}
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 204 | No Content | Success | None |
| 4XX | Unknown | Error | error |
Deletes a single datum.
Code samples
# You can also use wget
curl -X DELETE /odata/v4/-data/Data('{dummy}') \
-H 'Accept: application/json'DELETE /odata/v4/-data/Data('{dummy}') HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Data('{dummy}')',
{
method: 'DELETE',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.delete '/odata/v4/-data/Data('{dummy}')',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.delete('/odata/v4/-data/Data('{dummy}')', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('DELETE','/odata/v4/-data/Data('{dummy}')', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Data('{dummy}')");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("DELETE");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("DELETE", "/odata/v4/-data/Data('{dummy}')", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}DELETE /Data('{dummy}')
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| dummy | path | string | true | key: dummy |
Example responses
4XX Response
{
"error": {
"code": "string",
"message": "string",
"target": "string",
"details": [
{
"code": "string",
"message": "string",
"target": "string"
}
],
"innererror": {}
}
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 204 | No Content | Success | None |
| 4XX | Unknown | Error | error |
Entities
Metadata like name and columns/elements
Retrieves a list of entities.
Code samples
# You can also use wget
curl -X GET /odata/v4/-data/Entities \
-H 'Accept: application/json'GET /odata/v4/-data/Entities HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities',
{
method: 'GET',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.get '/odata/v4/-data/Entities',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.get('/odata/v4/-data/Entities', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('GET','/odata/v4/-data/Entities', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("GET");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("GET", "/odata/v4/-data/Entities", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}GET /Entities
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| $top | query | integer | false | Show only the first n items, see Paging - Top |
| $skip | query | integer | false | Skip the first n items, see Paging - Skip |
| $search | query | string | false | Search items by search phrases, see Searching |
| $filter | query | string | false | Filter items by property values, see Filtering |
| $count | query | boolean | false | Include count of items, see Count |
| $orderby | query | array[string] | false | Order items by property values, see Sorting |
| $select | query | array[string] | false | Select properties to be returned, see Select |
| $expand | query | array[string] | false | The value of $expand query option is a comma-separated list of navigation property names, stream property names, or $value indicating the stream content of a media-entity. The corresponding related entities and stream values will be represented inline, see Expand |
Enumerated Values
| Parameter | Value |
|---|---|
| $orderby | name |
| $orderby | name desc |
| $select | name |
| $expand | * |
| $expand | columns |
Example responses
200 Response
{
"@count": 0,
"value": [
{}
]
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 200 | OK | Retrieved entities | Inline |
| 4XX | Unknown | Error | error |
Response Schema
Status Code 200
Collection of Entities
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| » @count | any | false | none | The number of entities in the collection. Available when using the $count query option. |
anyOf
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| »» anonymous | number | false | none | none |
or
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| »» anonymous | string | false | none | none |
continued
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| » value | [object] | false | none | none |
Creates a single entity.
Code samples
# You can also use wget
curl -X POST /odata/v4/-data/Entities \
-H 'Content-Type: application/json' \
-H 'Accept: application/json'POST /odata/v4/-data/Entities HTTP/1.1
Content-Type: application/json
Accept: application/jsonconst inputBody = '{
"name": "string",
"columns": [
{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}
]
}';
const headers = {
'Content-Type':'application/json',
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities',
{
method: 'POST',
body: inputBody,
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Content-Type' => 'application/json',
'Accept' => 'application/json'
}
result = RestClient.post '/odata/v4/-data/Entities',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Content-Type': 'application/json',
'Accept': 'application/json'
}
r = requests.post('/odata/v4/-data/Entities', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Content-Type' => 'application/json',
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('POST','/odata/v4/-data/Entities', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("POST");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Content-Type": []string{"application/json"},
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("POST", "/odata/v4/-data/Entities", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}POST /Entities
Body parameter
{
"name": "string",
"columns": [
{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}
]
}Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| body | body | DataService.Entities-create | true | Metadata like name and columns/elements |
Example responses
201 Response
{}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 201 | Created | Created entity | Inline |
| 4XX | Unknown | Error | error |
Response Schema
Status Code 201
See DataService.Entities
| Name | Type | Required | Restrictions | Description |
|---|
Retrieves a single entity.
Code samples
# You can also use wget
curl -X GET /odata/v4/-data/Entities('{name}') \
-H 'Accept: application/json'GET /odata/v4/-data/Entities('{name}') HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities('{name}')',
{
method: 'GET',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.get '/odata/v4/-data/Entities('{name}')',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.get('/odata/v4/-data/Entities('{name}')', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('GET','/odata/v4/-data/Entities('{name}')', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities('{name}')");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("GET");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("GET", "/odata/v4/-data/Entities('{name}')", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}GET /Entities('{name}')
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| $select | query | array[string] | false | Select properties to be returned, see Select |
| $expand | query | array[string] | false | The value of $expand query option is a comma-separated list of navigation property names, stream property names, or $value indicating the stream content of a media-entity. The corresponding related entities and stream values will be represented inline, see Expand |
| name | path | string | true | key: name |
Enumerated Values
| Parameter | Value |
|---|---|
| $select | name |
| $expand | * |
| $expand | columns |
Example responses
200 Response
{}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 200 | OK | Retrieved entity | Inline |
| 4XX | Unknown | Error | error |
Response Schema
Status Code 200
See DataService.Entities
| Name | Type | Required | Restrictions | Description |
|---|
Changes a single entity.
Code samples
# You can also use wget
curl -X PATCH /odata/v4/-data/Entities('{name}') \
-H 'Content-Type: application/json' \
-H 'Accept: application/json'PATCH /odata/v4/-data/Entities('{name}') HTTP/1.1
Content-Type: application/json
Accept: application/jsonconst inputBody = '{
"columns": [
{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}
]
}';
const headers = {
'Content-Type':'application/json',
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities('{name}')',
{
method: 'PATCH',
body: inputBody,
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Content-Type' => 'application/json',
'Accept' => 'application/json'
}
result = RestClient.patch '/odata/v4/-data/Entities('{name}')',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Content-Type': 'application/json',
'Accept': 'application/json'
}
r = requests.patch('/odata/v4/-data/Entities('{name}')', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Content-Type' => 'application/json',
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('PATCH','/odata/v4/-data/Entities('{name}')', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities('{name}')");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("PATCH");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Content-Type": []string{"application/json"},
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("PATCH", "/odata/v4/-data/Entities('{name}')", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}PATCH /Entities('{name}')
Body parameter
{
"columns": [
{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}
]
}Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| body | body | DataService.Entities-update | true | Metadata like name and columns/elements |
| name | path | string | true | key: name |
Example responses
4XX Response
{
"error": {
"code": "string",
"message": "string",
"target": "string",
"details": [
{
"code": "string",
"message": "string",
"target": "string"
}
],
"innererror": {}
}
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 204 | No Content | Success | None |
| 4XX | Unknown | Error | error |
Deletes a single entity.
Code samples
# You can also use wget
curl -X DELETE /odata/v4/-data/Entities('{name}') \
-H 'Accept: application/json'DELETE /odata/v4/-data/Entities('{name}') HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities('{name}')',
{
method: 'DELETE',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.delete '/odata/v4/-data/Entities('{name}')',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.delete('/odata/v4/-data/Entities('{name}')', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('DELETE','/odata/v4/-data/Entities('{name}')', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities('{name}')");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("DELETE");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("DELETE", "/odata/v4/-data/Entities('{name}')", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}DELETE /Entities('{name}')
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| name | path | string | true | key: name |
Example responses
4XX Response
{
"error": {
"code": "string",
"message": "string",
"target": "string",
"details": [
{
"code": "string",
"message": "string",
"target": "string"
}
],
"innererror": {}
}
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 204 | No Content | Success | None |
| 4XX | Unknown | Error | error |
Retrieves a list of columns of a entity.
Code samples
# You can also use wget
curl -X GET /odata/v4/-data/Entities('{name}')/columns \
-H 'Accept: application/json'GET /odata/v4/-data/Entities('{name}')/columns HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities('{name}')/columns',
{
method: 'GET',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.get '/odata/v4/-data/Entities('{name}')/columns',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.get('/odata/v4/-data/Entities('{name}')/columns', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('GET','/odata/v4/-data/Entities('{name}')/columns', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities('{name}')/columns");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("GET");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("GET", "/odata/v4/-data/Entities('{name}')/columns", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}GET /Entities('{name}')/columns
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| $top | query | integer | false | Show only the first n items, see Paging - Top |
| $skip | query | integer | false | Skip the first n items, see Paging - Skip |
| $search | query | string | false | Search items by search phrases, see Searching |
| $filter | query | string | false | Filter items by property values, see Filtering |
| $count | query | boolean | false | Include count of items, see Count |
| $orderby | query | array[string] | false | Order items by property values, see Sorting |
| $select | query | array[string] | false | Select properties to be returned, see Select |
| $expand | query | array[string] | false | The value of $expand query option is a comma-separated list of navigation property names, stream property names, or $value indicating the stream content of a media-entity. The corresponding related entities and stream values will be represented inline, see Expand |
| name | path | string | true | key: name |
Enumerated Values
| Parameter | Value |
|---|---|
| $orderby | up__name |
| $orderby | up__name desc |
| $orderby | name |
| $orderby | name desc |
| $orderby | type |
| $orderby | type desc |
| $orderby | isKey |
| $orderby | isKey desc |
| $select | up__name |
| $select | name |
| $select | type |
| $select | isKey |
| $expand | * |
| $expand | up_ |
Example responses
200 Response
{
"@count": 0,
"value": [
{}
]
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 200 | OK | Retrieved columns | Inline |
| 4XX | Unknown | Error | error |
Response Schema
Status Code 200
Collection of Entities_columns
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| » @count | any | false | none | The number of entities in the collection. Available when using the $count query option. |
anyOf
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| »» anonymous | number | false | none | none |
or
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| »» anonymous | string | false | none | none |
continued
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| » value | [object] | false | none | none |
Creates a single column of a entity.
Code samples
# You can also use wget
curl -X POST /odata/v4/-data/Entities('{name}')/columns \
-H 'Content-Type: application/json' \
-H 'Accept: application/json'POST /odata/v4/-data/Entities('{name}')/columns HTTP/1.1
Content-Type: application/json
Accept: application/jsonconst inputBody = '{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}';
const headers = {
'Content-Type':'application/json',
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities('{name}')/columns',
{
method: 'POST',
body: inputBody,
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Content-Type' => 'application/json',
'Accept' => 'application/json'
}
result = RestClient.post '/odata/v4/-data/Entities('{name}')/columns',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Content-Type': 'application/json',
'Accept': 'application/json'
}
r = requests.post('/odata/v4/-data/Entities('{name}')/columns', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Content-Type' => 'application/json',
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('POST','/odata/v4/-data/Entities('{name}')/columns', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities('{name}')/columns");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("POST");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Content-Type": []string{"application/json"},
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("POST", "/odata/v4/-data/Entities('{name}')/columns", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}POST /Entities('{name}')/columns
Body parameter
{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| body | body | DataService.Entities_columns-create | true | New column |
| name | path | string | true | key: name |
Example responses
201 Response
{}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 201 | Created | Created column | Inline |
| 4XX | Unknown | Error | error |
Response Schema
Status Code 201
See DataService.Entities_columns
| Name | Type | Required | Restrictions | Description |
|---|
Entities_columns
Retrieves a list of entities_columns.
Code samples
# You can also use wget
curl -X GET /odata/v4/-data/Entities_columns \
-H 'Accept: application/json'GET /odata/v4/-data/Entities_columns HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities_columns',
{
method: 'GET',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.get '/odata/v4/-data/Entities_columns',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.get('/odata/v4/-data/Entities_columns', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('GET','/odata/v4/-data/Entities_columns', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities_columns");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("GET");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("GET", "/odata/v4/-data/Entities_columns", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}GET /Entities_columns
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| $top | query | integer | false | Show only the first n items, see Paging - Top |
| $skip | query | integer | false | Skip the first n items, see Paging - Skip |
| $search | query | string | false | Search items by search phrases, see Searching |
| $filter | query | string | false | Filter items by property values, see Filtering |
| $count | query | boolean | false | Include count of items, see Count |
| $orderby | query | array[string] | false | Order items by property values, see Sorting |
| $select | query | array[string] | false | Select properties to be returned, see Select |
| $expand | query | array[string] | false | The value of $expand query option is a comma-separated list of navigation property names, stream property names, or $value indicating the stream content of a media-entity. The corresponding related entities and stream values will be represented inline, see Expand |
Enumerated Values
| Parameter | Value |
|---|---|
| $orderby | up__name |
| $orderby | up__name desc |
| $orderby | name |
| $orderby | name desc |
| $orderby | type |
| $orderby | type desc |
| $orderby | isKey |
| $orderby | isKey desc |
| $select | up__name |
| $select | name |
| $select | type |
| $select | isKey |
| $expand | * |
| $expand | up_ |
Example responses
200 Response
{
"@count": 0,
"value": [
{}
]
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 200 | OK | Retrieved entities_columns | Inline |
| 4XX | Unknown | Error | error |
Response Schema
Status Code 200
Collection of Entities_columns
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| » @count | any | false | none | The number of entities in the collection. Available when using the $count query option. |
anyOf
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| »» anonymous | number | false | none | none |
or
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| »» anonymous | string | false | none | none |
continued
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| » value | [object] | false | none | none |
Creates a single entities_column.
Code samples
# You can also use wget
curl -X POST /odata/v4/-data/Entities_columns \
-H 'Content-Type: application/json' \
-H 'Accept: application/json'POST /odata/v4/-data/Entities_columns HTTP/1.1
Content-Type: application/json
Accept: application/jsonconst inputBody = '{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}';
const headers = {
'Content-Type':'application/json',
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities_columns',
{
method: 'POST',
body: inputBody,
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Content-Type' => 'application/json',
'Accept' => 'application/json'
}
result = RestClient.post '/odata/v4/-data/Entities_columns',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Content-Type': 'application/json',
'Accept': 'application/json'
}
r = requests.post('/odata/v4/-data/Entities_columns', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Content-Type' => 'application/json',
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('POST','/odata/v4/-data/Entities_columns', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities_columns");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("POST");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Content-Type": []string{"application/json"},
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("POST", "/odata/v4/-data/Entities_columns", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}POST /Entities_columns
Body parameter
{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| body | body | DataService.Entities_columns-create | true | New entities_column |
Example responses
201 Response
{}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 201 | Created | Created entities_column | Inline |
| 4XX | Unknown | Error | error |
Response Schema
Status Code 201
See DataService.Entities_columns
| Name | Type | Required | Restrictions | Description |
|---|
Retrieves a single entities_column.
Code samples
# You can also use wget
curl -X GET /odata/v4/-data/Entities_columns('{up__name}') \
-H 'Accept: application/json'GET /odata/v4/-data/Entities_columns('{up__name}') HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities_columns('{up__name}')',
{
method: 'GET',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.get '/odata/v4/-data/Entities_columns('{up__name}')',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.get('/odata/v4/-data/Entities_columns('{up__name}')', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('GET','/odata/v4/-data/Entities_columns('{up__name}')', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities_columns('{up__name}')");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("GET");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("GET", "/odata/v4/-data/Entities_columns('{up__name}')", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}GET /Entities_columns('{up__name}')
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| $select | query | array[string] | false | Select properties to be returned, see Select |
| $expand | query | array[string] | false | The value of $expand query option is a comma-separated list of navigation property names, stream property names, or $value indicating the stream content of a media-entity. The corresponding related entities and stream values will be represented inline, see Expand |
| up__name | path | string | true | key: up__name |
Enumerated Values
| Parameter | Value |
|---|---|
| $select | up__name |
| $select | name |
| $select | type |
| $select | isKey |
| $expand | * |
| $expand | up_ |
Example responses
200 Response
{}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 200 | OK | Retrieved entities_column | Inline |
| 4XX | Unknown | Error | error |
Response Schema
Status Code 200
See DataService.Entities_columns
| Name | Type | Required | Restrictions | Description |
|---|
Changes a single entities_column.
Code samples
# You can also use wget
curl -X PATCH /odata/v4/-data/Entities_columns('{up__name}') \
-H 'Content-Type: application/json' \
-H 'Accept: application/json'PATCH /odata/v4/-data/Entities_columns('{up__name}') HTTP/1.1
Content-Type: application/json
Accept: application/jsonconst inputBody = '{
"name": "string",
"type": "string",
"isKey": true
}';
const headers = {
'Content-Type':'application/json',
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities_columns('{up__name}')',
{
method: 'PATCH',
body: inputBody,
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Content-Type' => 'application/json',
'Accept' => 'application/json'
}
result = RestClient.patch '/odata/v4/-data/Entities_columns('{up__name}')',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Content-Type': 'application/json',
'Accept': 'application/json'
}
r = requests.patch('/odata/v4/-data/Entities_columns('{up__name}')', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Content-Type' => 'application/json',
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('PATCH','/odata/v4/-data/Entities_columns('{up__name}')', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities_columns('{up__name}')");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("PATCH");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Content-Type": []string{"application/json"},
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("PATCH", "/odata/v4/-data/Entities_columns('{up__name}')", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}PATCH /Entities_columns('{up__name}')
Body parameter
{
"name": "string",
"type": "string",
"isKey": true
}Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| body | body | DataService.Entities_columns-update | true | New property values |
| up__name | path | string | true | key: up__name |
Example responses
4XX Response
{
"error": {
"code": "string",
"message": "string",
"target": "string",
"details": [
{
"code": "string",
"message": "string",
"target": "string"
}
],
"innererror": {}
}
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 204 | No Content | Success | None |
| 4XX | Unknown | Error | error |
Deletes a single entities_column.
Code samples
# You can also use wget
curl -X DELETE /odata/v4/-data/Entities_columns('{up__name}') \
-H 'Accept: application/json'DELETE /odata/v4/-data/Entities_columns('{up__name}') HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities_columns('{up__name}')',
{
method: 'DELETE',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.delete '/odata/v4/-data/Entities_columns('{up__name}')',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.delete('/odata/v4/-data/Entities_columns('{up__name}')', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('DELETE','/odata/v4/-data/Entities_columns('{up__name}')', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities_columns('{up__name}')");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("DELETE");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("DELETE", "/odata/v4/-data/Entities_columns('{up__name}')", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}DELETE /Entities_columns('{up__name}')
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| up__name | path | string | true | key: up__name |
Example responses
4XX Response
{
"error": {
"code": "string",
"message": "string",
"target": "string",
"details": [
{
"code": "string",
"message": "string",
"target": "string"
}
],
"innererror": {}
}
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 204 | No Content | Success | None |
| 4XX | Unknown | Error | error |
Retrieves up_ of a entities_column.
Code samples
# You can also use wget
curl -X GET /odata/v4/-data/Entities_columns('{up__name}')/up_ \
-H 'Accept: application/json'GET /odata/v4/-data/Entities_columns('{up__name}')/up_ HTTP/1.1
Accept: application/json
const headers = {
'Accept':'application/json'
};
fetch('/odata/v4/-data/Entities_columns('{up__name}')/up_',
{
method: 'GET',
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Accept' => 'application/json'
}
result = RestClient.get '/odata/v4/-data/Entities_columns('{up__name}')/up_',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Accept': 'application/json'
}
r = requests.get('/odata/v4/-data/Entities_columns('{up__name}')/up_', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Accept' => 'application/json',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('GET','/odata/v4/-data/Entities_columns('{up__name}')/up_', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/Entities_columns('{up__name}')/up_");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("GET");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Accept": []string{"application/json"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("GET", "/odata/v4/-data/Entities_columns('{up__name}')/up_", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}GET /Entities_columns('{up__name}')/up_
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| $select | query | array[string] | false | Select properties to be returned, see Select |
| $expand | query | array[string] | false | The value of $expand query option is a comma-separated list of navigation property names, stream property names, or $value indicating the stream content of a media-entity. The corresponding related entities and stream values will be represented inline, see Expand |
| up__name | path | string | true | key: up__name |
Enumerated Values
| Parameter | Value |
|---|---|
| $select | name |
| $expand | * |
| $expand | columns |
Example responses
200 Response
{}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 200 | OK | Retrieved up_ | Inline |
| 4XX | Unknown | Error | error |
Response Schema
Status Code 200
See DataService.Entities
| Name | Type | Required | Restrictions | Description |
|---|
Batch Requests
Sends a group of requests
Code samples
# You can also use wget
curl -X POST /odata/v4/-data/$batch \
-H 'Content-Type: multipart/mixed;boundary=request-separator' \
-H 'Accept: multipart/mixed'POST /odata/v4/-data/$batch HTTP/1.1
Content-Type: multipart/mixed;boundary=request-separator
Accept: multipart/mixedconst inputBody = 'string';
const headers = {
'Content-Type':'multipart/mixed;boundary=request-separator',
'Accept':'multipart/mixed'
};
fetch('/odata/v4/-data/$batch',
{
method: 'POST',
body: inputBody,
headers: headers
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});require 'rest-client'
require 'json'
headers = {
'Content-Type' => 'multipart/mixed;boundary=request-separator',
'Accept' => 'multipart/mixed'
}
result = RestClient.post '/odata/v4/-data/$batch',
params: {
}, headers: headers
p JSON.parse(result)import requests
headers = {
'Content-Type': 'multipart/mixed;boundary=request-separator',
'Accept': 'multipart/mixed'
}
r = requests.post('/odata/v4/-data/$batch', headers = headers)
print(r.json())<?php
require 'vendor/autoload.php';
$headers = array(
'Content-Type' => 'multipart/mixed;boundary=request-separator',
'Accept' => 'multipart/mixed',
);
$client = new \GuzzleHttp\Client();
// Define array of request body.
$request_body = array();
try {
$response = $client->request('POST','/odata/v4/-data/$batch', array(
'headers' => $headers,
'json' => $request_body,
)
);
print_r($response->getBody()->getContents());
}
catch (\GuzzleHttp\Exception\BadResponseException $e) {
// handle exception or api errors.
print_r($e->getMessage());
}
// ...URL obj = new URL("/odata/v4/-data/$batch");
HttpURLConnection con = (HttpURLConnection) obj.openConnection();
con.setRequestMethod("POST");
int responseCode = con.getResponseCode();
BufferedReader in = new BufferedReader(
new InputStreamReader(con.getInputStream()));
String inputLine;
StringBuffer response = new StringBuffer();
while ((inputLine = in.readLine()) != null) {
response.append(inputLine);
}
in.close();
System.out.println(response.toString());package main
import (
"bytes"
"net/http"
)
func main() {
headers := map[string][]string{
"Content-Type": []string{"multipart/mixed;boundary=request-separator"},
"Accept": []string{"multipart/mixed"},
}
data := bytes.NewBuffer([]byte{jsonReq})
req, err := http.NewRequest("POST", "/odata/v4/-data/$batch", data)
req.Header = headers
client := &http.Client{}
resp, err := client.Do(req)
// ...
}POST /$batch
Group multiple requests into a single request payload, see Batch Requests.
Please note that "Try it out" is not supported for this request.
Body parameter
Parameters
| Name | In | Type | Required | Description |
|---|---|---|---|---|
| body | body | string | true | Batch request |
Example responses
200 Response
4XX Response
{
"error": {
"code": "string",
"message": "string",
"target": "string",
"details": [
{
"code": "string",
"message": "string",
"target": "string"
}
],
"innererror": {}
}
}Responses
| Status | Meaning | Description | Schema |
|---|---|---|---|
| 200 | OK | Batch response | string |
| 4XX | Unknown | Error | error |
Schemas
DataService.Data
{
"dummy": "string",
"record": [
{
"column": "string",
"data": "string"
}
]
}The actual data, organized by column name
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| dummy | string | false | none | none |
| record | [allOf] | false | none | none |
DataService.Data-create
{
"dummy": "string",
"record": [
{
"column": "string",
"data": "string"
}
]
}The actual data, organized by column name (for create)
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| dummy | string | true | none | none |
| record | [allOf] | false | none | none |
DataService.Data-update
{
"record": [
{
"column": "string",
"data": "string"
}
]
}The actual data, organized by column name (for update)
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| record | [allOf] | false | none | none |
DataService.Data_record
{
"column": "string",
"data": "string"
}Data_record
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| column | string¦null | false | none | none |
| data | string¦null | false | none | none |
DataService.Data_record-create
{
"column": "string",
"data": "string"
}Data_record (for create)
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| column | string¦null | false | none | none |
| data | string¦null | false | none | none |
DataService.Data_record-update
{
"column": "string",
"data": "string"
}Data_record (for update)
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| column | string¦null | false | none | none |
| data | string¦null | false | none | none |
DataService.Entities
{
"name": "string",
"columns": [
{}
],
"columns@count": 0
}Metadata like name and columns/elements
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| name | string | false | none | none |
| columns | [object] | false | none | none |
| columns@count | count | false | none | The number of entities in the collection. Available when using the $count query option. |
DataService.Entities-create
{
"name": "string",
"columns": [
{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}
]
}Metadata like name and columns/elements (for create)
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| name | string | true | none | none |
| columns | [DataService.Entities_columns-create] | false | none | none |
DataService.Entities-update
{
"columns": [
{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}
]
}Metadata like name and columns/elements (for update)
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| columns | [DataService.Entities_columns-create] | false | none | none |
DataService.Entities_columns
{
"up_": {},
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}Entities_columns
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| up_ | object | false | none | See DataService.Entities |
| up__name | string | false | none | none |
| name | string¦null | false | none | none |
| type | string¦null | false | none | none |
| isKey | boolean¦null | false | none | none |
DataService.Entities_columns-create
{
"up__name": "string",
"name": "string",
"type": "string",
"isKey": true
}Entities_columns (for create)
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| up__name | string | true | none | none |
| name | string¦null | false | none | none |
| type | string¦null | false | none | none |
| isKey | boolean¦null | false | none | none |
DataService.Entities_columns-update
{
"name": "string",
"type": "string",
"isKey": true
}Entities_columns (for update)
Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| name | string¦null | false | none | none |
| type | string¦null | false | none | none |
| isKey | boolean¦null | false | none | none |
count
0The number of entities in the collection. Available when using the $count query option.
Properties
anyOf
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| anonymous | number | false | none | none |
or
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| anonymous | string | false | none | none |
error
{
"error": {
"code": "string",
"message": "string",
"target": "string",
"details": [
{
"code": "string",
"message": "string",
"target": "string"
}
],
"innererror": {}
}
}Properties
| Name | Type | Required | Restrictions | Description |
|---|---|---|---|---|
| error | object | true | none | none |
| » code | string | true | none | none |
| » message | string | true | none | none |
| » target | string | false | none | none |
| » details | [object] | false | none | none |
| »» code | string | true | none | none |
| »» message | string | true | none | none |
| »» target | string | false | none | none |
| » innererror | object | false | none | The structure of this object is service-specific |