Send Grid Integration Payload Format

Below is an example of the payload that is available for use with send grid emails that are tied to the onping integration.

• company – The name of the company that is hosting the parameter in this cell.
• site – The name of the site that is where the parameter is located.
• location – The name of the device that hosts the parameter.
• result – The computed value (after masking) of the cell.
• description – The description of the pid (as seen in data analysis or other places in OnPing).
• display – The value as displayed in the event table (most commonly used data).

An example Event Table

Here is an example payload:

      {
        "cells": [
          {
            "company": "Demo Video Company",
            "site": "Demo Video Site",
            "location": "Demo Video Location",
            "result": 11.83,
            "descrption": "Battery Voltage",
            "display": "01/27/2023- 03:22:00"
          },
          {
            "company": "Demo Video Company",
            "site": "Demo Video Site",
            "location": "Demo Video Location",
            "result": 11.83,
            "descrption": "Battery Voltage",
            "display": "11.83"
          }
        ]
      }
    

Here is what your send grid template might look like…

Thanks for using OnPing: The current value of your battery is {{cells.[1].display}} volts.

It last updated on: {{cells.[0].display}}.

The output would look like:

Thanks for using OnPing: The current value of your battery is 11.83 volts.

It last updated on: 01/27/2023- 03:22:00.