Pivot Manager (REST)

The Relativity REST API includes a Pivot Manager service that provides operations for working with custom Pivot queries and Pivot profiles. You can use the service to create and run custom Pivot queries and to read and run queries that are based on existing Pivot profiles. The supported operations are equivalent to the supported methods for interacting with Pivot objects in the Relativity Services API. Unlike the Services API however, the Pivot Manager service doesn’t support use of progress indicators or cancellation tokens.

This page contains the following sections:

Note that the Pivot Manager service doesn’t provide operations for creating, updating, or deleting Pivot queries that persist in Relativity. This means that you can use the service to create and run a custom query but you can’t store and subsequently update or delete the query or query results in Relativity. Similarly, you can use the service to read an existing Pivot profile and run a query that’s based on the profile, but you can’t create, update, or delete a Pivot profile. Overall, the service is designed to help you transfer data to other applications and tools, such as a third-party software application or web-based visualization tool, for deeper analysis and reporting. For example, you might use the service to implement a Pivot query as part of a larger solution that captures query results, writes the results to a specified table, object, or other location, and then manipulates the results in that location.

Pivot fundamentals

To interact with the Pivot Manager service, you send HTTP(S) requests that use the POST method and specify query conditions in the body of the request. All Pivot requests use the following base URL:

http://localhost/relativity.rest/api/Relativity.Services.Pivot.IPivotModule/Pivot%20Manager/

For example, use the following URL to create and run a custom Pivot query:

http://localhost/relativity.rest/api/Relativity.Services.Pivot.IPivotModule/Pivot%20Manager/ExecuteAsync

Or use the following URL to read and run a query based on a Pivot profile:

http://localhost/relativity.rest/api/Relativity.Services.Pivot.IPivotModule/Pivot%20Manager/ExecutePivotProfileAsync

Note that the base URL format for the Pivot Manager service is different from most other Relativity REST services.

Like other query-based services of the Relativity REST API, request bodies and server responses for the Pivot Manager service are sent in JSON payloads. The body of a POST request for a query includes a JSON representation of fields, conditions, and other parameters for the query. The body of a response returns all the query results as a single result set; the Pivot Service Manager doesn’t provide built-in support for paging. For information about the options and syntax that you can use for Pivot and other query services in the Relativity REST API, see Query for resources.

Fields

The Pivot Manager service uses a combination of unique fields and fields that are common to the Relativity REST API. The following table lists and describes the required fields for the Pivot Manager service and indicates whether each field is common to the REST API or specific to a type of Pivot query.

Field Type Description Scope
ArtifactTypeID Number The Artifact Type identifier of the type of DTO to query—for example, “10” for documents. Common
GroupBy Object The view field identifier, Artifact identifier, GUID, or name of the field to use for grouping data. Custom Pivot queries only
GroupByDateGrouping Number The calendar-based time interval to use when calculating data for the GroupBy field, if the GroupBy field is a Date field:

0 = Day, month, and year

1 = Month

2 = Year

3 = Month and year

Custom Pivot queries only
objectSetQuery Object The name of a query that defines the criteria that objects or documents must meet to be included in the Pivot query. To query all objects or documents in a workspace, don’t specify a value for the condition of this field. Common
PivotOn Object The view field identifier, Artifact identifier, GUID, or name of the field to use for pivoting data. Custom Pivot queries only
PivotOnDateGrouping Number The calendar-based time interval to use when calculating data for the PivotOn field, if the PivotOn field is a Date field:

0 = Day, month, and year

1 = Month

2 = Year

3 = Month and year

Custom Pivot queries only
pivotProfileId Number The Artifact identifier of the Pivot profile to read and run. Profile-based queries only
RawDataOnly Boolean Whether to apply a Pivot view to query results. If “true”, only the data is returned. Custom and profile-based queries
Timeout Number The maximum amount of time, in seconds, to run the query before timing out. Custom and profile-based queries
Toggles Object The Toggles property on a Pivot profile contains various options that control how data in a chart is displayed. For example, these options control the display of labels, blank values, sub-charts, and others. Custom and profile-based queries
workpsaceId Number The Artifact identifier of the workspace to query. Common

Before you can use any type of field to group data in a Pivot query, the field must be enabled for grouping. Similarly, a field must be enabled for pivot before you can use it to pivot data. In addition, you can pivot data by using a Date field only if you also use a Date field to group data, and you can pivot data by month only if you also group data by year. For information about getting a list of workspace fields that you can use to group or pivot data, see Helper operations.

Note that you must have permission to view a field before you can use it in a Pivot query. Otherwise, an error occurs when you try to run the query because the Pivot Service Manager uses the permission settings of the active user account.

HTTP headers and status codes

The Pivot Manager service uses the same HTTP(S) headers and status codes as other services in the Relativity REST API. For details about required headers and fields, see HTTP headers. For details about HTTP status codes, see HTTP status codes.

Create a Pivot profile

To create a Pivot profile, send a request to this URL for the Pivot Manager service:

<host>/Relativity.Rest/API/Relativity.Services.Pivot.IPivotModule/Pivot%20Manager/CreateProfileAsync

The request includes the fields listed in the following sample JSON code. For more information about these fields, see Pivot profiles on the RelativityOne Documentation site.

{
  "workspaceId": 1015337,
  "profile": {
    "Name": "Create",
    "SortOn": "GrandTotal",
    "SortOrder": "Ascending",
    "PageSize": 10,
    "SwitchSeries": "false",
    "Toggles": {
      "ShowBlankValues": false,
      "ShowLegend": true
      "ShowSubChart": true

    },
    "ObjectType": {
      "Name": "Document"
    },
    "GroupByField": {
      "ArtifactID": 1035357
    },
    "PivotOnField": {
      "ArtifactID": 1035351
    },
    "ChartType": "Bar",
    "ChartOrientation": "Vertical"
  }
}

The response returns a JSON object with the fields set in the new Pivot profile.

{
  "ID": 1040622,
  "GroupByField": {
    "ArtifactID": 1035357,
    "ViewFieldID": 1000557,
    "Guids": [
      "8a6747ed-713a-4f2d-b441-c4cd91c3bba9"
    ]
  },
  "PivotOnField": {
    "ArtifactID": 1035351,
    "ViewFieldID": 1000551,
    "Guids": [
      "f1aa6780-a8fa-4b84-b756-15f695b11ea4"
    ]
  },
  "SortOn": "GrandTotal",
  "SortOrder": "Ascending",
  "PageSize": 10,
  "SwitchSeries": false,
  "Name": "Create",
  "ObjectType": {
    "DescriptorArtifactTypeID": 10,
    "Guids": [
      "15c36703-74ea-4ff8-9dfb-ad30ece7530d"
    ],
    "Name": "Document",
    "ArtifactID": 1035231
  },
  "ChartType": "Bar",
  "ChartOrientation": "Vertical",
  "Toggles": {
    "ShowBlankValues": false,
    "ShowGrandTotal": false,
    "ShowLegend": true,
    "RotateLabels": false,
    "StaggerLabels": false,
    "ShowLabels": false 
    "ShowSubChart": true
  }
}

Read a Pivot profile

To read and run a query based on a Pivot profile, send a request to the following Pivot Manager service URL:

<host>/relativity.rest/api/Relativity.Services.Pivot.IPivotModule/Pivot%20Manager/ExecutePivotProfileAsync

Ensure that the request includes required headers for the Relativity REST API and required fields for the Pivot Manager service. The required fields are: workspaceId, pivotProfileId, and objectSetQuery.

In the following example, a client reads and runs a query based on a Pivot profile. The profile is stored in a workspace that has the Artifact identifier value “1032131”. The profile has the Artifact identifier value “1081794”. The query isn’t limited to a subset of documents or objects in the workspace, as indicated by a Null value for the objectSetQuery field condition.

{
     workspaceId: 1032131, 
     pivotProfileId: 1081794,
     objectSetQuery: { Condition: " " }
}

To see the JSON response to the preceding request, see Sample JSON response. For insight into the Pivot profile settings that generated the response, see the next section, which demonstrates how to create a custom Pivot query and uses the same settings as the Pivot profile in the preceding example.

Update a Pivot profile

To update a Pivot profile, send a request to this URL for the Pivot Manager service:

<host>/Relativity.Rest/API/Relativity.Services.Pivot.IPivotModule/Pivot%20Manager/UpdateProfileAsync

The request includes the fields listed in the following sample JSON code. For more information about these fields, see Pivot profiles on the RelativityOne Documentation site.

{
  "workspaceId": 1015337,
  "profile": {
    "Name": "Update",
    "SortOn": "GrandTotal",
    "SortOrder": "Ascending",
    "PageSize": 10,
    "SwitchSeries": "false",
    "Toggles": {
      "ShowBlankValues": false,
      "ShowLegend": true
      "ShowSubChart": true
    },
    "ObjectType": {
      "Name": "Document"
    },
    "ID": 1040623,
    "GroupByField": {
      "ArtifactID": 1035357
    },
    "PivotOnField": {
      "ArtifactID": 1035351
    },
    "ChartType": "Bar",
    "ChartOrientation": "Vertical"
  }
}

The response returns a JSON object with the fields set in the updated Pivot profile.

{
  "ID": 1040623,
  "GroupByField": {
    "ArtifactID": 1035357,
    "ViewFieldID": 1000557,
    "Guids": [
      "8a6747ed-713a-4f2d-b441-c4cd91c3bba9"
    ]
  },
  "PivotOnField": {
    "ArtifactID": 1035351,
    "ViewFieldID": 1000551,
    "Guids": [
      "f1aa6780-a8fa-4b84-b756-15f695b11ea4"
    ]
  },
  "SortOn": "GrandTotal",
  "SortOrder": "Ascending",
  "PageSize": 10,
  "SwitchSeries": false,
  "Name": "Update",
  "ObjectType": {
    "DescriptorArtifactTypeID": 10,
    "Guids": [
      "15c36703-74ea-4ff8-9dfb-ad30ece7530d"
    ],
    "Name": "Document",
    "ArtifactID": 1035231
  },
  "ChartType": "Bar",
  "ChartOrientation": "Vertical",
  "Toggles": {
    "ShowBlankValues": false,
    "ShowGrandTotal": false,
    "ShowLegend": true,
    "RotateLabels": false,
    "StaggerLabels": false,
    "ShowLabels": false
    "ShowSubChart": true
  }
}

Create a custom Pivot query

To create and run a custom Pivot query, send a request to the following Pivot Manager service URL:

http://localhost/relativity.rest/api/Relativity.Services.Pivot.IPivotModule/Pivot%20Manager/ExecuteAsync

Ensure that the request includes required headers for the Relativity REST API and required fields for the Pivot Manager service. Required fields are:

  • ArtifactTypeID
  • GroupBy
  • GroupByDateGrouping if you want to group data by using a Date field
  • objectSetQuery
  • PivotOn if you want to pivot data
  • PivotOnDateGrouping if you want to pivot data by using a Date field
  • RawDataOnly
  • Timeout
  • workpsaceId

To determine which fields you want to use to group and pivot data, you can use Pivot Service Manager helper operations to get a list of workspace fields that are enabled for grouping and pivoting.

The following code example defines a custom query that primarily does the following:

  1. Queries all documents in a workspace.
  2. Groups data by the email address stored in a Fixed-Length Text field named “Email From”.
  3. Pivots data based on the values in a Yes/No field named “Designation”.

To optimize workspace performance and query results, the example also limits the number of results returned and specifies a timeout value for stopping the query.

{
     //Specify which workspace to query.
     workspaceId: 1032131,
     settings: {
          /*
          Set the Artifact Type identifier of the DTO to query. This example queries documents, which 
          have an ArtifactTypeID value of “10”.
          */
          ArtifactTypeID: 10, 
          
          //Group data by using the “Email From” field, which has a view field identifier value of “1000566”.
          GroupBy: { 
               ViewFieldID: 1000566	
          },
          
          //Pivot data by using the “Designation” field, which has a view field identifier value of “1000555”.
          PivotOn: {
               ViewFieldID: 1000555
          },
		
          //Limit the results to a specific number of columns and rows.
          MaximumNumberOfColumns: 50,
          MaximumNumberOfRows: 1200,

          //Run the query for no more than 1,020 seconds (17 minutes).
          Timeout: 1020,

          //Return only the data in query results; do not apply Pivot view settings to the results.
          RawDataOnly: false,

          //Query all documents in the workspace; do not limit the query to a subset of documents. 
          ObjectSetQuery: { Condition: " " },
     } 
}

Export a Pivot query

To export a Pivot query, send a request to this URL for the Pivot Manager service:

<host>/Relativity.Rest/API/Relativity.Services.Pivot.IPivotModule/Pivot%20Manager/ExecuteExportAsync

The request includes the fields listed in the following sample JSON code. For more information about these fields, see Pivot profiles on the RelativityOne Documentation site.

{
   "workspaceId":1019859,
   "dashboard":{
      "pivots":[
         {
            "pivotSettings":{
               "GroupByField":{
                  "ArtifactID":1038158,
                  "Name":"File Type"
               },
               "PivotOnField":null,
               "GroupByDateTimePart":null,
               "PivotOnDateTimePart":null,
               "SortOrder":"Descending",
               "SortOn":"GrandTotal",
               "ChartType":"bar",
               "ChartOrientation":"vertical",
               "GroupByResultLimit":"all",
               "PivotOnResultLimit":"all",
               "PivotOnResultLimitValue":null,
               "Toggles":{
                  "ShowBlankValues":true,
                  "ShowGrandTotal":true,
                  "ShowLegend":false
               },
               "ObjectType":{
                  "DescriptorArtifactTypeID":10
               }
            }
         }
      ],
      "images":[

      ],
      "cellRatio":1
   },
   "objectSetQuery":{
      "Condition":"(('Artifact ID' IN VIEW 1003684))",
      "RowCondition":"",
      "SearchProviderCondition":null,
      "SampleParameters":null
   },
   "cancel":{
      "RequestId":"3585669f-d52a-4baf-90d3-1f7900aa847c",
      "TicketId":"3585669f-d52a-4baf-90d3-1f7900aa847c"
   },
   "progress":{
      "RequestId":"3585669f-d52a-4baf-90d3-1f7900aa847c",
      "TicketId":"3585669f-d52a-4baf-90d3-1f7900aa847c"
   }
}

The response contains the Content Type, and Content field, which has been truncated in the following example. It also includes a Success field, which indicates the status of the export.

{
   "ContentType":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
   "Content":"UEsDBBQABggIAAAAIQC1VTAj6wAAAEwCAAALAAgCX3JlbHMvLnJlbHMgogQCKKAAAgAAAAAAAA...",
   "Success":true
}

Sample JSON response

The following JSON sample shows the response to the custom Pivot query and the profile-based query discussed in the preceding sections. The Results fields report the total number of documents (891) that are in the workspace and contain data in the Email From field. They also report how many of those documents are coded as responsive (True) and non-responsive (False).

Subsequent objects are grouped by the email address stored in the Email From field. The object fields report the applicable email address, the number of documents tagged as responsive (True) and non-responsive (False) for the address, and the total number of documents that have the address in the Email From field. The last four fields in the response provide information about the Pivot query overall—the query returned 277 objects, a Query object was not used, and the query ran successfully.

{
     "Results": [
     {
     "False": 664,
     "True": 227,
     "Grand Total": 891
     },
     {
     "EmailFrom": "SCS_2 scslooptions@attglobal.net@ENRON",
     "False": 203,
     "True": 0,
     "Grand Total": 203
     },
     {
     "EmailFrom": "SCS_2 <scslooptions@attglobal.net>",
     "False": 27,
     "True": 148,
     "Grand Total": 175
     },
     {
     "EmailFrom": "Zipper",
     "False": 80,
     "True": 19,
     "Grand Total": 99
     },
     {
     "EmailFrom": "Forster  David <David.Forster@ENRON.com>",
     "False": 53,
     "True": 3,
     "Grand Total": 56
     },
     {
     "EmailFrom": "Kitchen",
     "False": 49,
     "True": 0,
     "Grand Total": 49
     },
     {
     "EmailFrom": "Schmidt  Ann M. <Ann.M.Schmidt@ENRON.com>",
     "False": 47,
     "True": 0,
     "Grand Total": 47
     },
     {
     "EmailFrom": "Griffith",
     "False": 41,
     "True": 0,
     "Grand Total": 41
     },
     {
     "EmailFrom": "Schoppe  Tammie <Tammie.Schoppe@ENRON.com>",
     "False": 35,
     "True": 0,
     "Grand Total": 35
     },
     {
     "EmailFrom": "Votaw  Courtney <Courtney.Votaw@ENRON.com>",
     "False": 33,
     "True": 0,
     "Grand Total": 33
     },
     {
     "EmailFrom": "Calger  Christopher F. <Christopher.F.Calger@ENRON.com>",
     "False": 32,
     "True": 0,
     "Grand Total": 32
     },
     {
     "EmailFrom": "Oxley  David <David.Oxley@ENRON.com>",
     "False": 31,
     "True": 0,
     "Grand Total": 31
     },
     {
     "EmailFrom": "CarrFuturesEnergy@carrfut.com@ENRON",
     "False": 24,
     "True": 0,
     "Grand Total": 24
     },
     {
     "EmailFrom": "Unspecified Sender",
     "False": 24,
     "True": 4,
     "Grand Total": 28
     },
     {
     "EmailFrom": "Mike Griffith Griff@odessapumps.com@ENRON",
     "False": 23,
     "True": 0,
     "Grand Total": 23
     },
     {
     "EmailFrom": "Andy Weingarten andy@apbenergy.com@ENRON",
     "False": 19,
     "True": 0,
     "Grand Total": 19
     },
     {
     "EmailFrom": "feedback@intcx.com@ENRON <IMCEANOTES-feedback+40intcx+2Ecom+40ENRON@ENRON.com> - on behalf 
     of - IntercontinentalExchange feedback",
     "False": 18,
     "True": 0,
     "Grand Total": 18
     },
     {
     "EmailFrom": "McLaughlin Jr.  Errol <Errol.McLaughlin@ENRON.com>",
     "False": 16,
     "True": 0,
     "Grand Total": 16
     },
     {
     "EmailFrom": "Steffes  James D. <James.D.Steffes@ENRON.com>",
     "False": 16,
     "True": 0,
     "Grand Total": 16
     },
     {
     "EmailFrom": "ARSystem ARSystem@mailman.enron.com@ENRON",
     "False": 14,
     "True": 0,
     "Grand Total": 14
     },
     {
     "EmailFrom": "Bradford  William S. <William.S.Bradford@ENRON.com>",
     "False": 13,
     "True": 0,
     "Grand Total": 13
     },
     {
     "EmailFrom": "Mrha  Jean <Jean.Mrha@ENRON.com>",
     "False": 13,
     "True": 0,
     "Grand Total": 13
     },
     {
     "EmailFrom": "John Phillips <john.phillips@clarionenergy.com>",
     "False": 3,
     "True": 12,
     "Grand Total": 15
     },
     {
     "EmailFrom": "Ballou  Chris Chris_Ballou@bmc.com@ENRON",
     "False": 11,
     "True": 0,
     "Grand Total": 11
     },
     {
     "EmailFrom": "Enron General Announcements <mbx_anncenron@ENRON.com>",
     "False": 11,
     "True": 0,
     "Grand Total": 11
     },
     {
     "EmailFrom": "Cook  Mary <Mary.Cook@ENRON.com>",
     "False": 10,
     "True": 0,
     "Grand Total": 10
     },
     {
     "EmailFrom": "enron_update@concureworkplace.com@ENRON",
     "False": 10,
     "True": 0,
     "Grand Total": 10
     },
     {
     "EmailFrom": "Taylor",
     "False": 10,
     "True": 0,
     "Grand Total": 10
     },
     {
     "EmailFrom": "Angel.Flight.South.Central.Pilots.List@angelflightsc.org",
     "False": 0,
     "True": 9,
     "Grand Total": 9
     },
     {
     "EmailFrom": "Angelica Paez ampaez@earthlink.net@ENRON",
     "False": 8,
     "True": 0,
     "Grand Total": 8
     },
     {
     "EmailFrom": "Nicolay  Christi L. <Christi.L.Nicolay@ENRON.com>",
     "False": 8,
     "True": 0,
     "Grand Total": 8
     },
     {
     "EmailFrom": "Smith  Mark <Mark.Smith@ENRON.com>",
     "False": 8,
     "True": 3,
     "Grand Total": 11
     },
     {
     "EmailFrom": "St. Clair  Carol <Carol.St.Clair@ENRON.com>",
     "False": 8,
     "True": 0,
     "Grand Total": 8
     },
     {
     "EmailFrom": "Atwood  Mechelle <Mechelle.Atwood@ENRON.com>",
     "False": 6,
     "True": 0,
     "Grand Total": 6
     },
     {
     "EmailFrom": "Belden  Tim <Tim.Belden@ENRON.com>",
     "False": 6,
     "True": 0,
     "Grand Total": 6
     },
     {
     "EmailFrom": "E. M. Malone <lottyplace@yahoo.com>",
     "False": 6,
     "True": 0,
     "Grand Total": 6
     },
     {
     "EmailFrom": "gregwhalley 8777865122@skytel.com@ENRON",
     "False": 6,
     "True": 0,
     "Grand Total": 6
     },
     {
     "EmailFrom": "Huan  George <George.Huan@ENRON.com>",
     "False": 6,
     "True": 0,
     "Grand Total": 6
     },
     {
     "EmailFrom": "Johnson  Heather A. <Heather.A.Johnson@ENRON.com>",
     "False": 6,
     "True": 0,
     "Grand Total": 6
     },
     {
     "EmailFrom": "Longoria  Jennifer K. <Jennifer.K.Longoria@ENRON.com>",
     "False": 6,
     "True": 0,
     "Grand Total": 6
     },
     {
     "EmailFrom": "Shah  Kal <Kal.Shah@ENRON.com>",
     "False": 6,
     "True": 0,
     "Grand Total": 6
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - on 
     behalf of - Office of ",
     "False": 5,
     "True": 0,
     "Grand Total": 5
     },
     {
     "EmailFrom": "Haedicke  Mark E. <Mark.Haedicke@ENRON.com>",
     "False": 5,
     "True": 0,
     "Grand Total": 5
     },
     {
     "EmailFrom": "Hansen  Leslie <Leslie.Hansen@ENRON.com>",
     "False": 5,
     "True": 0,
     "Grand Total": 5
     },
     {
     "EmailFrom": "Kolle  Brian <Brian_Kolle@ENRON.net>",
     "False": 5,
     "True": 0,
     "Grand Total": 5
     },
     {
     "EmailFrom": "Milnthorp  Rob <Rob.Milnthorp@ENRON.com>",
     "False": 5,
     "True": 0,
     "Grand Total": 5
     },
     {
     "EmailFrom": "Presto  Kevin M. <Kevin.M.Presto@ENRON.com>",
     "False": 5,
     "True": 0,
     "Grand Total": 5
     },
     {
     "EmailFrom": "Zipper  Andy <Andy.Zipper@ENRON.com>",
     "False": 5,
     "True": 0,
     "Grand Total": 5
     },
     {
     "EmailFrom": "Adrian Clark AClark@firstcallassociates.com@ENRON",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Barkley  Tom <Tom.Barkley@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Diamond  Russell <Russell.Diamond@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - on 
     behalf of - The Prince",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Enron Media Cuttings <enron.london.mediacuttings@Enron.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Fairley  David DFairley@tractebelusa.com@ENRON",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Hayden  Frank <Frank.Hayden@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Hodge  Jeffrey T. <Jeffrey.T.Hodge@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Hull  Bryan <Bryan.Hull@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Lu  Zimin <Zimin.Lu@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Mark.Bridges@ubsw.com@ENRON",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Mattias Palm Mattias.Palm@paconsulting.com@ENRON",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Pearson  Peter <Peter.Pearson@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Robinson  Claudia claudia.robinson@ubsw.com@ENRON",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Rostant  Justin <Justin.Rostant@ENRON.com>",
     "False": 4,
     "True": 2,
     "Grand Total": 6
     },
     {
     "EmailFrom": "Slagle  Carrie <Carrie.Slagle@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Smith  Will <Will.Smith@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Superty  Robert <Robert.Superty@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Taylor  Liz <Liz.Taylor@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Taylor  Mark E (Legal) <Mark.Taylor@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "UBSW Energy Global Infrastructure <mbx_ubswGlobalInf@ENRON.com>",
     "False": 4,
     "True": 0,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - on 
     behalf of - Enron In A",
     "False": 1,
     "True": 4,
     "Grand Total": 5
     },
     {
     "EmailFrom": "Jay Rickerts <eCenter@williams.com>",
     "False": 0,
     "True": 4,
     "Grand Total": 4
     },
     {
     "EmailFrom": "John Phillips <jtp497@rcn.com>",
     "False": 0,
     "True": 4,
     "Grand Total": 4
     },
     {
     "EmailFrom": "Rangel  Ina <Ina.Rangel@ENRON.com>",
     "False": 1,
     "True": 4,
     "Grand Total": 5
     },
     {
     "EmailFrom": "Blair  Kit <Kit.Blair@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Cash  Michelle <Michelle.Cash@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Caudle  Becky <Becky.Caudle@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Clyatt  Julie <Julie.Clyatt@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Crawford, Sharon <Sharon.Crawford@ENRON.com> - on behalf of - Keohane  
     Peter <Peter.Keohane@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "David Good dgood@solarc.com@ENRON",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Jacoby  Ben <Ben.Jacoby@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Jafry  Rahil <Rahil.Jafry@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Jolly  Kevin <Kevin.Jolly@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "karimrashid karim@karimrashid.com@ENRON",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Keohane  Peter <Peter.Keohane@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Koehler  Anne C. <Anne.C.Koehler@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Lisk  Daniel <Daniel.Lisk@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Meyn  Jim <Jim.Meyn@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Miller  Don (Asset Mktg) <Don.Miller@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Piper  Greg <Greg.Piper@ENRON.com>",
     "False": 3,
     "True": 3,
     "Grand Total": 6
     },
     {
     "EmailFrom": "Schneider  Chip <Chip.Schneider@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Shapiro  Richard <Richard.Shapiro@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Shepperd  Tammy R. <Tammy.R.Shepperd@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Sherman  Cris <Cris.Sherman@ENRON.com>",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "soblander@carrfut.com@ENRON",
     "False": 3,
     "True": 0,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Beth <beth@angelflightsc.org>",
     "False": 0,
     "True": 3,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Bob Nimocks <BNimocks@ZeusDevelopment.com>",
     "False": 0,
     "True": 3,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - on 
     behalf of - ClickAtHom",
     "False": 0,
     "True": 3,
     "Grand Total": 3
     },
     {
     "EmailFrom": "General Announcement/Corp/Enron@ENRON <IMCEANOTES-General+20Announcement_Corp_Enron+40ENRON@ENRON.com> - on 
     behalf of - Enron Ch",
     "False": 0,
     "True": 3,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Human Resources <mbx_humanresources@ENRON.com>",
     "False": 2,
     "True": 3,
     "Grand Total": 5
     },
     {
     "EmailFrom": "Jackson  Mark <Mark.Jackson@ENRON.com>",
     "False": 0,
     "True": 3,
     "Grand Total": 3
     },
     {
     "EmailFrom": "May  Larry <Larry.May@ENRON.com>",
     "False": 0,
     "True": 3,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Miller  Tim <millertr@bp.com>",
     "False": 0,
     "True": 3,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Whitney Casso <WCasso@ZeusDevelopment.com>",
     "False": 0,
     "True": 3,
     "Grand Total": 3
     },
     {
     "EmailFrom": "7133540022@skytel.com@ENRON",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Aaron Marks aamarks@apmrecruiting.com@ENRON",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "avillarreal73@yahoo.com@ENRON",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Beck  Sally <Sally.Beck@ENRON.com>",
     "False": 2,
     "True": 1,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Bolton  Stacey <Stacey.Bolton@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Brackett  Debbie R. <Debbie.R.Brackett@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Brownfeld  Gail <Gail.Brownfeld@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Buckley  Karen <Karen.Buckley@ENRON.com>",
     "False": 2,
     "True": 1,
     "Grand Total": 3
     },
     {
     "EmailFrom": "Coleman  Mike <Mike.Coleman@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Daniels  Eddy <Eddy.Daniels@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Dodgen  Kathy <Kathy.Dodgen@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Douglas  Stephen H. <Stephen.H.Douglas@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Edwin Fitts edwinfitts@hotmail.com@ENRON",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Elbertson  Janette <Janette.Elbertson@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - on 
     behalf of - Enron Prop",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - on 
     behalf of - Ken Lay - ",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "enronmediacuttings@enron.com",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Fitzsimmons  Brendan <Brendan.Fitzsimmons@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Foster  Chris H. <Chris.H.Foster@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Gandhi  Sachin <Sachin.Gandhi@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "General Announcement/Corp/Enron@ENRON <IMCEANOTES-General+20Announcement_Corp_Enron+40ENRON@ENRON.com> - on 
     behalf of - Enron Ge",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "General Announcement/Corp/Enron@ENRON <IMCEANOTES-General+20Announcement_Corp_Enron+40ENRON@ENRON.com> - on 
     behalf of - Enron Hu",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Gilbert  Gerald <Gerald.Gilbert@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Gossett  Jeffrey C. <Jeffrey.C.Gossett@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Grigsby  Mike <Mike.Grigsby@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Herndon  Rogers <Rogers.Herndon@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Joyce  Mary <Mary.Joyce@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Ken Lay - Office of the Chairman <mbx_klayofficechair@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Lavorato  John <John.Lavorato@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Lea & Loftus Fitzwater Loftuslea@worldnet.att.net@ENRON",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Legal - James Derrick  Jr. <mbx_annclegal@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "McCullough  Travis <Travis.McCullough@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Mena  Luis <Luis.Mena@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Moon  Eric <Eric.Moon@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Novosel  Sarah <Sarah.Novosel@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Ortiz  Lucy <Lucy.Ortiz@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Radford  Pat <Pat.Radford@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "rajib saha rajibsaha59@hotmail.com@ENRON",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Rodriguez  Grace <Grace.Rodriguez@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Rostant jtrostant@yahoo.com@ENRON",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Rub  Jenny <Jenny.Rub@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Sager  Elizabeth <Elizabeth.Sager@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Slone  Jeanie <Jeanie.Slone@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Stock  Steve <Stephen.Stock@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Vu  Steven <Steven.Vu@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Vuittonet  Laura <Laura.Vuittonet@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Watson  Kimberly <Kimberly.Watson@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Webb",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Wiggs  Brett <Brett.R.Wiggs@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Zivic  Robyn <Robyn.Zivic@ENRON.com>",
     "False": 2,
     "True": 0,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - on 
     behalf of - Enron Chan",
     "False": 0,
     "True": 2,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Good Morning from Money.net <scoop@mailer.money.net>",
     "False": 0,
     "True": 2,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Webb  Jay <Jay.Webb@ENRON.com>",
     "False": 0,
     "True": 2,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Abel  Chris <Chris.Abel@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Arora  Harry <Harry.Arora@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Audrey.Martin@ubsw.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Baughman Jr.  Don <Don.Baughman@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Becker  Lorraine <Lorraine.Becker@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Berquist  Thomas thomas.berquist@gs.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Bess  Erica <Erica.Bess@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Beth.Barrett@ubsw.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "bo.normark@ch.abb.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Bowen Jr.  Raymond <Raymond.Bowen@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Bradford",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Brewster  Jessica JYBrewster@SWIDLAW.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Brooks  Loretta <Loretta_Brooks@ENRON.net>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Bryan.Murtagh@ubsw.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Cantrell  Rebecca W. <Rebecca.W.Cantrell@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Cappelletto, Nella <Nella.Cappelletto@ENRON.com> - on behalf of - Milnthorp  
     Rob <Rob.Milnthorp@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Castleman  Kent <Kent.Castleman@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Chris Hanson chris.hanson@excambria.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Clyatt",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "colette.dow@ubsw.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Curry  Mike <Mike.Curry@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Curt Chrestman curt@libation.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Dasovich  Jeff <Jeff.Dasovich@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Davies  Neil <Neil.Davies@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Delgado  Lydia <lydia.delgado@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Denne  Karen <Karen.Denne@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Domain.Manager@register.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Dugger  Tony <Tony.Dugger@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Duran  W. David <W.David.Duran@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Elbertson, Janette <Janette.Elbertson@ENRON.com> - on behalf of - Haedicke  
     Mark E. <Mark.Haedicke@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> 
     - on behalf of - eSource@EN",
     "False": 1,
     "True": 1,
     "Grand Total": 2
     },
     {
     "EmailFrom": "Espinoza",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Exchange System Administrator <postmaster@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "fashion@kingshilldirect.co.uk@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Fels  Nicholas nfels@cov.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Fitzpatrick  Amy <Amy.Fitzpatrick@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Forster",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Garland  Kevin <Kevin.Garland@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Gil  Mercy <Mercy.Gil@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Golden  Jeff <Jeff.Golden@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Gray  Chris <Chris.Gray@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Gray  Dortha <Dortha.Gray@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Guadarrama  Michael <Michael.Guadarrama@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Guerrero  Janel <Janel.Guerrero@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Hall  Joe <Joe.Hall@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Hall  Steve C. (Legal) <Steve.C.Hall@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Harry Arora harrysarora@yahoo.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Hedstrom  Peggy <Peggy.Hedstrom@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Hodges  Georganne <Georgeanne.Hodges@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Hodges  Georgeanne <Georgeanne.Hodges@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Intellor Group info@intellor.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Jeff McMahon - President & COO <mbx_anncjmcmahon@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "JJMagovern@aol.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "John Phillips jtp497@rcn.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "John.Costas@ubsw.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "John.Magovern@ubsw.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "JPCJPC57@aol.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Kimmel  Debra [FI] debra.kimmel@ssmb.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Legal - James Derrick Jr. <mbx_annclegal@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Llodra  John <John.Llodra@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Lowry",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Luce  Laura <Laura.Luce@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Mara  Susan <Susan.J.Mara@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Mark.Jones@rwetrading.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Mcginnis  Stephanie <Stephanie.McGinnis@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Melodick  Kim <Kim.Melodick@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "MHeffner@carrfut.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Migden  Janine <Janine.Migden@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Miller  Kevin <Kevin.Miller@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Neal  Scott <Scott.Neal@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Nord  Sue <Sue.Nord@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "O'Donnell - UBS  Pat <Pat.O'Donnell@enron.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "orders@gymboree.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "pat odonnell pat2od@yahoo.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Portz  David <David.Portz@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "postmaster@ENRON.com",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Reck  Daniel <Daniel.Reck@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Richter  Brad <Brad.Richter@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Robinson  Mitch <Mitch.Robinson@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Sanjeev.Karkhanis@ubs.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Scrimshaw  Matthew <matthew.scrimshaw@enron.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Shankman  Jeffrey A. <Jeffrey.A.Shankman@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Sherriff  John <john.sherriff@enron.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "St. Clair, Carol <Carol.St.Clair@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Stuckey  Richard A [FI] richard.a.stuckey@ssmb.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Sulistio  Franky <Franky.Sulistio@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Tamekia e18736@newmail.ru@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Taylor  Mitch <Mitchell.Taylor@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Theriot  Kim S. <Kim.S.Theriot@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Thode  Eric <Eric.Thode@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Tribolet  Michael <Michael.Tribolet@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Tycholiz  Barry <Barry.Tycholiz@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "UBSW Energy General Announcements <mbx_anncubsw@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "uu002000@yahoo.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Van Vuuren  Dirk <dirk.van.vuuren@enron.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Vandor  David <David.Vandor@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Vickers  Frank <Frank.Vickers@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Wallumrod  Ellen <Ellen.Wallumrod@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "White  Stacey W. <Stacey.W.White@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Whitman  Britt <Britt.Whitman@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Williamson  Joannie <Joannie.Williamson@ENRON.com>",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "X. George Huan xjhuan@yahoo.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Xuan Pollard xpollard@richardfreemanco.com@ENRON",
     "False": 1,
     "True": 0,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Andrew Zipper <aazccb@swbell.net>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Arnold  John <John.Arnold@ENRON.com>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Bibi  Philippe A. <Philippe.A.Bibi@ENRON.com>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Boyd  Justin <justin.boyd@enron.com>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Carter  Carl <Carl.Carter@ENRON.com>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - 
     on behalf of - Corporate ",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - 
     on behalf of - Derryl Cle",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - 
     on behalf of - Enron Amer",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - 
     on behalf of - Jim Derric",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Enron Announcements/Corp/Enron@ENRON <IMCEANOTES-Enron+20Announcements_Corp_Enron+40ENRON@ENRON.com> - 
     on behalf of - Ken Lay- C",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "FTD.COM@mail2.ftdi.com",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Johnson  Adam <Adam.Johnson@ENRON.com>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Khanna  Sanjeev <Sanjeev.Khanna@ENRON.com>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Mcquade  Jennifer <Jennifer.McQuade@ENRON.com>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Miertschin  Beth <Beth.Miertschin@ENRON.com>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Office of the Chairman <OfficeoftheChairman6@ENRON.com>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Puthigai  Savita <Savita.Puthigai@ENRON.com>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     },
     {
     "EmailFrom": "Solis  Felicia <Felicia_Solis@ENRON.net>",
     "False": 0,
     "True": 1,
     "Grand Total": 1
     }
  ],
  "TotalCount": 277,
  "QueryToken": "",
  "Success": true,
  "Message": "SUCCESS"
}

Helper operations

To help you determine which fields you can use to group and pivot data in a Pivot query, the Pivot Manager Service provides the following helper operations:

  • getGroupByFieldsForDocuments – Returns a list of fields that are in a workspace and enabled for grouping data.
  • getPivotOnFieldsForDocuments – Returns a list of fields that are in a workspace and enabled for pivoting data.

Note that the list of fields that is returned includes only those fields that you have permission to view. As is the case with Pivot queries, the helper operations use the permission settings of the active user account.

getGroupByFieldsForDocuments

To get a list of all the fields that you can use to group data in a workspace, send an HTTP(S) POST request to the following URL:

http://localhost/relativity.rest/api/Relativity.Services.Pivot.IPivotModule/Pivot%20Manager/GetFieldsForGroupByAsync

Required fields for the request are workspaceId and ArtifactTypeId. For example, the following request returns a list of fields that are in a workspace that has an Artifact identifier value of “1234567”, apply to the Document object, can be used to group data, and the active user has permission to view:

{
     workspaceId: 1234567,
     ArtifactTypeId: 10
};

The JSON response returns the Artifact identifier, view field identifier, and name of each field:

{
     "ArtifactID": 1055916,
     "ViewFieldID": 1001647,
     "Guids": [],
     "Name": "Date Sent"
},
{
     "ArtifactID": 1039789,
     "ViewFieldID": 1001039,
     "Guids": [],
     "Name": "Docs_Languages::Language"
},
{
     "ArtifactID": 1055919,
     "ViewFieldID": 1001650,
     "Guids": [],
     "Name": "Email From"
},
{
     "ArtifactID": 1055923,
     "ViewFieldID": 1001654,
     "Guids": [],
     "Name": "Extension"
}

When you create a custom query, you can use any of those identifiers to specify the field that you want to use to group data.

getPivotOnFieldsForDocuments

To get a list of all the fields that you can use to pivot data in a workspace, send an HTTP(S) POST request to the following URL:

http://localhost/relativity.rest/api/Relativity.Services.Pivot.IPivotModule/Pivot%20Manager/GetFieldsForPivotOnAsync

Required fields for the request are workspaceId and ArtifactTypeId. In the following example, the request returns a list of fields that are in a workspace that has an Artifact identifier value of “1234567”, apply to the Document object, can be used to pivot data, and the active user has permission to view:

{
     workspaceId: 1234567,
     ArtifactTypeId: 10
};

The JSON response returns the Artifact identifier, view field identifier, and name of each field:

{
     "ArtifactID": 1055916,
     "ViewFieldID": 1001647,
     "Guids": [],
     "Name": "Date Sent"
},
{
     "ArtifactID": 1039789,
     "ViewFieldID": 1001039,
     "Guids": [],
     "Name": "Docs_Languages::Language"
},
{
     "ArtifactID": 1055919,
     "ViewFieldID": 1001650,
     "Guids": [],
     "Name": "Email From"
},
{
     "ArtifactID": 1055923,
     "ViewFieldID": 1001654,
     "Guids": [],
     "Name": "Extension"
}

When you create a custom query, you can use any of those identifiers to specify the field that you want to use to pivot data.