Transaction Query

A useful connector that can be used to extract data out of the utopia transaction logs. This can be extremely useful for build various csv data dumps for reporting and notifications. You can basically create your own MongoDB aggregation here to query the transaction data. You input this into the “MongoQuery” node. You can then add an “InitialValue” field to tell the connector to filter the query by a certain date. It will then update this on every pole so that you only get the latest results. EG:

{
  "Request": {
    "MongoQuery": {
      "$match": {
        "$and": [
          {
            "$or": [
              {
                "Title": "ConnectorName1"
              },
              {
                "Title": "ConnectorName2"
              }
            ]
          },
          {
            "ErrorCount": {
              "$gt": 0
            }
          }
        ]
      }
    },
    "InitialValue": "2022-06-07T01:49:10.878+00:00"
  }
}