Description

I want to query the data in our Elastic Cloud instance using the REST API with authorization via API Key.

Steps taken

I tried using the SQL API as well as the Search API. NB that I would much preferably use the SQL API.

Based on the following curl commands provided in the documentation:

curl -X POST "localhost:9200/_sql?format=txt&pretty" -H 'Content-Type: application/json' -d'
{
  "query": "SELECT * FROM library WHERE release_date < \u00272000-01-01\u0027"
}
'

3. Click on Copy Endpoint for the Elasticsearch endpoint:

The Authorization header was malformed

The Authorization header for an ApiKey powered request is the following:

ApiKey {B64_ENCODE('API_KEY_ID:API_KEY_KEY')}

Which can be written in python as:

"ApiKey " str(base64.standard_b64encode(bytes('API_KEY_ID:API_KEY_KEY', 'utf-8')), 'utf-8')

On a final note, the team also strongly suggested I look at their Free on-demand Elasticsearch training.

Hopefully this will be helpful to whoever passes by here!