Obtaining All Fields in a Table in the Data Source
Function
This API is used to obtain all fields in a table in the data source.
URI
GET /v2/{project_id}/fdi/instances/{instance_id}/datasources/{datasource_id}/columns
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| project_id | Yes | String | Project ID. For details about how to obtain the project ID, see Appendix > Obtaining a Project ID in the ROMA Connect API Reference. |
| instance_id | Yes | String | Instance ID |
| datasource_id | Yes | String | Data source ID. |
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| direction_type | Yes | String | Location of the task where the data source is located. |
| db_name | No | String | Database name. Only data sources of the MRSHIVE type is supported. |
| table_name | Yes | String | Name of the table where a field is located. |
Request Parameters
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| X-Auth-Token | Yes | String | User token. The token can be obtained by calling an IAM API. The value of X-Subject-Token in the response header is the user token. |
Response Parameters
Status code: 200
| Parameter | Type | Description |
|---|---|---|
| columns | Array of ColumnInfo objects | Returned entity object. |
| Parameter | Type | Description |
|---|---|---|
| field_name | String | Field name. |
| field_type | String | Field type. |
| field_length | String | Field length. |
| null_able | String | Indicates whether it can be null. |
| is_partition | Boolean | Whether it is a partition field. |
| primary | String | Whether it is a primary key field. |
| unique | String | Whether it is a unique key field. |
| decimal_digits | String | Number of decimal places. If the value is not a number, null is returned. |
Status code: 400
| Parameter | Type | Description |
|---|---|---|
| error_code | String | Error code. |
| error_msg | String | Error message. |
| detail | String | Description details. |
Status code: 404
| Parameter | Type | Description |
|---|---|---|
| error_code | String | Error code. |
| error_msg | String | Error message. |
Status code: 500
| Parameter | Type | Description |
|---|---|---|
| error_code | String | Error code. |
| error_msg | String | Error message. |
Example Requests
None
Example Responses
Status code: 500
Internal Server Error
{
"error_code" : "FDI.3126",
"error_msg" : "Failed to query the field."
} Status Codes
| Status Code | Description |
|---|---|
| 200 | OK |
| 400 | Error response |
| 404 | Not Found |
| 500 | Internal Server Error |
Error Codes
See Error Codes.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.