Tables
List all tables in authenticated customer's schema grouped by category
Returns all data categories and their available tables for the authenticated API key.
GET
/
tables
List all tables in authenticated customer's schema grouped by category
curl --request GET \
--url https://api.example.com/tables \
--header 'X-API-Key: <api-key>'import requests
url = "https://api.example.com/tables"
headers = {"X-API-Key": "<api-key>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {'X-API-Key': '<api-key>'}};
fetch('https://api.example.com/tables', 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/tables",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"X-API-Key: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.example.com/tables"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("X-API-Key", "<api-key>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.example.com/tables")
.header("X-API-Key", "<api-key>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.example.com/tables")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["X-API-Key"] = '<api-key>'
response = http.request(request)
puts response.read_body{
"categories": [
{
"category": "accounting",
"tables": [
"accounts",
"booking_header",
"booking_positions",
"budgets",
"kontenmapping_ranges"
]
},
{
"category": "contracts",
"tables": [
"contract_debit_diffs",
"contract_debits",
"contract_ends",
"service_contracts"
]
},
{
"category": "depreciation",
"tables": [
"assets",
"depreciation"
]
},
{
"category": "operations",
"tables": [
"notifications",
"offers",
"orders",
"projects"
]
},
{
"category": "property",
"tables": [
"properties",
"property_creditor_services",
"property_structure",
"technical_objects"
]
},
{
"category": "stakeholder",
"tables": [
"creditor",
"employees",
"owner",
"tenants"
]
}
]
}⌘I
List all tables in authenticated customer's schema grouped by category
curl --request GET \
--url https://api.example.com/tables \
--header 'X-API-Key: <api-key>'import requests
url = "https://api.example.com/tables"
headers = {"X-API-Key": "<api-key>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {'X-API-Key': '<api-key>'}};
fetch('https://api.example.com/tables', 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/tables",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"X-API-Key: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.example.com/tables"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("X-API-Key", "<api-key>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.example.com/tables")
.header("X-API-Key", "<api-key>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.example.com/tables")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["X-API-Key"] = '<api-key>'
response = http.request(request)
puts response.read_body{
"categories": [
{
"category": "accounting",
"tables": [
"accounts",
"booking_header",
"booking_positions",
"budgets",
"kontenmapping_ranges"
]
},
{
"category": "contracts",
"tables": [
"contract_debit_diffs",
"contract_debits",
"contract_ends",
"service_contracts"
]
},
{
"category": "depreciation",
"tables": [
"assets",
"depreciation"
]
},
{
"category": "operations",
"tables": [
"notifications",
"offers",
"orders",
"projects"
]
},
{
"category": "property",
"tables": [
"properties",
"property_creditor_services",
"property_structure",
"technical_objects"
]
},
{
"category": "stakeholder",
"tables": [
"creditor",
"employees",
"owner",
"tenants"
]
}
]
}