MENU
      Search DB table

        Search DB table


        Article summary

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

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

        Request

        Request body

        Parameter nameRequirement statusTypeRestrictionsExplanation
        dbKindYesStringmysql, mariadbDB type
        hostYesStringDB IP
        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
        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,
        }
        HTTP

        Response example

        ["test_database", "dev_database"]
        JSON

        Was this article helpful?

        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.