Query table full path¶
The full path of the query table in the catalog hierarchy.
POST $CLOUDSIGMA_API_BASE/catalog/table/full_path
Before you call this API¶
Configure the regional API endpoint and authentication, and select the target workspace.
First query the object in the database to obtain the table ID.
Set the operation-specific values used in the request:
$TABLE_ID: The table ID to be queried.
Request¶
curl -X POST "$CLOUDSIGMA_API_BASE/catalog/table/full_path" \
-H "X-API-Key: $CLOUDSIGMA_API_KEY" \
-H "X-Workspace-ID: $WORKSPACE_ID" \
-H "Content-Type: application/json" \
-d '{
"id": '"$TABLE_ID"'
}'
Request body
Parameter |
Type |
Required |
Description |
|---|---|---|---|
|
integer |
Yes |
Table ID. |
Successful response¶
Returns 200 and the full path on success.
{
"code": "OK",
"msg": "OK",
"data": {
"path": "catalog-a/database-a/orders"
}
}
The response fields are as follows.
Field |
Type |
Description |
|---|---|---|
|
string |
The full path to the table in the Catalog hierarchy. |
Error response¶
{
"code": "ErrParamInvalid",
"msg": "请求参数无效",
"data": null
}
Common HTTP errors¶
HTTP status code |
error code |
Common causes |
Recommended actions |
|---|---|---|---|
|
|
The table ID is invalid. |
Use a valid table ID. |
|
|
The current identity does not have permission to read the table. |
Use credentials with read permissions. |
|
|
The server failed to resolve the table path. |
Try again later. |