When an operator clicks a submit button on a diagram which is configured to output to the database, a record will be written to the SQL database which will contain several pieces of information that may be useful to developers building custom integrations:

• OutputTimeStamp: The UTC date/time of the record. For cases where timing must be very precise, note that this is the time the record was written into the database, not the time the button was clicked. Depending on network, computer hardware, etc. there will be a difference between the two.
• Output: A JSON document containing all the information gathered when the operator clicked the button. See below for the format of that document.
• Operator: The name of the Prophecy user account that clicked the button.

Each shape object includes some additional information beyond just the selected value - the entire list of options in a dropdown, for example. When it is impossible to gather a piece of information that would normally be included (for example, the name of an IDO Definition) the property will be included with a value of null. The JSON document in the Output column will be formatted like this:

{
  "entityId": "dd5fa5c1-581d-4c57-b869-02f7dd32a24d",
  "diagramId": "840540fa-87f7-4d26-98eb-f5badefdcf11",
  "diagramName": "MyDiagramName",
  "operator": "admin",
  "values": [
    {
      "name": "Hard-coded Test Value",
      "value": "Dodge this!",
      "source": "Predefined"
    },
    {
      "name": "Date from Token",
      "value": "03/23/2020 13:40:02",
      "source": "Token"
    },
    {
      "name": "Direct from Tag",
      "value": "330",
      "source": "Tag",
      "tagName": "Oven Temp",
      "tagParameter": "Value"
    },
    {
      "name": "Grid with Escaped Special Characters",
      "value": "FTAutomation",
      "source": "Shape",
      "shapeInfo": {
        "shapeType": "Grid",
        "shapeName": "Grid_acb4adb1",
        "idoConnection": "TestSL",
        "idoDefinition": "SLUserNames",
        "filters": [],
        "row": [
          {
            "column": "Username",
            "value": "FTAutomation"
          },
          {
            "column": "UserDesc",
            "value": "FactoryTrack Automation User"
          },
          {
            "column": "EditLevel",
            "value": "0"
          },
          {
            "column": "LastActiveDate",
            "value": "19791227 11:44:37.290"
          },
          {
            "column": "WorkstationLogin",
            "value": "gdeinfor2\\FTAutomation"
          }
        ]
      }
    },
    {
      "name": "Tag Value Shape",
      "value": "330",
      "source": "Shape",
      "shapeInfo": {
        "shapeType": "TagValue",
        "shapeName": "TagValue_f97674c5",
        "tagName": "Oven Temp",
        "tagParameter": "Value"
      }
    },
    {
      "name": "Text Input",
      "value": "Is this thing on?",
      "source": "Shape",
      "shapeInfo": {
        "shapeType": "TextBox",
        "shapeName": "TextBox_72f9c11b"
      }
    },
    {
      "name": "Dropdown",
      "value": "3",
      "source": "Shape",
      "shapeInfo": {
        "shapeType": "Dropdown",
        "shapeName": "Dropdown_6d9289a5",
        "options": [
          {
            "text": "Sunday",
            "value": "0"
          },
          {
            "text": "Monday",
            "value": "1"
          },
          {
            "text": "Tuesday",
            "value": "2"
          },
          {
            "text": "Wednesday",
            "value": "3"
          },
          {
            "text": "Thursday",
            "value": "4"
          },
          {
            "text": "Friday",
            "value": "5"
          },
          {
            "text": "Saturday",
            "value": "6"
          }
        ]
      }
    },
    {
      "name": "Combo",
      "value": "Leonardo",
      "source": "Shape",
      "shapeInfo": {
        "shapeType": "ComboBox",
        "shapeName": "ComboBox_c458e718",
        "options": [
          {
            "text": "Leonardo",
            "value": "Leonardo"
          },
          {
            "text": "Donatello",
            "value": "Donatello"
          },
          {
            "text": "Raphael",
            "value": "Raphael"
          },
          {
            "text": "Michaelangelo",
            "value": "Michaelangelo"
          }
        ]
      }
    },
    {
      "name": "Switch",
      "value": "true",
      "source": "Shape",
      "shapeInfo": {
        "shapeType": "Switch",
        "shapeName": "Switch_b601b502"
      }
    },
    {
      "name": "Mongoose Value",
      "value": "2842",
      "source": "Shape",
      "shapeInfo": {
        "shapeType": "MongooseValue",
        "shapeName": "MongooseValue_06bf5e75",
        "idoConnection": "TestSL",
        "idoDefinition": null,
        "idoDefinitionProperty": null,
        "filters": [
          {
            "index": "0",
            "value": "PortalPreLogin"
          }
        ]
      }
    },
    {
      "name": "Mongoose Dropdown",
      "value": "PortalPreLogin",
      "source": "Shape",
      "shapeInfo": {
        "shapeType": "MongooseDropdown",
        "shapeName": "Dropdown_201558f4",
        "idoConnection": "TestSL",
        "idoDefinition": "Usernames",
        "idoDefinitionProperty": "Username",
        "filters": [],
        "options": [
          {
            "text": "sa",
            "value": "sa"
          },
          {
            "text": "SL_Internal",
            "value": "SL_Internal"
          },
          {
            "text": "syteline",
            "value": "syteline"
          },
          {
            "text": "COMobile",
            "value": "COMobile"
          },
          {
            "text": "EXMobile",
            "value": "EXMobile"
          },
          {
            "text": "FreddieMercury",
            "value": "FreddieMercury"
          }
        ]
      }
    },
    {
      "name": "Mongoose Combo",
      "value": "FORMAT(oCHSVoucherTotalReport)",
      "source": "Shape",
      "shapeInfo": {
        "shapeType": "MongooseComboBox",
        "shapeName": "ComboBox_1a6099f3",
        "idoConnection": "TestSL",
        "idoDefinition": "IdoCollections",
        "idoDefinitionProperty": "Caption",
        "filters": [],
        "options": [
          {
            "text": "FORMAT(oABDataServices)",
            "value": "FORMAT(oABDataServices)"
          },
          {
            "text": "FORMAT(oABProjectRoles)",
            "value": "FORMAT(oABProjectRoles)"
          },
          {
            "text": "FORMAT(oABProjects)",
            "value": "FORMAT(oABProjects)"
          }
        ]
      }
    }
  ]
}