Import a table list by accessing the user's DB.
POST https://cloudsearch.apigw.ntruss.com/CloudSearch/real/v1/db_upload/table
Request
Request body
| Parameter name | Requirement status | Type | Restrictions | Explanation |
|---|---|---|---|---|
| dbKind | Yes | String | mysql, mariadb | DB type |
| host | Yes | String | DB IP | |
| port | Yes | Integer | DB port | |
| user | Yes | String | User ID | |
| password | Yes | String | Password | |
| db | Yes | String | Database base name | |
| charset | Yes | String | DB character set | |
| connectTimeout | Yes | Int | Connection timeout (Unit: second) |
Response
Response statuses
| HTTP status | Desc |
|---|---|
| 200 | OK (Successfully searched) |
| 400 | Bad Request |
| 401 | Unauthorized |
| 403 | Forbidden |
| 404 | Not Found |
| 500 | Internal Server Error |
Response body
List
Example
Request example
POST /CloudSearch/real/v1/db_upload/table
Host: cloudsearch.apigw.ntruss.com
accept:application/json
x-ncp-apigw-signature-v2: cDwtHuQeGmwWyNmwlN6XIGA66zge4iMXvfoDQNna05g=
x-ncp-apigw-timestamp: 1545817618751
x-ncp-iam-access-key: teGTwtcSEGA7fu28BGGi
{
"dbKind": "mysql",
"host": "2.2.2.2",
"port": 3306,
"user": "root",
"password": "alskdj",
"db": "cloud_search",
"charset": "utf8",
"connectTimeout": 4,
}
Response example
["test_database", "dev_database"]