Publish events to SDS via the REST interface

Before you can publish messages, SWS requires that you request for a token for the specific resource you intend to access. The returned token then needs to be included in the headers of subsequent POSTs. To get an authorization token we need to send a POST request as follows (substituting the IP address - or hostname - of the host where SWS is running):

POST     http://10.x.x.x:9093/1/authorization

The header needs to include basic authorization credentials, where the username and password are base64 encoded. So the header will look something like this:

authorization: Basic U0RTX1VTRVI6UGFzc3dvcmQx

But Postman will construct this for you, and do the encoding. Just go to the Authorization tab, enter your credentials, and click “Update Request”

And now go to the Body tab, select raw, and enter the payload. For this test, we need to request a token that will allow us to publish to the MACHINEDATA stream of the freezer_monitoring project running under the default workspace. Copy this and paste it into the body:

[
{ "privilege":"write", "resourceType":"stream", "resource":"default/freezer_monitor/MACHINEDATA"}
]

It will look like this in Postman:

Send the request and if you authenticate successfully, and have permission to write to this stream, the response will contain your authorization token. The response should look something like this:

[{"sws-token":"biVBFyKyPYgObPtmZc7y3ygn7e2hr4OoIQHjKtgQU1Hx75zunA3xDOBEQr08lCkhQFi4L7Ze9GNDb3rpNF1jEQ=="}]

Copy the token - you’ll need it in the next step. Don’t copy the full response, just the token and the surrounding quotes.

Note: The token is only valid for a set number of seconds, which is defined in SDS cluster configuration and can be changed from the HANA cockpit or using the command line tools. The default value is only 5 minutes. After this time period, a new token will need to be requested.

Now we’re ready to post our event to the MACHINEDATA input stream of the freezer_monitor project running in the default workspace. The URL for this call looks like this (substituting your IP address or hostname):

POST     http://10.x.x.x:9093/1/workspaces/default/projects/freezer_monitor/streams/MACHINEDATA

The header needs to include our authorization token. In Postman, go to the Headers tab and click on Bulk Edit. Paste in your authorization token and then copy and add the header prefix shown below

header prefix:  authorization:SWS-Token "sws-token"=

So that the full header looks something like this:

authorization:SWS-Token "sws-token"="biVBFyKyPYgObPtmZc7y3ygn7e2hr4OoIQHjKtgQU1Hx75zunA3xDOBEQr08lCkhQFi4L7Ze9GNDb3rpNF1jEQ=="

Here’s how the header will look in Postman:

Since Postman does not offer a “Token” authorization type, we must change the type back to No Auth so our new token doesn’t get over-written back to a BasicAuth. Go to the Authorization tab and select No Auth from the drop-down.

And now go to the Body tab, select raw, and enter the payload below and then press send.

[
{"ESP_OPS":"i", "MACHINEID":"1A", "EVENT_TIME": "2013-03-10T04:45:36.123", "EVENT_NAME":"DOOR", "EVENT_DESCRIPTION":"door open event", "EVENT_VALUE":"Door open"}
]

Here’s how the body will look in Postman:

The first part - "ESP_OPS":"i" - tells SDS this is an insert event. Our freezer_monitor project is only designed to process insert events. SDS also supports update, upsert and delete events based on primary keys, but that’s beyond the scope of this tutorial.

In the studio, check the stream viewer to see that your event arrived and was processed.

You can publish additional events if you like, simply editing the body with different values. Note that for all the features of this demo project to work, you’ll want to stick to these values:

• MACHINEID should be one of: 1A, 2B, 3C, 4D, 5E, 6F, 7G in order to successfully join to the HANA table containing reference data for each machine
• EVENT_NAME should be one of: TEMP, DOOR, or POWER
• For power events, EVENT_VALUE should be either Power on or Power off

Also, some notes on the structure of the body:

The JSON message body can be sent in either of 2 formats:

• Map format
• Array format

Above we used the map format. Note that with the map format, you don’t have to include every field. Fields that are not included will be set to NULL. You can also include multiple events in a single POST like this:

[
{ "ESP_OPS":"<opcode>", "<field1>":<value1>, "<field2>":<value2>, … },
{ "ESP_OPS":"<opcode>", "<field1>":<value1>, "<field2>":<value2>, … }
]

The structure of the array format is more compact (and a bit more efficient) but is less forgiving:

[
[ "<opcode>", <value1>, <value2>, <value3>, …],
[ "<opcode>", <value1>, <value2>, <value3>, …]
]

With this method, every field must be sent a value, and the order they are typed must correspond to the schema.