Access the Data API
SingleStore's Data API can be accessed using Basic Authentication method at protocol://hostname:port/api/version/
where:
protocol
is HTTPS/HTTP; protocol must be HTTPS when SSL is enabledhostname
represents the host where SingleStoreDB is runningport
is the secure WebSocket proxy port configuredversion
is the Data API version; currently v1 and v2 are supported
To access SingleStore’s Data API via Basic Authentication, you need to provide your SingleStore account credentials (username and password) in each HTTP request. The credentials must be passed as a Base-64 encoded username:password
string in the Authorization header in the HTTP client. For example, the Authorization header of demo:Afu4XjzB1ns
would appear as follows.
Authorization: Basic ZGVtbzpBZnU0WGp6QjFucw==
Using an HTTP client such as cURL, you can either pass your credentials as parameters in the --user
or the -u
option or add them before the hostname
in the HTTP request, as shown below.
curl -u "username:password" https://hostname:port/api/v2/exec
curl https://username:password@hostname:port/api/v2/exec
cURL will then encode the username:password
string using Base-64 and insert it in an Authorization header before sending the HTTP request to the server.
You can use API development tools and libraries to send Data API requests and handle responses. You can also test-run the Data API at the Linux command line. For more information on how to use the Data API, refer to Data API Endpoint Reference.