Welcome to the Microsoft SQL Server Element

At a Glance

In order to create a connection to a Microsoft SQL Server Database, the following steps are required:

  1. Choose how to connect:
    • Directly via an IP Address and Port Number, e.g.
    • Use Cloud Elements Ground2Cloud service to connect your Database
  2. Call the POST /instances API to instantiate your Microsoft SQL Server Database

In Depth

The Microsoft SQL Server Element leverages the tables contained within your Microsoft SQL Server database and transforms them into a collection of resources. RESTful methods (POST, GET, PATCH, DELETE) are used to interact with these resources (accounts, contacts, files). The columns in the table become the modeling attributes used to send payloads with each API call. For example a database with the following columns of data:

name phone address
Jon Doe 333-333-3333 123 Main

transforms to this JSON body:

  "name": "Jon Doe",
  "phone": 333-333-3333,
  "address": "123 Main"

If the table contains a primary key, the Retrieve, Update, and Delete by ID APIs can be generated. If a table does not have a primary key or contains multiple primary keys, the Retrieve, Update, and Delete by ID APIs cannot be generated.

Elements leverage Cloud Elements API Manager platform services including authentication and data transformation. The API is built to allow you to create a functional application or integration quickly and easily.

All API calls to Cloud Elements should be made to the https://api.cloud-elements.com/elements/api-v2 base domain. Requests are authorized with an Organization and User secret, as well as, an Element token. We use many standard HTTP features, like HTTP verbs, which can be understood by many HTTP clients. JSON will be returned in all responses from the API, including errors. The APIs are designed to have predictable, straightforward URLs and to use HTTP response codes to indicate API errors.

NOTE: We currently limit result sets to 50 rows for all Database Elements

NOTE: API Docs are not available for viewing as they are generated based on the information contained in the Database Table.

Get started by selecting how to connect your database.