Requête sur le tableau
curl --request POST \
--url https://api.example.com/table/query \
--header 'Content-Type: application/json' \
--data '
{
"digest": "<string>",
"project_id": "<string>",
"filter": {
"row_digests": [
"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims",
"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims"
]
},
"limit": 100,
"offset": 10,
"sort_by": [
{
"field": "col_a.prop_b",
"order": "desc"
}
]
}
'import requests
url = "https://api.example.com/table/query"
payload = {
"digest": "<string>",
"project_id": "<string>",
"filter": { "row_digests": ["aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims", "aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims"] },
"limit": 100,
"offset": 10,
"sort_by": [
{
"field": "col_a.prop_b",
"order": "desc"
}
]
}
headers = {"Content-Type": "application/json"}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'Content-Type': 'application/json'},
body: JSON.stringify({
digest: '<string>',
project_id: '<string>',
filter: {
row_digests: [
'aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims',
'aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims'
]
},
limit: 100,
offset: 10,
sort_by: [{field: 'col_a.prop_b', order: 'desc'}]
})
};
fetch('https://api.example.com/table/query', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.example.com/table/query",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'digest' => '<string>',
'project_id' => '<string>',
'filter' => [
'row_digests' => [
'aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims',
'aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims'
]
],
'limit' => 100,
'offset' => 10,
'sort_by' => [
[
'field' => 'col_a.prop_b',
'order' => 'desc'
]
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.example.com/table/query"
payload := strings.NewReader("{\n \"digest\": \"<string>\",\n \"project_id\": \"<string>\",\n \"filter\": {\n \"row_digests\": [\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\",\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\"\n ]\n },\n \"limit\": 100,\n \"offset\": 10,\n \"sort_by\": [\n {\n \"field\": \"col_a.prop_b\",\n \"order\": \"desc\"\n }\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.example.com/table/query")
.header("Content-Type", "application/json")
.body("{\n \"digest\": \"<string>\",\n \"project_id\": \"<string>\",\n \"filter\": {\n \"row_digests\": [\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\",\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\"\n ]\n },\n \"limit\": 100,\n \"offset\": 10,\n \"sort_by\": [\n {\n \"field\": \"col_a.prop_b\",\n \"order\": \"desc\"\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.example.com/table/query")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"digest\": \"<string>\",\n \"project_id\": \"<string>\",\n \"filter\": {\n \"row_digests\": [\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\",\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\"\n ]\n },\n \"limit\": 100,\n \"offset\": 10,\n \"sort_by\": [\n {\n \"field\": \"col_a.prop_b\",\n \"order\": \"desc\"\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"rows": [
{
"digest": "<string>",
"val": "<unknown>",
"original_index": 123
}
]
}{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>"
}
]
}Requête sur le tableau
POST
/
table
/
query
Requête sur le tableau
curl --request POST \
--url https://api.example.com/table/query \
--header 'Content-Type: application/json' \
--data '
{
"digest": "<string>",
"project_id": "<string>",
"filter": {
"row_digests": [
"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims",
"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims"
]
},
"limit": 100,
"offset": 10,
"sort_by": [
{
"field": "col_a.prop_b",
"order": "desc"
}
]
}
'import requests
url = "https://api.example.com/table/query"
payload = {
"digest": "<string>",
"project_id": "<string>",
"filter": { "row_digests": ["aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims", "aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims"] },
"limit": 100,
"offset": 10,
"sort_by": [
{
"field": "col_a.prop_b",
"order": "desc"
}
]
}
headers = {"Content-Type": "application/json"}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'Content-Type': 'application/json'},
body: JSON.stringify({
digest: '<string>',
project_id: '<string>',
filter: {
row_digests: [
'aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims',
'aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims'
]
},
limit: 100,
offset: 10,
sort_by: [{field: 'col_a.prop_b', order: 'desc'}]
})
};
fetch('https://api.example.com/table/query', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.example.com/table/query",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'digest' => '<string>',
'project_id' => '<string>',
'filter' => [
'row_digests' => [
'aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims',
'aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims'
]
],
'limit' => 100,
'offset' => 10,
'sort_by' => [
[
'field' => 'col_a.prop_b',
'order' => 'desc'
]
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.example.com/table/query"
payload := strings.NewReader("{\n \"digest\": \"<string>\",\n \"project_id\": \"<string>\",\n \"filter\": {\n \"row_digests\": [\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\",\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\"\n ]\n },\n \"limit\": 100,\n \"offset\": 10,\n \"sort_by\": [\n {\n \"field\": \"col_a.prop_b\",\n \"order\": \"desc\"\n }\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.example.com/table/query")
.header("Content-Type", "application/json")
.body("{\n \"digest\": \"<string>\",\n \"project_id\": \"<string>\",\n \"filter\": {\n \"row_digests\": [\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\",\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\"\n ]\n },\n \"limit\": 100,\n \"offset\": 10,\n \"sort_by\": [\n {\n \"field\": \"col_a.prop_b\",\n \"order\": \"desc\"\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.example.com/table/query")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"digest\": \"<string>\",\n \"project_id\": \"<string>\",\n \"filter\": {\n \"row_digests\": [\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\",\n \"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims\"\n ]\n },\n \"limit\": 100,\n \"offset\": 10,\n \"sort_by\": [\n {\n \"field\": \"col_a.prop_b\",\n \"order\": \"desc\"\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"rows": [
{
"digest": "<string>",
"val": "<unknown>",
"original_index": 123
}
]
}{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>"
}
]
}Corps
application/json
L’empreinte du tableau à interroger
Exemple:
"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims"
L’ID du projet
Exemple:
"my_entity/my_project"
Filtre facultatif à appliquer à la requête. Voir TableRowFilter pour plus de détails.
Show child attributes
Show child attributes
Exemple:
{
"row_digests": [
"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims",
"aonareimsvtl13apimtalpa4435rpmgnaemrpgmarltarstaorsnte134avrims"
]
}
Nombre maximal de lignes à renvoyer
Exemple:
100
Nombre de lignes à ignorer avant de commencer à renvoyer des lignes
Exemple:
10
Liste des champs selon lesquels trier. Les champs peuvent être séparés par des points pour accéder aux valeurs du dictionnaire. Si aucun tri n’est appliqué, l’ordre par défaut du tableau est utilisé (ordre d’insertion).
Show child attributes
Show child attributes
Exemple:
[
{ "field": "col_a.prop_b", "order": "desc" }
]
Réponse
Réponse réussie
Show child attributes
Show child attributes
Cette page vous a-t-elle été utile ?
⌘I