{
  "format": "janus-integrations-v1",
  "definitions": [
    {
      "id": "mes-feed",
      "content": {
        "name": "MES work-order feed",
        "kind": "sql",
        "endpoint": "MES_PROD",
        "method": "",
        "body": "",
        "headers": [],
        "inputs": [
          {
            "name": "cursor",
            "type": "number"
          }
        ],
        "mappings": [
          {
            "from": "WorkOrder",
            "to": "workOrder",
            "rule": "external"
          },
          {
            "from": "PartNo",
            "to": "item",
            "rule": "external"
          },
          {
            "from": "RequiredQty",
            "to": "required",
            "rule": "external"
          }
        ],
        "success": {
          "field": "WorkOrder",
          "op": "exists",
          "value": ""
        },
        "sql": {
          "server": "mes-sql01",
          "database": "MES_PROD",
          "account": "janus_mes_read",
          "statement": "SELECT WorkOrder, PartNo, RequiredQty, ChangeSeq FROM dbo.WorkOrderMaterial WHERE ChangeSeq > @cursor",
          "readOnlyProfile": true
        }
      }
    }
  ]
}