MENU
      Map DB table (VPC)

        Map DB table (VPC)


        Article summary

        After accessing the user's DB and importing the table information, map according to the schema of Cloud Search, and then return.

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

        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
        tableYesStringDB table
        connectTimeoutYesIntConnection timeout (Unit: second)

        Response

        Response Status
        ###

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

        Response body

        Schema

        Example

        Request example

        POST /CloudSearch/real/v1/db_upload/table/vpc
        Host: cloudsearch.apigw.ntruss.com
        accept:application/json
        {
          "dbKind": "mysql",
          "host": "111112233",
          "port": 23306,
          "user": "root",
          "password": "Cloudsearch,
          "db": "test_db",
          "charset": "utf8",
          "connectTimeout": 30,
          "table": "test_data"
        }
        HTTP

        Response example

        {
          "document": {
            "sections": [
              {
                "name": "tid"
              },
              {
                "name": "first_name"
              },
              {
                "name": "last_name"
              },
              {
                "name": "gender"
              },
              {
                "name": "ip_address"
              },
              {
                "name": "index_type"
              }
            ],
            "indexes": [],
            "primarySectionName": "tid"
          }
        }
        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.