Map DB table
    • PDF

    Map DB table

    • PDF

    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
    

    Request

    Request body

    Parameter nameRequirement statusTypeRestrictionsExplanation
    dbKindYesStringmysql, mariadbDB type
    hostYesStringDB IP
    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
    Host: cloudsearch.apigw.ntruss.com
    accept:application/json
    {
      "dbKind": "mysql",
      "host": "2.2.2.2",
      "port": 23306,
      "user": "root",
      "password": "Cloudsearch,
      "db": "test_db",
      "charset": "utf8",
      "connectTimeout": 30,
      "table": "test_data"
    }
    

    Response example

    {
      "document": {
        "sections": [
          {
            "name": "tid"
          },
          {
            "name": "first_name"
          },
          {
            "name": "last_name"
          },
          {
            "name": "gender"
          },
          {
            "name": "ip_address"
          },
          {
            "name": "index_type"
          }
        ],
        "indexes": [],
        "primarySectionName": "tid"
      }
    }
    

    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.