MENU
      Run DB upload (VPC)

        Run DB upload (VPC)


        Article summary

        Run the DB upload feature for the domain.

        POST https://cloudsearch.apigw.ntruss.com/CloudSearch/real/v1/domain/{name}/document/manage/db_upload/vpc
        HTTP

        Request

        Request parameters

        Parameter nameRequirement statusTypeRestrictionsExplanation
        nameYesstringDomain name createdDomain name to search autocomplete history
        regionYesstringregion codeThe region code where the DB server is located

        Request

        Request body

        Parameter nameRequirement statusTypeRestrictionsExplanation
        dbKindYesStringmysql, mariadbDB type
        hostYesStringDB Instance ID
        portYesIntegerDB port
        userYesStringUser ID
        passwordYesStringPassword
        dbYesStringDatabase base name
        charsetYesStringDB character set
        keyFieldYesStringKey column to apply
        indexTypeFieldYesStringIndex column to apply
        sqlYesStringDB query
        connectTimeoutYesIntConnection timeout (Unit: second)

        Response

        Response statuses

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

        Example

        Request example

        POST /CloudSearch/real/v1/domain/eeee/document/manage/db_upload/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",
            "keyField": "id",
            "indexTypeField": "index_type",
            "sql": "select * from test_data",
            "connectTimeout": 4,
        }
        HTTP

        Database example

        tidfirst_namelast_namegenderip_addressindex_type
        1VasiliGodsmarkMale62.135.174.46upsert
        2SwenRumbelowMale201.122.144.133delete
        3DavitaOvingtonFemale57.80.83.212insert
        4BerriGarwoodFemale76.35.55.206update

        Response example

        {"result":"ok"}
        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.