Stroom Search API

1. Create an API Key for yourself, this will allow the API to authenticate as you and run the query with your privileges.

2. Create a Dashboard that extracts the data you are interested in. You should create a Query and Table.

3. Download the JSON for your Query. Press the download icon in the Query Pane to generate a file containing the JSON. Save the JSON to a file named query.json.

4. Use curl to send the query to Stroom.

   API_KEY='<put your API Key here' \
   URI=stroom.host/api/searchable/v2/search \
   curl \
   -s \
   --request POST \
   ${URL} \
   -o response.out \
   -H "Authorization:Bearer ${API_KEY}" \
   -H "Content-Type: application/json" \
   --data-binary @query.json

5. The query response should be in a file named response.out.

6. Optional step: reformat the response to csv using jq.

   cat response.out | jq '.results[0].rows[].values | @csv'