Audit (REST)

• Action

  (('Action' IN CHOICE [1048406, 1048444]))

  Note: Audit actions are Relativity choices. You can find the value of Artifact IDs of the choices on the Data Grid Audit Field Mapping tab (Relativity Choice ID Column). You can also query the choices for the Action field programmatically.

• Artifact ID - the ID of the Relativity artifact associated with the audit record.

  (('Artifact ID' == 1003663))

• Audit record ID

  (('Audit ID' == 393901))

• Complex condition - an example is a complex condition that combines date, object type, and action.

  (('Timestamp' >= 2017-11-01T00:00:00.00Z AND 'Timestamp' <= 2017-11-23T23:59:00.00Z))
       AND (('Object Type' == CHOICE 1048471)) 
            AND (('Action' IN CHOICE [1048406, 1048444]))

• Execution Time (in milliseconds)

  (('Execution Time (ms)' > 1000))

• Object type

  (('Object Type' == CHOICE 1048471))

  Note: Object Type values are Relativity choices. You can find the value of Artifact IDs of the choices on the tab by filtering for Data Grid Audit object type and the Object Type field. You can also query the choices for the Object Type field programmatically.

• Old value or new value

  (('New Value' LuceneSearch 'oil OR gas'))

  Note: Beginning in 10.1.169.1, Lucene Search is deprecated in Relativity.

• Timestamp

  (('Timestamp' >= 2017-11-01T00:00:00.00Z AND 'Timestamp' <= 2017-11-23T23:59:00.00Z))

The request contains must contain the following fields:

• workspaceId - the Artifact ID of the workspace containing the action that you want to revert. This field is optional in the request. If a mismatch occurs between the ID in this field and the URL, then the ID in the URL is used in the request.
• request - represents a request to revert an action. It contains the following fields:
  • AuditId - the identifier assigned by Relativity to an audit action.
  • Timestamp - the date and time of the audit action.

    Note: The request requires the Timestamp and Id fields to uniquely identify the audit record.

{
    "workspaceId": 1018053,
    "request": {
        "AuditId": "430133",
        "Timestamp": "2019-04-25T16:05:24.867"
    }
}

The response contains the following fields:

• AuditId - the identifier assigned by Relativity to an audit.
• Timestamp - the date and time of the audit action.
• IsRevertable - a Boolean value indicating whether you can revert an audit action.
• Message - information explaining why an audit action can't be reverted.

An audit that can be reverted

{
    "AuditId": "1409184",
    "Timestamp": "2019-05-22T15:10:42.877",
    "IsRevertable": true
}

An audit that can't be reverted

{
    "AuditId": "430133",
    "Timestamp": "2019-04-25T16:05:24.867",
    "IsRevertable": false,
    "Message": "This audit does not represent the most recent change to this document."
}

The request contains the following fields:

• workspaceId - the Artifact ID of the workspace containing the action that you want to revert. This field is optional in the request. If a mismatch occurs between the ID in this field and the URL, then the ID in the URL is used in the request.
• request - represents a request to revert an action. It contains the following fields:
  • AuditId - the identifier assigned by Relativity to an audit action.
  • Timestamp - the date and time of the audit action.

    Note: The request requires the Timestamp and Id fields to uniquely identify the audit record.

{
    "workspaceId": 1018053,
    "request": {
        "AuditId": "4301335",
        "Timestamp": "2019-04-25T16:05:24.867"
    }
}

The response contains the following fields

• Success - a Boolean value indicating whether the action was reverted.

• ValidationResponse - contains the following fields:
  • AuditId - the identifier assigned by Relativity to an audit.
  • Timestamp - the date and time of the audit action.
  • IsRevertable - a Boolean value indicating whether the audit action was reverted.
  • Message - information explaining why an audit action can't be reverted.

• Message - additional information about the revert operation.

A reverted audit

{
  "Success": true,
  "ValidationResponse": {
    "AuditId": "1409184",
    "Timestamp": "2019-05-22T15:10:42.877",
    "IsRevertable": true,
    "Message": null
  },
  "Message": null
}

An audit that can't be reverted

{
  "Success": false,
  "ValidationResponse": {
    "AuditId": "1409184",
    "Timestamp": "2019-05-22T15:10:42.877",
    "IsRevertable": false,
    "Message": "This audit does not represent the most recent change to this document."
  },
  "Message": null
}

The request must contain the following fields:

• Request - represents a request to revert multiple actions. It contains the following fields:
  • RevertAuditRequests - an array of audit actions to revert. Each audit action includes the following fields:
    • AuditId - the identifier assigned by Relativity to an audit.
    • Timestamp - the date and time of the audit action.

      Note: The request requires the Timestamp and Id fields to uniquely identify the audit record.

{
    "request": {
        "RevertAuditRequests": [
            {
                "AuditId": "1409184",
                "Timestamp": "2019-05-22T15:10:42.877"
            },
            {
                "AuditId": "1409411",
                "Timestamp": "2019-05-22T15:35:01.947"
            }
        ]
    }
}

The response contains the following fields:

• Success - a Boolean value indicating whether the action was reverted.

• ValidationResponses - contains the following fields for each action:
  • AuditId - the identifier assigned by Relativity to an audit.
  • Timestamp - the date and time of the audit action.
  • IsRevertable - a Boolean value indicating whether the audit action was reverted.
  • Message - information explaining why an audit action can't be reverted.

View a sample JSON response for reverting a list of audits

{
  "Success": false,
  "ValidationResponses": [
    {
      "AuditId": "1409184",
      "Timestamp": "2019-05-22T15:10:42.877",
      "IsRevertable": false,
      "Message": "This audit does not represent the most recent change to this document."
    },
    {
      "AuditId": "1409411",
      "Timestamp": "2019-05-22T15:35:01.947",
      "IsRevertable": true,
      "Message": null
    }
  ]
}

The request contains the following fields:

• workspaceId - the Artifact ID of the target workspace. This field is optional in the request. If a mismatch occurs between the ID in this field and the URL, then the ID in the URL is used in the request.
• settings - represents the pivot fields to query. It contains the following fields:
  • GroupBy - the Artifact ID of the object to group by, such as the audit action or username.
  • PivotOn - the Artifact ID of the field to use as the pivot on value in the query and result set. For example, you might use the audit action, object type, or username. The field must have pivot functionality enabled on it.
  • ObjectSetQuery - defines a base set of documents or objects to run a Pivot query against. You can use the following properties on the ObjectSetQuery object for filtering:
    • Condition - the search criteria used in the query. For more information, see System types supported by the Query() method. This field is optional.
    • RowCondition - a filtering condition criteria for the result set. This field is optional. For example, you might set this field as follows: "RowCondition": "((('Audit ID' LIKE ['1409579'])))".
  • ConvertNumberFieldValuesToString - a Boolean value indicating whether to convert response field values to strings. This field is optional.
  • TimeZone - a timezone URL.
• cancel - a required field that contains the following:
  • RequestId - a GUID.
  • TicketId - a GUID.
• progress - a required field that contains the following:
  • RequestId - a GUID.
  • TicketId - a GUID.

Note: The use of progress indicators and cancellation tokens isn't supported, but you must include the cancel and progress fields in the request.

{
    "workspaceId": 1018053,
    "settings": {
        "GroupBy": {
            "ArtifactID": 1039619
        },
        "PivotOn": {
            "ArtifactID": 1039617
        },
        "ObjectSetQuery": {
            "Condition": "",
            "RowCondition": "(('User Name' == CHOICE 1039872))"
        },
        "ConvertNumberFieldValuesToString": true,
        "TimeZone": "America/Chicago"
    },
    "cancel": {
        "RequestId": "e54e41a4-d2fb-439c-b517-1717dafc00ee",
        "TicketId": "e54e41a4-d2fb-439c-b517-1717dafc00ee"
    },
    "progress": {
        "RequestId": "e54e41a4-d2fb-439c-b517-1717dafc00ee",
        "TicketId": "e54e41a4-d2fb-439c-b517-1717dafc00ee"
    }
}

The response contains the following fields:

• Results - an array of items that meet the criteria specified in the pivot query.
  • Timestamp - the date and time of the audit action.
  • List of data
  • Grand Total - the number of data elements.
• TotalCount - the total number of results returned by the pivot.
• QueryToken - reserved for future use.
• Success - a Boolean value indicating whether the query succeeded.
• Message - a message indicating the status of a pivot query. If the query failed, the message contains information about the errors that occurred.
• PivotIdToDisplayValueMap - if a PivotOn field is specified in the request, the object maps the system-generated pivot item IDs to display values for visualization.

{
    "Results": [
        {
            "Timestamp": "2019-04-16T05:00:00",
            "_x0039_": 5,
            "_x0033_": 1,
            "_x0032_8": 1,
            "_x0032_": 0,
            "_x0031_": 0,
            "_x0033_2": 0,
            "_x0032_9": 0,
            "_x0033_3": 0,
            "_x0033_5": 0,
            "_x0031_0": 0,
            "_x0035_8": 0,
            "_x0035_9": 0,
            "Grand Total": 7
        },
        {
            "Timestamp": "2019-04-17T05:00:00",
            "_x0039_": 0,
            "_x0033_": 0,
            "_x0032_8": 0,
            "_x0032_": 0,
            "_x0031_": 0,
            "_x0033_2": 0,
            "_x0032_9": 0,
            "_x0033_3": 0,
            "_x0033_5": 0,
            "_x0031_0": 0,
            "_x0035_8": 0,
            "_x0035_9": 0,
            "Grand Total": 0
        },
        {
            "Timestamp": "2019-04-18T05:00:00",
            "_x0039_": 0,
            "_x0033_": 0,
            "_x0032_8": 0,
            "_x0032_": 0,
            "_x0031_": 0,
            "_x0033_2": 0,
            "_x0032_9": 0,
            "_x0033_3": 0,
            "_x0033_5": 0,
            "_x0031_0": 0,
            "_x0035_8": 0,
            "_x0035_9": 0,
            "Grand Total": 0
        },
               ...
    ],
    "TotalCount": 37,
    "QueryToken": "",
    "Success": true,
    "Message": "SUCCESS",
    "PivotIdToDisplayValueMap": [
        [
            "Timestamp",
            "Timestamp"
        ],
        [
            "_x0039_",
            "Delete"
        ],
        [
            "_x0033_",
            "Update"
        ],
        [
            "_x0032_8",
            "Document Query"
        ],
        [
            "_x0032_",
            "Create"
        ],
        [
            "_x0031_",
            "View"
        ],
        [
            "_x0033_2",
            "Import"
        ],
        [
            "_x0032_9",
            "Query"
        ],
        [
            "_x0033_3",
            "Export"
        ],
        [
            "_x0033_5",
            "RelativityScriptExecution"
        ],
        [
            "_x0031_0",
            "Security"
        ],
        [
            "_x0035_8",
            "Update - Revert"
        ],
        [
            "_x0035_9",
            "Update - Mass Revert"
        ],
        [
            "Grand Total",
            "Grand Total"
        ]
    ]
}

The request contains the following fields:

• criteria - represents the actions, users, and timeframe used when retrieving counts for audit actions. It contains the following fields:
  • AuditActionIds - an array of identifiers for the audit actions performed on document. This endpoint retrieves the counts for the following supported actions:

    Name	Value
    View	1
    Update	3
    Mass edits	4
    Propagation	6

  • UserIds - an array of Artifact IDs for Relativity users whose audit actions are included in the report.

    Note: If you pass an empty array, the report is computed for all the users in the workspace.

  • StartDate - the initial date for the reporting period.
  • EndDate - the final date for the reporting period.
  • TimeZone - a timezone URL.

{
    "criteria": {
        "AuditActionIds": [
            1,
            4,
            3
        ],
        "UserIds": [
            9,
            777
        ],
        "StartDate": "2019-05-01T22:53:55.1169908+00:00",
        "EndDate": "2019-05-22T22:54:19.7619193+00:00",
        "TimeZone": "US/Central"
    }
}

The response contains the following fields:

• ReviewerStatistics - includes information returned for specific reviewer criteria. It contains the following fields:
  • UserId - the Artifact ID for a Relativity user.
  • Statistics -includes information about the action counts returned. It contains the following field:
    • ActionCounts - an array of counts returned for a user. It contains the following fields:
      • AuditActionId - the identifier for an audit actions performed on document.
      • Count - the total number of actions performed on a document object.
      • DistinctDocumentCount - the total number of actions performed on distinct documents.

{
  "ReviewerStatistics": [
    {
      "UserId": 9,
      "Statistics": {
        "ActionCounts": [
          {
            "AuditActionId": 1,
            "Count": 13,
            "DistinctDocumentCount": 3
          },
          {
            "AuditActionId": 3,
            "Count": 13,
            "DistinctDocumentCount": 2
          }
        ]
      }
    }
  ]
}

The request contains the following fields:

• criteria - represents the actions, users, and timeframe used when retrieving counts for usage times. It contains the following fields:
  • AuditActionIds - an array of identifiers for the audit actions performed on document.
  • UserIds - an array of Artifact IDs for Relativity users whose audit actions are included in the report.

    Note: If you pass an empty array, the report is computed for all the users in the workspace.

  • StartDate - the initial date for the reporting period.
  • EndDate - the final date for the reporting period.
  • TimeZone - a timezone URL.
  • DownTime - the number of seconds used to determine whether a null session action should be joined to a non-null session action. If the time difference for the performance of a null session action is larger than this maximum duration, the null session is counted as one minute. The default value is 900 secs.

{
    "criteria": {
        "AuditActionIds": [
            1,
            4,
            3
        ],
        "UserIds": [
            9,
            777
        ],
        "StartDate": "2019-05-01T22:53:55.1169908+00:00",
        "EndDate": "2019-05-22T22:54:19.7619193+00:00",
        "TimeZone": "US/Central",
        "DownTime": 900
    }
}

The response contains the following fields:

• ReviewerStatistics - includes information returned for specific reviewer criteria. It contains the following fields:
  • UserId - the Artifact ID for a Relativity user.
  • Statistics - includes information about the usage time. It contains the following field:
    • TotalSeconds - the total number of seconds that a reviewer used to complete the specified actions.

{
  "ReviewerStatistics": [
    {
      "UserId": 777,
      "Statistics": {
        "TotalSeconds": 1081
      }
    },
    {
      "UserId": 9,
      "Statistics": {
        "TotalSeconds": 12939
      }
    }
  ]
}

The request contains the following fields:

• criteria - represents the actions, users, and timeframe used when retrieving the size of extracted text for reviewed documents. It contains the following fields:
  • AuditActionIds - an array of identifiers for the audit actions performed on document.
  • UserIds - an array of Artifact IDs for Relativity users whose audit actions are included in the report.

    Note: If you pass an empty array, the report is computed for all the users in the workspace.

  • StartDate - the initial date for the reporting period.
  • EndDate - the final date for the reporting period.
  • TimeZone - a timezone URL.
  • ExtractedTextFieldArtifactId - the Artifact ID of an extracted text field in the specified workspace.

{
    "criteria": {
        "AuditActionIds": [
            1,
            4,
            3
        ],
        "UserIds": [
            9,
            777
        ],
        "StartDate": "2019-05-01T22:53:55.1169908+00:00",
        "EndDate": "2019-05-22T22:54:19.7619193+00:00",
        "TimeZone": "US/Central",
        "ExtractedTextFieldArtifactId": 1003668
    }
}

The response contains the following fields:

• ReviewerStatistics - includes information returned for specific reviewer criteria. It contains the following fields:
  • UserId - the Artifact ID for a Relativity user.
  • Statistics - includes information about the extracted text size. It contains the following field:
    • TotalBytes - the total number of bytes of extracted text size for all of documents reviewed by the specified reviewer.

{
  "ReviewerStatistics": [
    {
      "UserId": 9,
      "Statistics": {
        "TotalBytes": 5312
      }
    }
  ]
}

The request contains the following fields:

• criteria - represents the actions, users, and timeframe used when retrieving an aggregate of user actions per hour. It contains the following fields:
  • AuditActionIds - an array of identifiers for the audit actions performed on document.
  • UserIds - an array of Artifact IDs for Relativity users whose audit actions are included in the report.

    Note: If you pass an empty array, the report is computed for all the users in the workspace.

  • StartDate - the initial date for the reporting period.
  • EndDate - the final date for the reporting period.
  • TimeZone - a timezone URL.

{
    "criteria": {
        "AuditActionIds": [
            3,
            4
        ],
        "UserIds": [
            9,
            777
        ],
        "StartDate": "2019-05-15T00:00:00.2770527-05:00",
        "EndDate": "2019-05-22T00:00:00.2770527-05:00",
        "TimeZone": "America/Chicago"
    }
}

The response contains the following fields:

• ReviewerStatistics - includes information returned for specific reviewer criteria. It contains the following fields:
  • UserId - the Artifact ID for a Relativity user.
  • Statistics - includes information about the hour buckets returned. It contains the following field:
    • HourBuckets - an array of counts returned for a user. It contains the following fields:
      • HourOfDay - the hour of day when that the user performed the audit actions. This field uses the 24-hour clock format.
      • ActionCount - the number of audit actions that the user performed within the hour.

{
  "ReviewerStatistics": [
    {
      "UserId": 9,
      "Statistics": {
        "HourBuckets": [
          {
            "HourOfDay": 0,
            "ActionCount": 0
          },
          {
            "HourOfDay": 1,
            "ActionCount": 0
          },
          {
            "HourOfDay": 2,
            "ActionCount": 0
          },
          {
            "HourOfDay": 3,
            "ActionCount": 0
          },
          {
            "HourOfDay": 4,
            "ActionCount": 0
          },
          {
            "HourOfDay": 5,
            "ActionCount": 0
          },
          {
            "HourOfDay": 6,
            "ActionCount": 0
          },
          {
            "HourOfDay": 7,
            "ActionCount": 0
          },
          {
            "HourOfDay": 8,
            "ActionCount": 0
          },
          {
            "HourOfDay": 9,
            "ActionCount": 0
          },
          {
            "HourOfDay": 10,
            "ActionCount": 4
          },
          {
            "HourOfDay": 11,
            "ActionCount": 0
          },
          {
            "HourOfDay": 12,
            "ActionCount": 2
          },
          {
            "HourOfDay": 13,
            "ActionCount": 0
          },
          {
            "HourOfDay": 14,
            "ActionCount": 1
          },
          {
            "HourOfDay": 15,
            "ActionCount": 4
          },
          {
            "HourOfDay": 16,
            "ActionCount": 0
          },
          {
            "HourOfDay": 17,
            "ActionCount": 0
          },
          {
            "HourOfDay": 18,
            "ActionCount": 0
          },
          {
            "HourOfDay": 19,
            "ActionCount": 0
          },
          {
            "HourOfDay": 20,
            "ActionCount": 0
          },
          {
            "HourOfDay": 21,
            "ActionCount": 0
          },
          {
            "HourOfDay": 22,
            "ActionCount": 0
          },
          {
            "HourOfDay": 23,
            "ActionCount": 0
          }
        ]
      }
    }
  ]
}

The request contains the following fields:

• reviewerChoicesCriteria - represents the fields, users, and timeframe used when retrieving choices set in reviews. It contains the following fields:
  • FieldIds - an array of Artifact IDs for fields used to compute the choices selected by reviewers. You can retrieve statistics for single choice fields, multiple choice fields, and Yes/No fields.
  • StartDate - the initial date for the reporting period.
  • EndDate - the final date for the reporting period.
  • TimeZone - a timezone URL.
  • UserIdsToExcludeInReport - an array of Artifact IDs for users who choice selections must be excluded from the report.
  • UserIdsToIncludeInReport - an array of Artifact IDs for users who choice selections must be included in the report.

    Note: If you pass an empty array for the UserIdsToExcludeInReport or the UserIdsToIncludeInReport field, the report is computed for all the users in the workspace.

{
    "reviewerChoicesCriteria": {
        "FieldIds": [
            1035357
        ],
        "EndDate": "2019-05-22T16:20:16.000",
        "StartDate": "2019-05-01T16:20:16.000",
        "TimeZone": "America/Chicago",
        "UserIdsToExcludeInReport": [
            777
        ],
        "UserIdsToIncludeInReport": [
            9
        ]
    }
}

The response contains the following fields:

• ReviewerStatistics - includes information returned for specific reviewer criteria. It contains the following fields:
  • UserId - the Artifact ID for a Relativity user.
  • Statistics - includes information about the choices that are set by reviewers. It contains the following field:
    • ReviewedFieldChoices - an array of fields reviewed by a user. Each item in the array contains the following fields:
      • FieldId - the Artifact ID of the field in Relativity.
      • ReviewedChoices - an array of choices that a reviewer used for coding. Each choice contains the following information:
        • ChoiceId - the Artifact ID of the choice in Relativity.
        • Count - the number of times this choice was set on the field.
      • TotalChoicesUnset - an integer value indicating the number of choices on this field that weren't used by a reviewer for coding.
      • FieldType - an integer that Relativity uses to identify the type of a field. The FieldType enumeration contains the following values.

        Name	Value
        MultipleChoice	0
        SingleChoice	1
        YesOrNo	2

  • TotalDocsUpdated - an integer value indicating the total number of documents that the reviewer coded with a choice.
  • TotalChoicesUnset - an integer value indicating the total number of choices that weren't used by a reviewer for coding.

{
  "ReviewerStatistics": [
    {
      "UserId": 9,
      "Statistics": {
        "ReviewedFieldChoices": [
          {
            "FieldId": 1035357,
            "ReviewedChoices": [
              {
                "ChoiceId": 1035871,
                "Count": 0
              },
              {
                "ChoiceId": 1035850,
                "Count": 0
              },
              {
                "ChoiceId": 1035916,
                "Count": 0
              },
              {
                "ChoiceId": 1035891,
                "Count": 2
              }
            ],
            "TotalChoicesUnset": 0,
            "FieldType": 1
          }
        ],
        "TotalDocsUpdated": 2,
        "TotalChoicesUnset": 0
      }
    }
  ]
}

The request contains the following fields:

• reviewerStatsDataRequest - a request to generate a report based on the specified settings. It contains the following fields:
  • startDate - the initial date of the reporting period.
  • endDate - the final date of the reporting period.
  • timeZone - the time zone for the reviews included in the report. The time zone is specified as a UTC offset.
  • downTimeThreshold - the expected downtime (in seconds) between audit records. By default, this value is to 900 seconds (15 minutes).
  • nonAdmin - indicates whether the report is for non-admin users only.
  • additionalActions - indicates whether to include statistics for mass edits and propagation actions. Set this field to one of the following values:
    • None - include view and update actions.
    • Mass Edit - include view, update, and mass edit actions.
    • Propagation - include propagation actions.
    • Mass Edit and Propagation - include view, update, mass edit, and propagation actions.

{
    "reviewerStatsDataRequest": {
        "startDate": "2019-01-01T00:00:00Z",
        "endDate": "2019-10-05T00:00:00Z",
        "timeZone": "-06.0",
        "downTimeThreshold": "900",
        "nonAdmin": false,
        "additionalActions": "None"
    }
}

The response contains the following fields:

Note: In the following descriptions, the term distinct indicates that an action occurred only once per document.

• FullName - the full name for the user.
• UserId - the Artifact ID for a Relativity user.
• TotalUsageTime - calculated as the difference between the time the reviewer first views or edits any document in the workspace, and the time the reviewer last views or edits any document in the workspace per session. A session is the timeframe during which the user is logged in to Relativity. All sessions for the selected date range are then totaled per reviewer.
• Views - the total number of documents that the reviewer looked at during the reporting period.
• DistinctViews - the number of unique documents that the reviewer looked at during the reporting period.
• Edits - the total number of editing or coding decisions made during the reporting period.
• DistinctEdits - the total number of documents edited, excluding repeated edits of the same document.
• EditsPerHour - the number of edits per hour based on the total usage time of the reviewer.
• EditsPerDay - the number of edits performed per day during the reporting period.
• DistinctEditsPerHour - the number of distinct edits per hour based on the total usage time of the reviewer.
• DistinctEditsPerDay - the number of distinct edits performed per day during the reporting period.
• DistinctMassEditsPerHour - the number of distinct mass edits per hour based on the total usage time of the reviewer.
• DistinctMassEditsPerDay - the number of distinct mass edits per day during the reporting period.
• MassEdits - the total number of document edits performed with the mass edit action.
• DistinctMassEdits - the total number of unique document edits performed with the mass edit action.
• MassEditsPerHour - the number of mass edits per hour based on the total usage time of the reviewer.
• MassEditsPerDay - the number of mass edits per day during the reporting period.
• Propagations - the total number of documents that were updated via propagation.
• DistinctPropagations - the total number of unique documents that were updated via propagation.
• DistinctMassPropagationsPerHour - the number of unique documents that had propagations applied per hour based on the total usage time of the reviewer.
• DistinctMassPropagationsPerDay - the number of unique documents that had propagations applied per day based during the reporting period.
• PropagationsPerHour - the number of propagations applied per hour based on the total usage time of the reviewer.
• PropagationsPerDay - the number of propagations applied per day based on the reporting period.

[
  {
    "FullName": "Service Account, Relativity",
    "UserId": 777,
    "TotalUsageTime": "2:34:08",
    "Views": 0,
    "DistinctViews": 0,
    "Edits": 0,
    "DistinctEdits": 0,
    "EditsPerHour": 0,
    "EditsPerDay": 0,
    "DistinctEditsPerHour": 0,
    "DistinctEditsPerDay": 0,
    "MassEdits": 0,
    "DistinctMassEdits": 0,
    "DistinctMassEditsPerHour": 0,
    "DistinctMassEditsPerDay": 0,
    "MassEditsPerHour": 0,
    "MassEditsPerDay": 0,
    "Propagations": 0,
    "DistinctPropagations": 0,
    "DistinctMassPropagationsPerHour": 0,
    "DistinctMassPropagationsPerDay": 0,
    "PropagationsPerHour": 0,
    "PropagationsPerDay": 0
  },
  {
    "FullName": "Admin, Relativity",
    "UserId": 9,
    "TotalUsageTime": "11:35:28",
    "Views": 37,
    "DistinctViews": 3,
    "Edits": 31,
    "DistinctEdits": 3,
    "EditsPerHour": 2.67,
    "EditsPerDay": 0.11,
    "DistinctEditsPerHour": 0.26,
    "DistinctEditsPerDay": 0.01,
    "MassEdits": 0,
    "DistinctMassEdits": 0,
    "DistinctMassEditsPerHour": 0,
    "DistinctMassEditsPerDay": 0,
    "MassEditsPerHour": 0,
    "MassEditsPerDay": 0,
    "Propagations": 0,
    "DistinctPropagations": 0,
    "DistinctMassPropagationsPerHour": 0,
    "DistinctMassPropagationsPerDay": 0,
    "PropagationsPerHour": 0,
    "PropagationsPerDay": 0
  }
]

The request contains the following fields:

• workspaceId - the Artifact ID of the target workspace. To return the instance-level audit records, specify -1. This field is optional in the request. If a mismatch occurs between the ID in this field and the URL, then the ID in the URL is used in the request.
• request - represents a read operation on an audit record:
  • Id - the identifier for the audit record generated by Relativity.
  • Timestamp - the date and time that the audit record was created.

    Note: The request requires the Timestamp and Id fields to uniquely identify the audit record.

{
    "workspaceId": 1018053,
    "request": {
        "Id": "484127",
        "Timestamp": "2019-04-26T15:56:53.427"
    }
}

The response contains the following fields:

• ID - the ID of the audit record.
• TimeStamp - the date and time of the audit action.
• ArtifactName - the name of the audited artifact, such as the document control number.
• ActionName - the audit action name, such as create, update, query, or others.
• ActionID - the audit action ID.
• ObjectTypeName - the object type of the audited artifact, such as workspace or document.
• ObjectTypeID - the object type ID of the audited artifact.
• ExecutionTime - the length of time in milliseconds used to generate the audit details report.
• ArtifactID - the Artifact ID of the audited artifact.
• UserName - the user name associated with the audit record.
• UserID - the Artifact ID of the user associated with the audit record.
• Details - the detailed audit action information.
• OldValues - the values of the fields that have been changed by the action.
• NewValues - the values of the fields that have been set by the action.
• Fields - the fields that have been changed by the action.
• WorkspaceId - the Artifact ID of the workspace associated with the audit record.
• WorkspaceName - the name of the workspace associated with the audit record.

{
    "ID": "484127",
    "TimeStamp": "2019-04-26T15:56:53.427",
    "ArtifactName": "Audit",
    "ActionName": "Query",
    "ActionID": 29,
    "ObjectTypeName": "Workspace",
    "ObjectTypeID": 8,
    "ExecutionTime": 0,
    "ArtifactID": 1003663,
    "UserName": "Service Account, Relativity",
    "UserID": 777,
    "Details": {
        "auditElement": {
            "OperationID": "|56237733-44595bea4f441873.",
            "QueryText": "SELECT * FROM EveryThing;",
            "QueryParameters": {
                "Parameter": [
                    {
                        "@Name": "@p1",
                        "#text": "1",
                        "@dbType": "Int"
                    },
                    {
                        "@Name": "@p2",
                        "#text": "1000011",
                        "@dbType": "Int"
                    },
                    {
                        "@Name": "@p3",
                        "#text": "1039633",
                        "@dbType": "Int"
                    }
                ]
            },
            "Milliseconds": "0"
        }
    },
    "OldValues": [],
    "NewValues": [],
    "Fields": [],
    "WorkspaceId": 1018053,
    "WorkspaceName": "Audit"
}

The request contains the following fields:

• request - represents a query request for audit information. It contains the following fields:

  • fields - an array of fields used like a SELECT statement in an SQL query. You must specify the field name. This array contains the following:

    • Name - the user-friendly name for the field.
    • Guids - an array of GUIDs used to identify the field.
    • ArtifactID - the Artifact ID for field.
  • condition - the search criteria used in the query. For more information, Query conditions. This field is optional.
  • rowCondition - the filtering condition criteria for the result set. For more information, Query conditions. This field is optional.
  • executingViewId - reserved for future use.
• start - the index of the first artifact in the result set.
• length - the number of items to return in the query result, beginning with index in the start field.

{
    "request": {
        "fields": [
            {
                "Name": "User Name",
                "Guids": [],
                "ArtifactID": 0
            },
            {
                "Name": "Details",
                "Guids": [],
                "ArtifactID": 0
            },
            {
                "Name": "Old Value",
                "Guids": [],
                "ArtifactID": 0
            },
            {
                "Name": "New Value",
                "Guids": [],
                "ArtifactID": 0
            }
        ],
        "condition": "",
        "rowCondition": "",
        "executingViewId": 1039633
    },
    "start": 1,
    "length": 2
}

• TotalCount - the total number of objects in Relativity that meet the criteria of the query. For example, you may request 100 objects, but 115 objects satisfy the query. The ResultCount is 100, while the TotalCount is 115.
• Objects - an array of audit objects. The following fields are listed for each object:
  • ParentObject - reserved for future use.
  • Name - contains the Artifact ID of the parent object associated with object returned by the query operation.
  • FieldValues - an array containing FieldValuePair objects. It contains the following:
    • Value - the data assigned to a field.
    • Field - a field associated with a specific value. The Field object contains the following:
      • FieldCategory - indicates the specific functionality assigned to a field, such as stores descriptive text, acts as a relational field, represents grouping for batching, and others. For more information, see the FieldCategory enumeration in Services API on the Relativity API reference page.
      • FieldType - the type of a Relativity field, such as fixed-length text, date, single object, or others. For more information, see the FieldType enumeration in Relativity.Services.Objects.DataContracts namespace in the Services API.
      • ViewFieldID - a unique identifier used to reference a view field.
      • ArtifactID - a unique identifier for the field, which is represented as an integer.
      • Guids - an array of GUIDs used to identify the field.
      • Name - a user-friendly name for the field.
  • ArtifactID - a unique identifier for the object returned by the query.
  • Guids - an array of GUIDs used to identify the object returned by the query.
• IDWindow - reserved for future use.
• CurrentStartIndex - the index of the first artifact in the result set.
• ResultCount - the number of objects returned by the current query. Also, see the description of TotalCount field.
• ObjectType - reserved for future use.
• SampleDetails - reserved for future use.
• RankWindow - reserved for future use.
• RelationalField - name of relational field to expand query results to related objects.

{
  "TotalCount": 1586265,
  "Objects": [
    {
      "ParentObject": null,
      "Name": "1415378",
      "FieldValues": [
        {
          "Value": "1415378",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 0,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Audit ID"
          }
        },
        {
          "Value": "\r\n\t\t\t\t\t\t<div>\r\n\t\t\t\t\t\t\t<a class=\"fluid-item-list-cell-link\" target=\"_top\" onclick=\"relativity.raiseCustomItemListEvent('fil_itemListFUI',1,'audit_modal_view',[1018053,'1415378','2019-05-23T02:22:37.320']);\">\r\n\t\t\t\t\t\t\t\t<img src=\"/Relativity/images/pop_up_icon.png\" alt=\"Show Audit Details\"></img>\r\n\t\t\t\t\t\t\t</a>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t</div>",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 4,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Details"
          }
        }
      ],
      "ArtifactID": 1003663,
      "Guids": []
    },
    {
      "ParentObject": null,
      "Name": "1415377",
      "FieldValues": [
        {
          "Value": "1415377",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 0,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Audit ID"
          }
        },
        {
          "Value": "\r\n\t\t\t\t\t\t<div>\r\n\t\t\t\t\t\t\t<a class=\"fluid-item-list-cell-link\" target=\"_top\" onclick=\"relativity.raiseCustomItemListEvent('fil_itemListFUI',1,'audit_modal_view',[1018053,'1415377','2019-05-23T02:22:37.290']);\">\r\n\t\t\t\t\t\t\t\t<img src=\"/Relativity/images/pop_up_icon.png\" alt=\"Show Audit Details\"></img>\r\n\t\t\t\t\t\t\t</a>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t</div>",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 4,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Details"
          }
        }
      ],
      "ArtifactID": 1003663,
      "Guids": []
    }
  ],
  "IDWindow": [
    1,
    2
  ],
  "CurrentStartIndex": 1,
  "ResultCount": 2,
  "ObjectType": {
    "ArtifactID": 0,
    "Name": "",
    "Guids": [],
    "ArtifactTypeID": 0
  },
  "SampleDetails": null,
  "RankWindow": [
    0
  ],
  "RelationalField": null
}

• request - represents a query request for audit information. It contains the following fields:
  • objectType - the Audit object type identified by the Artifact Type ID on the Object Type. The values are different for each workspace and the instance-level object types. To programmatically return the Artifact Type ID, query the Relativity object types using the Services API.
    • artifactTypeID - an integer value used as an identifier for an object type supported by Relativity. For example, the Artifact Type ID for a Document object is 10. See the ArtifactType enumeration in the Services API.
  • fields - an array of fields used like a SELECT statement in an SQL query. You must specify the field name. This array contains the following:
    • Name - the user-friendly name for the field.
    • Guids - an array of GUIDs used to identify the field.
    • ArtifactID - the Artifact ID for field.
• condition - the search criteria used in the query. For more information, Query conditions. This field is optional.
• rowcondition - the filtering condition criteria for the result set. For more information, Query conditions. This field is optional.
• sorts - a collection of Sort objects. This field indicates whether the results are sorted in ascending or descending order, and identifies the field used to sort the results by name. This field is optional. See the Sort class in the kCura.Relativity.Client namespace.
• relationalField - name of relational field to expand query results to related objects. This field is optional.
• searchProviderCondition - specifies a search index other than the default keyword search index. This field is optional.
• includeIdWindow - reserved for future use.
• convertNumberFieldValuesToString - converts the response field values to strings. This field is optional.
• isAdHocQuery - reserved for future use.
• activeArtifactId - reserved for future use.
• queryHint - set a QueryHint field to optimize the view. For example, you can use the hashjoin setting with the value of true or false, or you can use the waitfor setting with a value, such as waitfor:5. This field is optional. For more information about general query options, see Query for resources.
• executingViewId - reserved for future use.
• start - the index of the first artifact in the result set.
• length - the number of items to return in the query result, starting with index in the start field.

• cancel - represents a cancellation token. It contains the following fields:
  • RequestId - a GUID.
  • TicketId - a GUID.
• progress - represents a progress indicator. It contains the following fields:
  • RequestId - a GUID.
  • TicketId - a GUID.

Note: The use of progress indicators and cancellation tokens isn't supported, but you must include the cancel and progress fields in the request.

{
    "request": {
        "objectType": {
            "artifactTypeID": 1000049
        },
        "fields": [
            {
                "Name": "Field",
                "Guids": [],
                "ArtifactID": 0
            },
            {
                "Name": "Old Value",
                "Guids": [],
                "ArtifactID": 0
            },
            {
                "Name": "New Value",
                "Guids": [],
                "ArtifactID": 0
            }
        ],
        "condition": "",
        "rowCondition": "",
        "sorts": [],
        "relationalField": null,
        "searchProviderCondition": null,
        "includeIdWindow": true,
        "convertNumberFieldValuesToString": true,
        "isAdHocQuery": false,
        "activeArtifactId": null,
        "queryHint": null,
        "executingViewId": 1039633
    },
    "start": 1,
    "length": 25,
    "cancel": {
        "RequestId": "c8e47286-bbfa-4818-9d8d-175578a6b190",
        "TicketId": "c8e47286-bbfa-4818-9d8d-175578a6b190"
    },
    "progress": {
        "RequestId": "c8e47286-bbfa-4818-9d8d-175578a6b190",
        "TicketId": "c8e47286-bbfa-4818-9d8d-175578a6b190"
    }
}

• TotalCount - the total number of objects in Relativity that meet the criteria of the query. For example, you may request 100 objects, but 115 objects satisfy the query. The ResultCount is 100, while the TotalCount is 115.
• Objects - an array of audit objects. The following fields are listed for each object:
  • ParentObject - reserved for future use.
  • Name - contains the Artifact ID of the parent object associated with object returned by the query operation.
  • FieldValues - an array containing FieldValuePair objects. It contains the following:
    • Value - the data assigned to a field.
    • Field - a field associated with a specific value. The Field object contains the following:
      • FieldCategory - indicates the specific functionality assigned to a field, such as stores descriptive text, acts as a relational field, represents grouping for batching, and others. For more information, see the FieldCategory enumeration in Services API on the Relativity API reference page.
      • FieldType - the type of a Relativity field, such as fixed-length text, date, single object, or others. For more information, see the FieldType enumeration in Relativity.Services.Objects.DataContracts namespace in the Services API.
      • ViewFieldID - a unique identifier used to reference a view field.
      • ArtifactID - a unique identifier for the field, which is represented as an integer.
      • Guids - an array of GUIDs used to identify the field.
      • Name - a user-friendly name for the field.
  • ArtifactID - a unique identifier for the object returned by the query.
  • Guids - an array of GUIDs used to identify the object returned by the query.
• IDWindow - reserved for future use.
• CurrentStartIndex - the index of the first artifact in the result set.
• ResultCount - the number of objects returned by the current query. Also, see the description of TotalCount field.
• ObjectType - reserved for future use.
• SampleDetails - reserved for future use.
• RankWindow - reserved for future use.
• RelationalField - name of relational field to expand query results to related objects.

{
  "TotalCount": 1586175,
  "Objects": [
    {
      "ParentObject": null,
      "Name": "1415288",
      "FieldValues": [
        {
          "Value": "1415288",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 0,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Audit ID"
          }
        },
        {
          "Value": "{\"auditElement\":{\"OperationID\":\"9119d82e-abcc-4b0e-931c-9e0415a81c92\",\"QueryText\":\"-- records returned: 1\\r\\n-------------------\\r\\n\",\"QueryParameters\":null,\"Milliseconds\":\"0\"}}",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 4,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Details"
          }
        }
      ],
      "ArtifactID": 1003663,
      "Guids": []
    },
    {
      "ParentObject": null,
      "Name": "1415287",
      "FieldValues": [
        {
          "Value": "1415287",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 0,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Audit ID"
          }
        },
        {
          "Value": "{\"auditElement\":{\"OperationID\":\"9119d82e-abcc-4b0e-931c-9e0415a81c92\",\"QueryText\":\"-- records returned: 1\\r\\n-------------------\\r\\n\",\"QueryParameters\":null,\"Milliseconds\":\"0\"}}",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 4,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Details"
          }
        }
      ],
      "ArtifactID": 1003663,
      "Guids": []
    }
  ],
  "IDWindow": [
    1,
    2
  ],
  "CurrentStartIndex": 1,
  "ResultCount": 2,
  "ObjectType": {
    "ArtifactID": 0,
    "Name": "",
    "Guids": [],
    "ArtifactTypeID": 0
  },
  "SampleDetails": null,
  "RankWindow": [
    0
  ],
  "RelationalField": null
}

• request - represents a query request for audit information. It contains the following fields:
  • objectType - the Audit object type identified by the Artifact Type ID on the Object Type. The values are different for each workspace and the instance-level object types. To programmatically return the Artifact Type ID, query the Relativity object types using the Services API.
    • artifactTypeID - an integer value used as an identifier for an object type supported by Relativity. For example, the Artifact Type ID for a Document object is 10. See the ArtifactType enumeration in the Services API.
  • fields - an array of fields used like a SELECT statement in an SQL query. You must specify the field name. This array contains the following:
    • Name - the user-friendly name for the field.
    • Guids - an array of GUIDs used to identify the field.
    • ArtifactID - the Artifact ID for field.
• condition - the search criteria used in the query. For more information, Query conditions. This field is optional.
• rowcondition - the filtering condition criteria for the result set. For more information, Query conditions. This field is optional.
• sorts - a collection of Sort objects. This field indicates whether the results are sorted in ascending or descending order, and identifies the field used to sort the results by name. This field is optional. See the Sort class in the kCura.Relativity.Client namespace.
• relationalField - name of relational field to expand query results to related objects. This field is optional.
• searchProviderCondition - specifies a search index other than the default keyword search index. This field is optional.
• includeIdWindow - reserved for future use.
• convertNumberFieldValuesToString - converts the response field values to strings. This field is optional.
• isAdHocQuery - reserved for future use.
• activeArtifactId - reserved for future use.
• queryHint - set a QueryHint field to optimize the view. For example, you can use the hashjoin setting with the value of true or false, or you can use the waitfor setting with a value, such as waitfor:5. This field is optional. For more information about general query options, see Query for resources.
• executingViewId - reserved for future use.
• start - the index of the first artifact in the result set.
• length - the number of items to return in the query result, starting with index in the start field.

• auditQueryOptions - additional query options:
  • ReturnRawDetails - a Boolean value indicating whether the Details field should contain an escaped JSON string instead of HTML. Set this field to true if you want to perform further analysis on the audit data. Otherwise, the data is returned as HTML for display on the Audit tab in the Relativity UI. For more information, see Audit in the RelativityOne Documentation site.

{
    "request": {
        "fields": [
            {
                "Name": "Details",
                "Guids": [],
                "ArtifactID": 0
            },
            {
                "Name": "Audit ID",
                "Guids": [],
                "ArtifactID": 0
            },
            {
                "Name": "Timestamp",
                "Guids": [],
                "ArtifactID": 0
            },
            {
                "Name": "Object Name",
                "Guids": [],
                "ArtifactID": 0
            }
        ],
        "condition": "(('Artifact ID' IN VIEW 1039633))",
        "rowCondition": "",
        "sorts": [],
        "relationalField": null,
        "searchProviderCondition": null,
        "includeIdWindow": true,
        "convertNumberFieldValuesToString": true,
        "isAdHocQuery": false,
        "activeArtifactId": null,
        "queryHint": null,
        "executingViewId": 1039633
    },
    "start": 1,
    "length": 2,
    "auditQueryOptions": {
        "returnRawDetails": true
    }
}

• TotalCount - the total number of objects in Relativity that meet the criteria of the query. For example, you may request 100 objects, but 115 objects satisfy the query. The ResultCount is 100, while the TotalCount is 115.
• Objects - an array of audit objects. The following fields are listed for each object:
  • ParentObject - reserved for future use.
  • Name - contains the Artifact ID of the parent object associated with object returned by the query operation.
  • FieldValues - an array containing FieldValuePair objects. It contains the following:
    • Value - the data assigned to a field.
    • Field - a field associated with a specific value. The Field object contains the following:
      • FieldCategory - indicates the specific functionality assigned to a field, such as stores descriptive text, acts as a relational field, represents grouping for batching, and others. For more information, see the FieldCategory enumeration in Services API on the Relativity API reference page.
      • FieldType - the type of a Relativity field, such as fixed-length text, date, single object, or others. For more information, see the FieldType enumeration in Relativity.Services.Objects.DataContracts namespace in the Services API.
      • ViewFieldID - a unique identifier used to reference a view field.
      • ArtifactID - a unique identifier for the field, which is represented as an integer.
      • Guids - an array of GUIDs used to identify the field.
      • Name - a user-friendly name for the field.
  • ArtifactID - a unique identifier for the object returned by the query.
  • Guids - an array of GUIDs used to identify the object returned by the query.
• IDWindow - reserved for future use.
• CurrentStartIndex - the index of the first artifact in the result set.
• ResultCount - the number of objects returned by the current query. Also, see the description of TotalCount field.
• ObjectType - reserved for future use.
• SampleDetails - reserved for future use.
• RankWindow - reserved for future use.
• RelationalField - name of relational field to expand query results to related objects.

{
  "TotalCount": 1586175,
  "Objects": [
    {
      "ParentObject": null,
      "Name": "1415288",
      "FieldValues": [
        {
          "Value": "1415288",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 0,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Audit ID"
          }
        },
        {
          "Value": "{\"auditElement\":{\"OperationID\":\"9119d82e-abcc-4b0e-931c-9e0415a81c92\",\"QueryText\":\"-- records returned: 1\\r\\n-------------------\\r\\n\",\"QueryParameters\":null,\"Milliseconds\":\"0\"}}",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 4,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Details"
          }
        }
      ],
      "ArtifactID": 1003663,
      "Guids": []
    },
    {
      "ParentObject": null,
      "Name": "1415287",
      "FieldValues": [
        {
          "Value": "1415287",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 0,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Audit ID"
          }
        },
        {
          "Value": "{\"auditElement\":{\"OperationID\":\"9119d82e-abcc-4b0e-931c-9e0415a81c92\",\"QueryText\":\"-- records returned: 1\\r\\n-------------------\\r\\n\",\"QueryParameters\":null,\"Milliseconds\":\"0\"}}",
          "Field": {
            "FieldCategory": 0,
            "FieldType": 4,
            "ViewFieldID": 0,
            "ArtifactID": 0,
            "Guids": [],
            "Name": "Details"
          }
        }
      ],
      "ArtifactID": 1003663,
      "Guids": []
    }
  ],
  "IDWindow": [
    1,
    2
  ],
  "CurrentStartIndex": 1,
  "ResultCount": 2,
  "ObjectType": {
    "ArtifactID": 0,
    "Name": "",
    "Guids": [],
    "ArtifactTypeID": 0
  },
  "SampleDetails": null,
  "RankWindow": [
    0
  ],
  "RelationalField": null
}

• request - represents a query request for audit information. It contains the following fields:
  • objectType - the Audit object type identified by the Artifact Type ID on the Object Type. The values are different for each workspace and the instance-level object types. To programmatically return the Artifact Type ID, query the Relativity object types using the Services API.
    • artifactTypeID - an integer value used as an identifier for an object type supported by Relativity. For example, the Artifact Type ID for a Document object is 10. See the ArtifactType enumeration in the Services API.
  • fields - an array of fields used like a SELECT statement in an SQL query. You must specify the field name. This array contains the following:
    • Name - the user-friendly name for the field.
    • Guids - an array of GUIDs used to identify the field.
    • ArtifactID - the Artifact ID for field.
• condition - the search criteria used in the query. For more information, Query conditions. This field is optional.
• rowcondition - the filtering condition criteria for the result set. For more information, Query conditions. This field is optional.
• sorts - a collection of Sort objects. This field indicates whether the results are sorted in ascending or descending order, and identifies the field used to sort the results by name. This field is optional. See the Sort class in the kCura.Relativity.Client namespace.
• relationalField - name of relational field to expand query results to related objects. This field is optional.
• searchProviderCondition - specifies a search index other than the default keyword search index. This field is optional.
• includeIdWindow - reserved for future use.
• convertNumberFieldValuesToString - converts the response field values to strings. This field is optional.
• isAdHocQuery - reserved for future use.
• activeArtifactId - reserved for future use.
• queryHint - set a QueryHint field to optimize the view. For example, you can use the hashjoin setting with the value of true or false, or you can use the waitfor setting with a value, such as waitfor:5. This field is optional. For more information about general query options, see Query for resources.
• executingViewId - reserved for future use.
• start - the index of the first artifact in the result set.
• length - the number of items to return in the query result, starting with index in the start field.

• cancel - represents a cancellation token. It contains the following fields:
  • RequestId - a GUID.
  • TicketId - a GUID.
• progress - represents a progress indicator. It contains the following fields:
  • RequestId - a GUID.
  • TicketId - a GUID.

Note: The use of progress indicators and cancellation tokens isn't supported, but you must include the cancel and progress fields in the request.

{
    "request": {
        "objectType": {
            "artifactTypeID": 1000049
        },
        "fields": [
            {
                "Name": "Execution Time (ms)",
                "Guids": [],
                "ArtifactID": 0
            },
            {
                "Name": "Object ArtifactID",
                "Guids": [],
                "ArtifactID": 0
            },
            {
                "Name": "User Name",
                "Guids": [],
                "ArtifactID": 0
            }
        ],
        "condition": "",
        "rowCondition": "",
        "sorts": [],
        "relationalField": null,
        "searchProviderCondition": null,
        "includeIdWindow": true,
        "convertNumberFieldValuesToString": true,
        "isAdHocQuery": false,
        "activeArtifactId": null,
        "queryHint": null,
        "executingViewId": 1039633
    },
    "start": 1,
    "length": 25,
    "cancel": {
        "RequestId": "c8e47286-bbfa-4818-9d8d-175578a6b190",
        "TicketId": "c8e47286-bbfa-4818-9d8d-175578a6b190"
    },
    "progress": {
        "RequestId": "c8e47286-bbfa-4818-9d8d-175578a6b190",
        "TicketId": "c8e47286-bbfa-4818-9d8d-175578a6b190"
    }
}

• TotalCount - the total number of objects in Relativity that meet the criteria of the query. For example, you may request 100 objects, but 115 objects satisfy the query. The ResultCount is 100, while the TotalCount is 115.
• Objects - an array of audit objects. The following fields are listed for each object:
  • ArtifactID - the Artifact ID of the object.
  • Values - an array of values for the fields specified in the request.
• IDWindow - reserved for future use.
• CurrentStartIndex - the index of the first artifact in the result set.
• ResultCount - the number of objects returned by the current query. Also, see the description of TotalCount field.
• ObjectType - reserved for future use.
• SampleDetails - reserved for future use.
• RankWindow - reserved for future use.
• RelationalField - name of relational field to expand query results to related objects.
• Fields - an array of the fields corresponding to the values.
  • FieldCategory - indicates the specific functionality assigned to a field, such as stores descriptive text, acts as a relational field, represents grouping for batching, and others. For more information, see the FieldCategory enumeration in Services API on the Relativity API reference page.
  • FieldType - the type of a Relativity field, such as fixed-length text, date, single object, or others. For more information, see the FieldType enumeration in Relativity.Services.Objects.DataContracts namespace in the Services API.
  • ViewFieldID - a unique identifier used to reference a view field.
  • ArtifactID - a unique identifier for the field, which is represented as an integer.
  • Guids - an array of GUIDs used to identify the field.
  • Name - a user-friendly name for the field.

{
  "TotalCount": 1586275,
  "Objects": [
    {
      "ArtifactID": 1003663,
      "Values": [
        "1415388",
        "\r\n\t\t\t\t\t\t<div>\r\n\t\t\t\t\t\t\t<a class=\"fluid-item-list-cell-link\" target=\"_top\" onclick=\"relativity.raiseCustomItemListEvent('fil_itemListFUI',1,'audit_modal_view',[1018053,'1415388','2019-05-23T02:23:55.650']);\">\r\n\t\t\t\t\t\t\t\t<img src=\"/Relativity/images/pop_up_icon.png\" alt=\"Show Audit Details\"></img>\r\n\t\t\t\t\t\t\t</a>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t</div>"
      ]
    },
    {
      "ArtifactID": 1003663,
      "Values": [
        "1415387",
        "\r\n\t\t\t\t\t\t<div>\r\n\t\t\t\t\t\t\t<a class=\"fluid-item-list-cell-link\" target=\"_top\" onclick=\"relativity.raiseCustomItemListEvent('fil_itemListFUI',1,'audit_modal_view',[1018053,'1415387','2019-05-23T02:23:55.603']);\">\r\n\t\t\t\t\t\t\t\t<img src=\"/Relativity/images/pop_up_icon.png\" alt=\"Show Audit Details\"></img>\r\n\t\t\t\t\t\t\t</a>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t</div>"
      ]
    }
  ],
  "IDWindow": [
    1,
    2
  ],
  "CurrentStartIndex": 1,
  "ResultCount": 2,
  "ObjectType": null,
  "SampleDetails": null,
  "RankWindow": [
    0
  ],
  "RelationalField": null,
  "Fields": [
    {
      "FieldCategory": 0,
      "FieldType": 0,
      "ViewFieldID": 0,
      "ArtifactID": 0,
      "Guids": [],
      "Name": "Audit ID"
    },
    {
      "FieldCategory": 0,
      "FieldType": 4,
      "ViewFieldID": 0,
      "ArtifactID": 0,
      "Guids": [],
      "Name": "Details"
    }
  ]
}