Skip to main content

Get Tables

Returns the list of available tables in your tenant database along with their localized labels. Use this endpoint to discover which tables you can query, insert into, or update.

Endpoint

GET /integration/tables

Authentication

Requires a valid API token in the Authorization header.

Query Parameters

ParameterTypeRequiredDefaultDescription
langstringNo"he"Language code for label localization. Use a code returned by Get Languages.

Response

Returns an array of table objects:

FieldTypeDescription
namestringThe internal table name (used in other API calls)
labelstringThe localized display name for this table

Examples

Request (Hebrew labels)

curl -X GET "https://api.ozari.co.il/integration/tables?lang=he" \
-H "Authorization: Bearer your-api-token-here"

Response

{
"success": true,
"tables": [
{ "name": "tcust", "label": "לקוחות" },
{ "name": "twork", "label": "הזמנות עבודה" },
{ "name": "tworkx", "label": "משימות" },
{ "name": "tserial", "label": "מכשירים" },
{ "name": "parts", "label": "פריטים" },
{ "name": "temp", "label": "עובדים" }
]
}

Request (English labels)

curl -X GET "https://api.ozari.co.il/integration/tables?lang=en" \
-H "Authorization: Bearer your-api-token-here"

Response

{
"success": true,
"tables": [
{ "name": "tcust", "label": "Customers" },
{ "name": "twork", "label": "Work Orders" },
{ "name": "tworkx", "label": "Tasks" },
{ "name": "tserial", "label": "Devices" },
{ "name": "parts", "label": "Items" },
{ "name": "temp", "label": "Employees" }
]
}

Notes

  • Tables are deduplicated by name. If the internal labels_tables configuration has multiple rows for the same table, only the first occurrence is returned.
  • The name value is what you pass as the :table parameter in other endpoints like Get Fields, Insert Record, and Update Record.
  • If no localized label is found for the requested language, the internal table name is returned as the label.