DB Table 매핑
    • PDF

    DB Table 매핑

    • PDF

    Article Summary

    user의 DB에 접근하여 table 정보를 가져온후, cloud search의 schema에 맞게 매핑하여 반환합니다.

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

    요청

    요청 바디

    파라미터명필수 여부타입제약 사항설명
    dbKindYesStringmysql, mariadbDB 종류
    hostYesStringDB의 IP
    portYesIntegerDB 포트
    userYesString사용자 아이디
    passwordYesString비밀번호
    dbYesStringDatabase 이름
    charsetYesStringDB의 character
    tableYesString테이블
    connectTimeoutYesIntconnection 타임아웃, 단위 second

    응답

    응답 Status

    HTTP StatusDesc
    200OK(조회 완료)
    400Bad Request
    401Unauthorized
    403Forbidden
    404Not Found
    500Internal Server Error

    응답 body

    Schema

    예시

    요청 예시

    POST /CloudSearch/real/v1/db_upload/table
    Host: cloudsearch.apigw.ntruss.com
    Content-Type: 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": 23306,
      "user": "root",
      "password": "Cloudsearch",
      "db": "test_db",
      "charset": "utf8",
      "connectTimeout": 30,
      "table": "test_data"
    }
    

    응답 예시

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

    이 문서가 도움이 되었습니까?

    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.