getCloudMssqlImageProductList
    • PDF

    getCloudMssqlImageProductList

    • PDF

    Article Summary

    Available in VPC

    Views Cloud DB for MSSQL product code list.

    Requests

    Request Parameters

    ParameterTypeRequirement StatusDescriptionRestrictions
    regionCodeStringNRegion code
    - regionCode can be obtained via the getRegionList action
    - default: Selects the first region of the getRegionList query results
    -
    productCodeStringNCloud DB for MSSQL image product code to be viewed
    - productCode can be obtained via the getCloudMssqlImageProductList action's productCode
    -
    exclusionProductCodeStringNCloud DB for MSSQL image product code to be excluded
    - exclusionProductCode can be obtained via the getCloudMssqlImageProductList action's productCode
    -
    responseFormatTypeStringNFormat type of the response result
    - options: xml | json
    - default: xml
    -

    Responses

    Response bodies

    For response bodies, refer to ProductList.

    Examples

    Request Examples

    The following is an example of a request body.

    GET {API_URL}/getCloudMssqlImageProductList
    ?regionCode=KR
    &productCode=SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.SE.B100
    

    Response examples

    The following are examples of responses.

    If the response shows that format type (responseFormatType) is json

    {
      "getCloudMssqlImageProductListResponse": {
        "requestId": "c5d74898-60f7-4ac2-a9a8-23485ed70feb",
        "returnCode": 0,
        "returnMessage": "success",
        "totalRows": 3,
        "productList": [
          {
            "productCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.EE.B100",
            "productName": "MSSQL 15.0.2000.5 Enterprise Edition",
            "productType": {
              "code": "WINNT",
              "codeName": "Windows NT"
            },
            "productDescription": "Windows Server 2016 with MSSQL 2019 RTM (15.0.2000.5) Enterprise English Edition",
            "infraResourceType": {
              "code": "SW",
              "codeName": "Software"
            },
            "baseBlockStorageSize": 107374182400,
            "platformType": {
              "code": "WND64",
              "codeName": "Windows 64 Bit"
            },
            "osInformation": "Windows Server 2016 with MSSQL 15.0.2000.5 Enterprise Edition",
            "generationCode": "G2"
          },
          {
            "productCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15041982.SE.B100",
            "productName": "MSSQL 15.0.4198.2 Standard Edition",
            "productType": {
              "code": "WINNT",
              "codeName": "Windows NT"
            },
            "productDescription": "Windows Server 2016 with MSSQL 2019 RTM (15.0.4198.2) Standard English Edition",
            "infraResourceType": {
              "code": "SW",
              "codeName": "Software"
            },
            "baseBlockStorageSize": 107374182400,
            "platformType": {
              "code": "WND64",
              "codeName": "Windows 64 Bit"
            },
            "osInformation": "Windows Server 2016 with MSSQL 15.0.4198.2 Standard Edition",
            "generationCode": "G2"
          },
          {
            "productCode": "SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15041982.EE.B100",
            "productName": "MSSQL 15.0.4198.2 Enterprise Edition",
            "productType": {
              "code": "WINNT",
              "codeName": "Windows NT"
            },
            "productDescription": "Windows Server 2016 with MSSQL 2019 RTM (15.0.4198.2) Enterprise English Edition",
            "infraResourceType": {
              "code": "SW",
              "codeName": "Software"
            },
            "baseBlockStorageSize": 107374182400,
            "platformType": {
              "code": "WND64",
              "codeName": "Windows 64 Bit"
            },
            "osInformation": "Windows Server 2016 with MSSQL 15.0.4198.2 Enterprise Edition",
            "generationCode": "G2"
          }
        ]
      }
    }
    

    If the response shows that format type (responseFormatType) is xml

    <getCloudMssqlImageProductListResponse>
        <requestId>c5d74898-60f7-4ac2-a9a8-23485ed70feb</requestId>
        <returnCode>0</returnCode>
        <returnMessage>success</returnMessage>
        <totalRows>3</totalRows>
        <productList>
            <product>
                <productCode>SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15020005.EE.B100</productCode>
                <productName>MSSQL 15.0.2000.5 Enterprise Edition</productName>
                <productType>
                    <code>WINNT</code>
                    <codeName>Windows NT</codeName>
                </productType>
                <productDescription>Windows Server 2016 with MSSQL 2019 RTM (15.0.2000.5) Enterprise English Edition</productDescription>
                <infraResourceType>
                    <code>SW</code>
                    <codeName>Software</codeName>
                </infraResourceType>
                <baseBlockStorageSize>107374182400</baseBlockStorageSize>
                <platformType>
                    <code>WND64</code>
                    <codeName>Windows 64 Bit</codeName>
                </platformType>
                <osInformation>Windows Server 2016 with MSSQL 15.0.2000.5 Enterprise Edition</osInformation>
                <generationCode>G2</generationCode>
            </product>
            <product>
                <productCode>SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15041982.SE.B100</productCode>
                <productName>MSSQL 15.0.4198.2 Standard Edition</productName>
                <productType>
                    <code>WINNT</code>
                    <codeName>Windows NT</codeName>
                </productType>
                <productDescription>Windows Server 2016 with MSSQL 2019 RTM (15.0.4198.2) Standard English Edition</productDescription>
                <infraResourceType>
                    <code>SW</code>
                    <codeName>Software</codeName>
                </infraResourceType>
                <baseBlockStorageSize>107374182400</baseBlockStorageSize>
                <platformType>
                    <code>WND64</code>
                    <codeName>Windows 64 Bit</codeName>
                </platformType>
                <osInformation>Windows Server 2016 with MSSQL 15.0.4198.2 Standard Edition</osInformation>
                <generationCode>G2</generationCode>
            </product>
            <product>
                <productCode>SW.VMSSL.OS.WND64.WINNT.SVR2016.MSSQL.15041982.EE.B100</productCode>
                <productName>MSSQL 15.0.4198.2 Enterprise Edition</productName>
                <productType>
                    <code>WINNT</code>
                    <codeName>Windows NT</codeName>
                </productType>
                <productDescription>Windows Server 2016 with MSSQL 2019 RTM (15.0.4198.2) Enterprise English Edition</productDescription>
                <infraResourceType>
                    <code>SW</code>
                    <codeName>Software</codeName>
                </infraResourceType>
                <baseBlockStorageSize>107374182400</baseBlockStorageSize>
                <platformType>
                    <code>WND64</code>
                    <codeName>Windows 64 Bit</codeName>
                </platformType>
                <osInformation>Windows Server 2016 with MSSQL 15.0.4198.2 Enterprise Edition</osInformation>
                <generationCode>G2</generationCode>
            </product>
        </productList>
    </getCloudMssqlImageProductListResponse>
    

    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.