Using SQL Stream Builder REST API

You can use the REST API to monitor, manage and configure the SQL Stream jobs with GET and POST HTTP methods. You can use the SQL Stream Builder (SSB) REST API in command line, import them to REST API Tools or by accessing the Swagger UI.

The following HTTP methods are available for SSB:
  • GET to query information about the specified endpoint
  • POST to create resources for the specified endpoint

The REST API Reference document contains the available endpoints for SQL Stream Builder.

You can use the SSB REST API with Command Line Interface (CLI), you can also import the REST API swagger.json file to a REST API Tool, for example Postman, and you also have the option to use the REST API with the Swagger User Interface (UI).

Using REST API with CLI

When using the SSB REST API with CLI Tool, you need to create the POST or GET commands with curl, and also include the Streaming SQL Engine hostname, port and the required operation for the endpoint. The submitted commands return the information, or complete the process you have requested and display the status in the CLI.

The following examples show a secured and unsecured GET method to list the SQL jobs:

$ curl -H 'Username: <your-username>' \
       'https://<cluster-domain>:<streaming-sql-engine-server-port>/api/v1/ssb/jobs'
$ kinit <your-user>
$ curl -ik --negotiate -u: \
       'https://<cluster-domain>:<streaming-sql-engine-server-port>/api/v1/ssb/jobs'
$ curl -ik --negotiate -u <knox_username>:<knox_password> \
       'https://<cluster-domain>:<streaming-sql-engine-server-port>/gateway/cdp-proxy-api/ssb-sse-api/api/v1/ssb/jobs'

Using REST API Tool

When using REST API Tools, you need to connect to the cluster that hosts the SQL Stream Builder REST API. You can also use the following URL in a browser to download the swagger.json file when you need to manually upload the REST API endpoints for a Tool.

http(s)://<cluster-domain>:<streaming-sql-engine-server-port>/swagger/api-docs/public

Using Swagger UI

You can access the Swagger UI to use the SSB REST API by adding your hostname and the Streaming SQL Engine port to the Swagger UI URL.

http(s)://<cluster-domain>:<streaming-sql-engine-server-port>/swagger-ui/index.html?configUrl=/swagger/api-docs/swagger-config

You can also download the swagger.json for the SSB REST API using the Swagger UI.