Configure tables for FairCom DB Notify

"includeMetadata": 
[
  {
    "propertyPath": "device.name",
    "propertyValue": "any JSON value: string, number, true, false, null, {} [], [{}]"
  }
]

The string assigned to the "propertyPath" property is the path where the target property is located in the target JSON document. A JSON path containing a single property name, such as "device", creates a property with that name in the target JSON document.

When a JSON path contains multiple property names, separate each property name with a period, such as "device.name". Each property name in a path represents a nested JSON object. When a JSON path specifies the name of a property that does not exist in the target JSON document, the server creates the property.

You can use a JSON path to assign a value to a specific array element. Use the square brackets to specify the array position, such as "device.sensors[0]".

You can add properties to any location in a JSON document. You can assign any valid JSON value to a property, including a string, number, true, false, null, object, or array.

You can start with any JSON document, such as an empty object.

{}

You can use the "includeMetadata" property to add a "device" property to the target JSON document. Its value can be as simple or complex as you want.

{
  "includeMetadata": [
    {
      "propertyPath": "device",
      "propertyValue": {
        "name": "stamper1",
        "sensors": [ "humidity", "temperature", "pressure" ]
      }
    }
  ]
}

The server updates the JSON document to include a "device" property containing the JSON object.

{
  "device": {
    "name": "stamper1",
    "sensors": [ "humidity", "temperature", "pressure" ]
  }
}

You may want to add properties to specific locations in a JSON document.

For example, you can use JSON path notation to add nested properties to a JSON document, such as adding a "name" property to the "device" object.

You can start with any JSON document.

{
  "device": 
  {
    "active": true
  }
}

{
  "includeMetadata": [
    {
      "propertyPath": "device.name",
      "propertyValue": "stamper1"
    }
  ]
}

The server adds the "name" property with a value of "stamper1" to the "device" object.

{
  "device": 
  {
    "active": true,
    "name": "stamper1"
  }
}

The server creates properties as needed. For example, if the "device" property does not exist in the source JSON document, the server creates it and adds the "name" property to it.

You may want to enrich a source JSON document by adding properties to specific elements to arrays.

You can start with any JSON document.

{
  "device": 
  {
    "name": "stamper1",
    "sensors": [ "humidity"]
  }
}

For example, you can use JSON path notation to assign a "temperature" value to the second element of the "sensors" property and assign a "pressure" value to the third element. The server creates properties and array elements as needed.

{
  "includeMetadata": [
    {
      "propertyPath": "device.sensors[1]",
      "propertyValue": "temperature"
    },
    {
      "propertyPath": "device.sensors[2]",
      "propertyValue": "pressure"
    }
  ]
}

The server adds the "temperature" and "pressure" values to the "sensors" array.

{
  "device": 
  {
    "name": "stamper1",
    "sensors": [ "humidity", "temperature", "pressure" ]
  }
}

The server creates properties as needed. For example, if the "device" property does not exist in the source JSON document, the server creates it and adds the "sensors" property to it.

When a specified element already exists in the array, the server replaces it with the specified value. When a specified element does not exist in the array, the server appends the value to the end of the array.