Search DB table (VPC)
    • PDF

    Search DB table (VPC)

    • PDF

    Article Summary

    Import a table list by accessing the user's DB.

    POST https://cloudsearch.apigw.ntruss.com/CloudSearch/real/v1/db_upload/table/vpc
    

    Request

    Request parameters

    Parameter nameRequirement statusTypeRestrictionsExplanation
    regionYesstringregion codeThe region code where the DB server is located

    Request body

    Parameter nameRequirement statusTypeRestrictionsExplanation
    dbKindYesStringmysql, mariadbDB type
    hostYesStringDB Instance ID
    portYesIntegerDB port
    userYesStringUser ID
    passwordYesStringPassword
    dbYesStringDatabase base name
    charsetYesStringDB character set
    connectTimeoutYesIntConnection timeout (Unit: second)

    Response

    Response statuses

    HTTP statusDesc
    200OK (Successfully searched)
    400Bad Request
    401Unauthorized
    403Forbidden
    404Not Found
    500Internal Server Error

    Response body

    List

    Example

    Request example

    POST /CloudSearch/real/v1/db_upload/table/vpc
    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": "1111223",
        "port": 3306,
        "user": "root",
        "password": "alskdj",
        "db": "cloud_search",
        "charset": "utf8",
        "connectTimeout": 4,
    }
    

    Response example

    ["test_database", "dev_database"]
    

    Was this article helpful?

    What's Next
    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.