Pivot Manager (REST)
This page contains the following information:
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 in Relativity REST APIs.
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 Relativity
{ "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 execute 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 Relativity
{ "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 } }
Execute a custom Pivot query
To execute 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:
- Queries all documents in a workspace.
- Groups data by the email address stored in a Fixed-Length Text field named “Email From”.
- 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 Relativity

{ "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.