List of APIs

POST report/list

Returns reports for the report list.

Request

Payload: a ReportDashboardSearchCriteria object

Response

An array of Category objects

Samples

POST/api/report/listHTTP/1.1

Request payload:

{"tenantId":null,"type":0}

Excerpt of the response:

[{"reports":[],"subCategories":[{"reports":[{"name":"Report in Category 1",}],"subCategories":null,"name":null,},{"reports":[{"name":"Report #1 in Category 1 - Sub-category 2",},{"name":"Report #2 in Category 1 - Sub-category 2",}],"subCategories":null,"name":"Sub-category 2",}],"name":"Category 1",},{"reports":[],"subCategories":[{"reports":[{"name":null,}],"subCategories":null,"name":null,}],"name":"Category 2",},{"reports":[],"subCategories":[{"reports":[{"name":"Report #1 in Uncategorized",},{"name":"Report #2 in Uncategorized",}],"subCategories":null,"name":null,}],"name":null,}]

POST report/list2(?includeHashCode=true)

Returns reports for the report list with total number of item

Request

Payload: a ReportDashboardSearchCriteria object

Optional query string: includeHashCode=true

Response

• Without includeHashCode: an array of Category objects

• With includeHashCode=true: the following object:

  Field	Description	Note
  data array of objects	An array of Category objects
  hashcode string	The hashcode
  totalItems string	The number of all reports
  numOfChilds integer	The number of children
  numOfCheckedChilds integer	The number of selected children
  indeterminate boolean	true if 0 < numOfCheckedChilds < numOfChilds false if not
  isLastPage boolean	Whether this is the last page

Samples

POST/api/report/list2?includeHashCode=trueHTTP/1.1

Sample payload:

{"tenantId":"b930adf8-5bfd-4214-97e3-f709f10721fb","isUncategorized":false,"skipItems":0,"pageSize":100,"parentIds":[],"includeGlobalCategory":true,"isGlobal":null,"criterias":[{"key":"CategoryId"}]}

Sample response:

{"data":[{"name":"Global Categories","type":0,"parentId":null,"tenantId":null,"isGlobal":true,"canDelete":false,"editable":false,"savable":false,"subCategories":[{"name":"Common Reports","type":0,"parentId":null,"tenantId":null,"isGlobal":true,"canDelete":false,"editable":false,"savable":false,"subCategories":[{"name":null,"type":0,"parentId":"b5f6be66-9a00-4422-ad2f-31e00ecfd2f9","tenantId":null,"isGlobal":true,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":[{"name":"Example Report Name","reportDataSource":[{"reportId":"daefaa42-75b2-4b07-8ef8-019134109054","querySourceId":"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c","querySourceUniqueName":"[con;#0].[cat;#0].[Orders]","querySourceCategoryId":"0e8d2b0b-010d-46e5-8dc4-ff048d6f5e07","connectionId":"ca12331b-f917-47ae-8397-3758bc393bdb","selected":false,"id":null,"state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null}],"type":0,"previewRecord":0,"advancedMode":false,"allowNulls":false,"isDistinct":false,"categoryId":"b5f6be66-9a00-4422-ad2f-31e00ecfd2f9","categoryName":null,"subCategoryId":null,"subCategoryName":null,"tenantId":"00000000-0000-0000-0000-000000000000","tenantName":null,"description":"","title":null,"lastViewed":"2017-04-26T14:12:21.023","owner":"John Doe","ownerId":"d928e941-19ef-4382-ba60-7238cb555631","excludedRelationships":null,"numberOfView":1,"renderingTime":301,"createdById":"d928e941-19ef-4382-ba60-7238cb555631","modifiedById":null,"snapToGrid":false,"usingFields":null,"hasDeletedObjects":false,"header":null,"footer":null,"titleDescription":null,"sourceId":null,"checked":false,"copyDashboard":false,"exportFormatSetting":null,"deletable":false,"editable":false,"movable":false,"copyable":false,"accessPriority":1,"active":true,"fullPath":null,"computeNameSettings":null,"isGlobal":true,"id":"daefaa42-75b2-4b07-8ef8-019134109054","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-04-26T14:07:20.527","createdBy":"John Doe","modified":"2017-04-26T14:07:20.527","modifiedBy":"John Doe"}],"dashboards":[],"numOfChilds":1,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"id":null,"state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null}],"checked":false,"reports":[],"dashboards":[],"numOfChilds":1,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"id":"b5f6be66-9a00-4422-ad2f-31e00ecfd2f9","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null},{"name":"Sample Reports","type":0,"parentId":null,"tenantId":null,"isGlobal":true,"canDelete":false,"editable":false,"savable":false,"subCategories":[{"name":null,"type":0,"parentId":"7f4adac8-df78-4aa0-8695-b78c55b7a47c","tenantId":null,"isGlobal":true,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":[{"name":"Sample Orders Report","reportDataSource":[{"reportId":"f9348e0e-7572-426d-bf83-0d6a043aaeb8","querySourceId":"f4ae63fc-4c10-4672-9cd2-4a9d40434a4c","querySourceUniqueName":"[con;#0].[cat;#0].[Orders]","querySourceCategoryId":"0e8d2b0b-010d-46e5-8dc4-ff048d6f5e07","connectionId":"ca12331b-f917-47ae-8397-3758bc393bdb","selected":false,"id":null,"state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null}],"type":0,"previewRecord":0,"advancedMode":false,"allowNulls":false,"isDistinct":false,"categoryId":"7f4adac8-df78-4aa0-8695-b78c55b7a47c","categoryName":null,"subCategoryId":null,"subCategoryName":null,"tenantId":"00000000-0000-0000-0000-000000000000","tenantName":null,"description":"","title":null,"lastViewed":"2017-04-26T05:17:30.237","owner":"John Doe","ownerId":"d928e941-19ef-4382-ba60-7238cb555631","excludedRelationships":null,"numberOfView":1,"renderingTime":395,"createdById":"d928e941-19ef-4382-ba60-7238cb555631","modifiedById":null,"snapToGrid":false,"usingFields":null,"hasDeletedObjects":false,"header":null,"footer":null,"titleDescription":null,"sourceId":null,"checked":false,"copyDashboard":false,"exportFormatSetting":null,"deletable":false,"editable":false,"movable":false,"copyable":false,"accessPriority":1,"active":true,"fullPath":null,"computeNameSettings":null,"isGlobal":true,"id":"f9348e0e-7572-426d-bf83-0d6a043aaeb8","state":0,"deleted":false,"inserted":true,"version":2,"created":"2017-04-26T04:58:33.193","createdBy":"John Doe","modified":"2017-04-26T14:03:58.093","modifiedBy":"John Doe"}],"dashboards":[],"numOfChilds":1,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"id":null,"state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null}],"checked":false,"reports":[],"dashboards":[],"numOfChilds":1,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"id":"7f4adac8-df78-4aa0-8695-b78c55b7a47c","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null}],"checked":false,"reports":[],"dashboards":[],"numOfChilds":2,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"id":"2a83e3ce-f91b-4f14-910d-76cadf42d0fe","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null},{"name":"Local Categories","type":0,"parentId":null,"tenantId":null,"isGlobal":false,"canDelete":false,"editable":false,"savable":false,"subCategories":[{"name":"ACME User1 Reports","type":0,"parentId":null,"tenantId":null,"isGlobal":false,"canDelete":false,"editable":false,"savable":false,"subCategories":[{"name":null,"type":0,"parentId":"41e231f8-cde8-450d-bad3-6c029839024c","tenantId":null,"isGlobal":false,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":[{"name":"ACME Orders Report","reportDataSource":[{"reportId":"d574770e-e7ad-4a0a-a228-44f387e27a91","querySourceId":"6b33591c-4fe5-47cd-8195-58be404deca3","querySourceUniqueName":"[con;#0].[cat;#0].[Orders]","querySourceCategoryId":"62e49cf3-4513-49ea-a710-b9630b6b9f20","connectionId":"f9fc7a8c-39b3-4d05-bc2c-cb194ef2d6f5","selected":false,"id":null,"state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null}],"type":0,"previewRecord":0,"advancedMode":false,"allowNulls":false,"isDistinct":false,"categoryId":"41e231f8-cde8-450d-bad3-6c029839024c","categoryName":null,"subCategoryId":null,"subCategoryName":null,"tenantId":"b930adf8-5bfd-4214-97e3-f709f10721fb","tenantName":null,"description":"","title":null,"lastViewed":null,"owner":"User1 ACME","ownerId":"ea22549d-4384-4b3c-9ae7-1f73ca16ad27","excludedRelationships":null,"numberOfView":0,"renderingTime":0,"createdById":"ea22549d-4384-4b3c-9ae7-1f73ca16ad27","modifiedById":null,"snapToGrid":false,"usingFields":null,"hasDeletedObjects":false,"header":null,"footer":null,"titleDescription":null,"sourceId":null,"checked":false,"copyDashboard":false,"exportFormatSetting":null,"deletable":true,"editable":true,"movable":true,"copyable":true,"accessPriority":1,"active":true,"fullPath":null,"computeNameSettings":null,"isGlobal":false,"id":"d574770e-e7ad-4a0a-a228-44f387e27a91","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-04-26T04:54:59.84","createdBy":"User1 ACME","modified":"2017-04-26T04:54:59.84","modifiedBy":"User1 ACME"}],"dashboards":[],"numOfChilds":1,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"id":null,"state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null}],"checked":false,"reports":[],"dashboards":[],"numOfChilds":1,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"id":"41e231f8-cde8-450d-bad3-6c029839024c","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null}],"checked":false,"reports":[],"dashboards":[],"numOfChilds":1,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"id":"09f8c4ab-0fe8-4e03-82d1-7949e3738f87","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"User1 ACME","modified":null,"modifiedBy":null}],"hashcode":"f567df70cd9be737e65afd3b95d","totalItems":8,"numOfChilds":2,"numOfCheckedChilds":0,"indeterminate":false,"isLastPage":true}

GET report/info/{report_id}/(version)

Returns report properties for the report specified by report_id and version.
Returns latest version if version parameter is null.

Request

No payload

Response

A ReportDefinition object

Samples

GET/api/report/info/5447a5c1-a0c8-4bf6-bd68-f09234ba5e84/1HTTP/1.1

Sample response:

{"inaccessible":false,"category":{"name":"CN","type":0,"parentId":null,"tenantId":"b5b3a5cc-9e55-424c-ae85-ba92ec3b934e","isGlobal":false,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":[],"dashboards":null,"numOfChilds":0,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"isCheck":false,"id":"5ca51cd0-1f63-44ca-9711-ba6c988a520a","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"System5 Admin5","modified":null,"modifiedBy":null},"subCategory":{"name":"Example","type":0,"parentId":"5ca51cd0-1f63-44ca-9711-ba6c988a520a","tenantId":"b5b3a5cc-9e55-424c-ae85-ba92ec3b934e","isGlobal":false,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":[],"dashboards":null,"numOfChilds":0,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"isCheck":false,"id":"41a3dff9-d1da-48e5-b4fb-50775324bd3d","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"System5 Admin5","modified":null,"modifiedBy":null},"reportRelationship":[],"reportPart":[],"reportFilter":{"filterFields":[],"baseFilterLogic":null,"logic":null,"visible":false,"reportId":"00000000-0000-0000-0000-000000000000","id":null,"state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"System5 Admin5","modified":null,"modifiedBy":null},"calculatedFields":[],"accesses":[],"schedules":[],"reportParams":[{"categories":[{"querySourceNames":["Shippers"],"id":"942c529a-38c7-4ffc-9e46-044c3f364130","name":"dbo"}],"id":"5e97b5e4-bf85-4be8-8244-cf195bdf4739","name":"SQL-Northwind"}],"dynamicQuerySourceFields":[],"name":"ExampleReport","reportDataSource":[{"reportId":"5447a5c1-a0c8-4bf6-bd68-f09234ba5e84","querySourceId":null,"querySourceUniqueName":"[con;#0].[cat;#0].[Shippers]","querySourceCategoryId":null,"connectionId":null,"selected":false,"id":"3c0ea817-d230-4a1b-8ec5-0b836b824da3","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-09-27T10:20:46.45","createdBy":"System5 Admin5","modified":"2017-09-27T10:20:46.45","modifiedBy":"System5 Admin5"}],"type":0,"previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"categoryId":"5ca51cd0-1f63-44ca-9711-ba6c988a520a","categoryName":"CN","subCategoryId":"41a3dff9-d1da-48e5-b4fb-50775324bd3d","subCategoryName":"Example","tenantId":"b5b3a5cc-9e55-424c-ae85-ba92ec3b934e","tenantName":"ACME","description":"","title":"","lastViewed":"2017-09-27T10:21:16.503","owner":"System5 Admin5","ownerId":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","excludedRelationships":"","numberOfView":1,"renderingTime":112,"createdById":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","modifiedById":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","snapToGrid":false,"usingFields":"d5a8a521-6832-4973-8b2c-3360dc52814c,fe0d4e44-cf3e-43a3-a575-02b086d6da71","hasDeletedObjects":false,"header":{"visible":false,"items":[{"isDirty":false,"type":"image","label":"Image","id":"formatDetails_42","positionX":0,"positionY":0,"width":6,"height":6,"name":"Logo Image","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","imageUrl":"http://","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_43","positionX":20,"positionY":0,"width":12,"height":2,"name":"Report Name","value":"{reportName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"thinHorizontalRule","label":"Horizontal Rule","id":"formatDetails_44","positionX":20,"positionY":4,"width":12,"height":1,"name":"Upper Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":2,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_45","positionX":20,"positionY":5,"width":6,"height":2,"name":"Report Generated","value":"Report Generated:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_46","positionX":20,"positionY":7,"width":6,"height":2,"name":"User","value":"User:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_47","positionX":20,"positionY":9,"width":6,"height":2,"name":"Tenant","value":"Tenant:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"dateTime","label":"Date Time","id":"formatDetails_48","positionX":26,"positionY":5,"width":6,"height":2,"name":"Current Date Time","value":"{currentDateTime}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_49","positionX":26,"positionY":7,"width":6,"height":2,"name":"Current User Name","value":"{currentUserName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_50","positionX":26,"positionY":9,"width":6,"height":2,"name":"Tenant Name","value":"{tenantName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"horizontalRule","label":"Horizontal Rule","id":"formatDetails_51","positionX":0,"positionY":11,"width":32,"height":1,"name":"Lower Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":4,"isSelected":false}]},"footer":{"visible":false,"items":[{"isDirty":false,"type":"horizontalRule","label":"Horizontal Rule","id":"formatDetails_52","positionX":0,"positionY":0,"width":32,"height":1,"name":"Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":4,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_53","positionX":0,"positionY":1,"width":10,"height":2,"name":"Footer Text","value":"Footer Text","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_54","positionX":20,"positionY":1,"width":4,"height":2,"name":"Page","value":"Page","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"pageNumber","label":"Page Number","id":"formatDetails_55","positionX":24,"positionY":1,"width":8,"height":2,"name":"Page Number","value":"{pageNumber}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false}]},"titleDescription":{"visible":false,"items":[{"isDirty":false,"type":"title","label":"Title","id":"formatDetails_56","name":"Title","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"description","label":"Description","id":"formatDetails_57","name":"Description","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false}]},"sourceId":null,"checked":false,"copyDashboard":false,"exportFormatSetting":{"orientation":0,"margins":0,"centerOnPage":{"horizontally":false,"vertically":false},"pageBreakAfterReportPart":false,"marginSettings":[{"type":3,"topValue":0.75,"bottomValue":0.75,"leftValue":0.7,"rightValue":0.7,"headerValue":0.3,"footerValue":0.3},{"type":0,"topValue":0.75,"bottomValue":0.75,"leftValue":0.7,"rightValue":0.7,"headerValue":0.3,"footerValue":0.3},{"type":1,"topValue":0.75,"bottomValue":0.75,"leftValue":0.25,"rightValue":0.25,"headerValue":0.3,"footerValue":0.3},{"type":2,"topValue":1,"bottomValue":1,"leftValue":1,"rightValue":1,"headerValue":0.5,"footerValue":0.5}]},"deletable":false,"editable":false,"movable":false,"copyable":false,"accessPriority":0,"active":false,"fullPath":null,"computeNameSettings":null,"isGlobal":false,"isCheck":false,"id":"5447a5c1-a0c8-4bf6-bd68-f09234ba5e84","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-09-27T10:20:46.277","createdBy":"System5 Admin5","modified":"2017-09-27T10:20:46.277","modifiedBy":"System5 Admin5"}

POST report/copy

Copies report to another name or category.

Request

Payload: a ReportDefinition object

Response

• The new id string value if success
• Empty string value if not.

Samples

POST/api/report/copyHTTP/1.1

Request payload:

{"id":"41023c5b-3fe5-4a62-8ecf-7aae8974f63f","name":"TestReport02_copied","version":0,"category":{"id":"1c0060df-ebf9-4287-a67a-900b014afc0d","name":"Category01_renamed","type":1},"subCategory":{"type":1,"parentId":"1c0060df-ebf9-4287-a67a-900b014afc0d"},"type":1,"tenantId":null}

Response:

"552d20ce-1269-4cb4-a679-0cd51d3e2058"

POST report/move

Moves report to another name or category.

Request

Payload: a ReportDefinition object

Response

• true if successful
• false if not

Samples

POST/api/report/listHTTP/1.1

Request payload:

{"id":"552d20ce-1269-4cb4-a679-0cd51d3e2058","name":"TestReport02_copied","version":0,"category":{"id":"98fb305b-b340-4245-88da-bb7f34b4211e","name":"Category02","type":1},"subCategory":{"type":1,"parentId":"98fb305b-b340-4245-88da-bb7f34b4211e"},"type":1,"tenantId":null}

Response:

true

POST report/history

Returns report history.

Request

Payload: a ReportHistoryPagedRequest object

Note:

The keys for SearchCriteria that this API support:
- All
- Version
- Status
- Modified
- ModifiedBy
- Keyword

Response

A PagedResult object, with result field containing an array of ReportHistory objects

Samples

POST/api/report/historyHTTP/1.1

Request payload:

{"reportId":"41023c5b-3fe5-4a62-8ecf-7aae8974f63f","tenantId":null,"criteria":[{"key":"All","value":"","operation":1}],"pageIndex":1,"pageSize":10,"sortOrders":[{"key":"version","descending":true}]}

Response:

{"result":[{"reportId":"41023c5b-3fe5-4a62-8ecf-7aae8974f63f","reportName":"TestReport02","description":null,"definition":null,"status":"Active","id":"41023c5b-3fe5-4a62-8ecf-7aae8974f63f","state":0,"inserted":true,"version":2,"created":"2016-07-13T08:05:25.587","createdBy":null,"modified":"2016-07-14T03:51:38","modifiedBy":null},{"reportId":"41023c5b-3fe5-4a62-8ecf-7aae8974f63f","reportName":"Report01","description":null,"definition":null,"status":"Archived","id":"abd8102b-b807-4ac5-9520-812a21e44b55","state":0,"inserted":true,"version":1,"created":"2016-07-13T08:05:25.587","createdBy":null,"modified":"2016-07-13T08:05:25.587","modifiedBy":null}],"pageIndex":1,"pageSize":10,"total":2}

GET report/history/{report_id}/(version)

Returns a specific version of a report.

Returns oldest available version when version parameter is missing.

Request

No payload

Response

An ReportDefinition object

Samples

GET/api/report/history/41023c5b-3fe5-4a62-8ecf-7aae8974f63f/HTTP/1.1

Sample response:

{"inaccessible":false,"category":{"name":"CN","type":0,"parentId":null,"tenantId":"b5b3a5cc-9e55-424c-ae85-ba92ec3b934e","isGlobal":false,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":[],"dashboards":null,"numOfChilds":0,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"isCheck":false,"id":"5ca51cd0-1f63-44ca-9711-ba6c988a520a","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"System5 Admin5","modified":null,"modifiedBy":null},"subCategory":{"name":"Example","type":0,"parentId":"5ca51cd0-1f63-44ca-9711-ba6c988a520a","tenantId":"b5b3a5cc-9e55-424c-ae85-ba92ec3b934e","isGlobal":false,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":[],"dashboards":null,"numOfChilds":0,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"isCheck":false,"id":"41a3dff9-d1da-48e5-b4fb-50775324bd3d","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"System5 Admin5","modified":null,"modifiedBy":null},"reportRelationship":[],"reportPart":[],"reportFilter":{"filterFields":[],"baseFilterLogic":null,"logic":null,"visible":false,"reportId":"00000000-0000-0000-0000-000000000000","id":null,"state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"System5 Admin5","modified":null,"modifiedBy":null},"calculatedFields":[],"accesses":[],"schedules":[],"reportParams":[{"categories":[{"querySourceNames":["Shippers"],"id":"942c529a-38c7-4ffc-9e46-044c3f364130","name":"dbo"}],"id":"5e97b5e4-bf85-4be8-8244-cf195bdf4739","name":"SQL-Northwind"}],"dynamicQuerySourceFields":[],"name":"ExampleReport","reportDataSource":[{"reportId":"5447a5c1-a0c8-4bf6-bd68-f09234ba5e84","querySourceId":null,"querySourceUniqueName":"[con;#0].[cat;#0].[Shippers]","querySourceCategoryId":null,"connectionId":null,"selected":false,"id":"3c0ea817-d230-4a1b-8ec5-0b836b824da3","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-09-27T10:20:46.45","createdBy":"System5 Admin5","modified":"2017-09-27T10:20:46.45","modifiedBy":"System5 Admin5"}],"type":0,"previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"categoryId":"5ca51cd0-1f63-44ca-9711-ba6c988a520a","categoryName":"CN","subCategoryId":"41a3dff9-d1da-48e5-b4fb-50775324bd3d","subCategoryName":"Example","tenantId":"b5b3a5cc-9e55-424c-ae85-ba92ec3b934e","tenantName":"ACME","description":"","title":"","lastViewed":"2017-09-27T10:21:16.503","owner":"System5 Admin5","ownerId":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","excludedRelationships":"","numberOfView":1,"renderingTime":112,"createdById":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","modifiedById":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","snapToGrid":false,"usingFields":"d5a8a521-6832-4973-8b2c-3360dc52814c,fe0d4e44-cf3e-43a3-a575-02b086d6da71","hasDeletedObjects":false,"header":{"visible":false,"items":[{"isDirty":false,"type":"image","label":"Image","id":"formatDetails_42","positionX":0,"positionY":0,"width":6,"height":6,"name":"Logo Image","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","imageUrl":"http://","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_43","positionX":20,"positionY":0,"width":12,"height":2,"name":"Report Name","value":"{reportName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"thinHorizontalRule","label":"Horizontal Rule","id":"formatDetails_44","positionX":20,"positionY":4,"width":12,"height":1,"name":"Upper Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":2,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_45","positionX":20,"positionY":5,"width":6,"height":2,"name":"Report Generated","value":"Report Generated:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_46","positionX":20,"positionY":7,"width":6,"height":2,"name":"User","value":"User:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_47","positionX":20,"positionY":9,"width":6,"height":2,"name":"Tenant","value":"Tenant:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"dateTime","label":"Date Time","id":"formatDetails_48","positionX":26,"positionY":5,"width":6,"height":2,"name":"Current Date Time","value":"{currentDateTime}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_49","positionX":26,"positionY":7,"width":6,"height":2,"name":"Current User Name","value":"{currentUserName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_50","positionX":26,"positionY":9,"width":6,"height":2,"name":"Tenant Name","value":"{tenantName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"horizontalRule","label":"Horizontal Rule","id":"formatDetails_51","positionX":0,"positionY":11,"width":32,"height":1,"name":"Lower Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":4,"isSelected":false}]},"footer":{"visible":false,"items":[{"isDirty":false,"type":"horizontalRule","label":"Horizontal Rule","id":"formatDetails_52","positionX":0,"positionY":0,"width":32,"height":1,"name":"Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":4,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_53","positionX":0,"positionY":1,"width":10,"height":2,"name":"Footer Text","value":"Footer Text","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_54","positionX":20,"positionY":1,"width":4,"height":2,"name":"Page","value":"Page","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"pageNumber","label":"Page Number","id":"formatDetails_55","positionX":24,"positionY":1,"width":8,"height":2,"name":"Page Number","value":"{pageNumber}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false}]},"titleDescription":{"visible":false,"items":[{"isDirty":false,"type":"title","label":"Title","id":"formatDetails_56","name":"Title","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"description","label":"Description","id":"formatDetails_57","name":"Description","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false}]},"sourceId":null,"checked":false,"copyDashboard":false,"exportFormatSetting":{"orientation":0,"margins":0,"centerOnPage":{"horizontally":false,"vertically":false},"pageBreakAfterReportPart":false,"marginSettings":[{"type":3,"topValue":0.75,"bottomValue":0.75,"leftValue":0.7,"rightValue":0.7,"headerValue":0.3,"footerValue":0.3},{"type":0,"topValue":0.75,"bottomValue":0.75,"leftValue":0.7,"rightValue":0.7,"headerValue":0.3,"footerValue":0.3},{"type":1,"topValue":0.75,"bottomValue":0.75,"leftValue":0.25,"rightValue":0.25,"headerValue":0.3,"footerValue":0.3},{"type":2,"topValue":1,"bottomValue":1,"leftValue":1,"rightValue":1,"headerValue":0.5,"footerValue":0.5}]},"deletable":false,"editable":false,"movable":false,"copyable":false,"accessPriority":0,"active":false,"fullPath":null,"computeNameSettings":null,"isGlobal":false,"isCheck":false,"id":"5447a5c1-a0c8-4bf6-bd68-f09234ba5e84","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-09-27T10:20:46.277","createdBy":"System5 Admin5","modified":"2017-09-27T10:20:46.277","modifiedBy":"System5 Admin5"}

POST report/version/{report_id}/(version)

Returns a specific version of a report.

Request

Optional payload.

Field	Description	Note
action integer	Specify the action from client site - null, undefined or 1: view the report - 2: cancel the report	Optional
page string(GUID)	Id of the current web page	Optional

Response

A ReportDefinition object.

Samples

POSTreport/version/0ef9192c-121c-421a-8562-0a1fe8b0ade0/1/HTTP/1.1

Sample Response:

{"inaccessible":false,"category":{"name":"aaa","type":0,"parentId":null,"tenantId":"b5b3a5cc-9e55-424c-ae85-ba92ec3b934e","isGlobal":false,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":[],"dashboards":null,"numOfChilds":0,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"isCheck":false,"id":"5265bffb-dc9b-4403-afa2-a736ec69cfd5","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"System5 Admin5","modified":null,"modifiedBy":null},"subCategory":{"name":"bbb","type":0,"parentId":"5265bffb-dc9b-4403-afa2-a736ec69cfd5","tenantId":"b5b3a5cc-9e55-424c-ae85-ba92ec3b934e","isGlobal":false,"canDelete":false,"editable":false,"savable":false,"subCategories":[],"checked":false,"reports":[],"dashboards":null,"numOfChilds":0,"numOfCheckedChilds":0,"indeterminate":false,"fullPath":null,"computeNameSettings":null,"isCheck":false,"id":"d1d41128-ab4b-44ed-a5b4-73dadbdd8178","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"System5 Admin5","modified":null,"modifiedBy":null},"reportRelationship":[],"reportPart":[{"reportPartContent":{"columns":{"text":null,"properties":{},"settings":{},"elements":[{"name":"OrderID","properties":{"isDirty":false,"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{"id":null,"name":""},"format":{"createNewHiddenPercenOfGroupField":false},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"width":{"value":null},"alignment":"alignLeft","sort":"Unsort","color":{"textColor":{"rangePercent":null,"rangeValue":null,"value":null},"cellColor":{"rangePercent":null,"rangeValue":null,"value":null}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"LINK_NEW_WINDOW"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""},"grandTotal":{"label":"","function":"","expression":"","dataType":"","format":{},"previewResult":""}},"headerFormating":{"font":{"family":null,"size":null,"bold":null,"italic":null,"underline":null,"color":null,"backgroundColor":null},"alignment":null,"wordWrap":null,"columnGroup":""},"drillDown":{"subReport":{"selectedReport":null,"style":null,"reportPartUsed":null,"reportFilter":true,"mappingFields":[],"selectedIconValue":{"icon":null,"value":null},"viewSettingByLink":null}},"otherProps":{}},"settings":{},"chartType":null,"showTotal":false,"position":1,"field":{"fieldId":"b5ea4297-8fe1-47d2-bfde-13b2eef6c36d","fieldUniqueName":"[con;#0].[cat;#0].[orders].[OrderID]","originalName":null,"fieldName":"OrderID","fieldNameAlias":"OrderID","dataFieldType":"Numeric","querySourceId":"5eec76ff-4de9-403a-a7dd-66a9db4e6eba","querySourceUniqueName":"[con;#0].[cat;#0].[orders]","querySourceType":"Table","sourceAlias":"orders","querySourceAlias":null,"runningDeep":-1,"isRunningField":false,"builtRunningField":false,"relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"filterable":false,"reportId":null,"fieldFunctionExpression":"","expression":null,"grandTotalExpression":"","grandTotalFormat":null,"subTotalExpression":"","subtotalFormat":null,"sort":"Unsorted","autoSort":false,"function":"","formating":{"format":null,"createNewHiddenPercenOfGroupField":false},"functionDataType":"","isCalculated":false,"hasAggregatedFunction":false,"invalidField":0,"isCrossFilter":false}}]},"rows":{"text":null,"properties":{},"settings":{},"elements":[]},"values":{"text":null,"properties":{},"settings":{},"elements":[]},"separators":{"text":null,"properties":{},"settings":{},"elements":[]},"paginable":true,"type":"3","properties":{"isDirty":true,"generalInfo":{"gridStyle":"Vertical","separatorStyle":"Comma"},"table":{"border":{"top":{"color":null,"dashStyle":null,"thinkness":null},"right":{"color":null,"dashStyle":null,"thinkness":null},"bottom":{"color":null,"dashStyle":null,"thinkness":null},"midVer":{"color":null,"dashStyle":null,"thinkness":null},"left":{"color":null,"dashStyle":null,"thinkness":null},"midHor":{"color":null,"dashStyle":null,"thinkness":null}},"backgroundColor":"#fff"},"columns":{"width":{"value":150},"alterBackgroundColor":false},"rows":{"alterBackgroundColor":false},"headers":{"font":{"family":"Roboto","size":14,"bold":true,"italic":false,"underline":false,"color":"#000000","backgroundColor":"#E4E4E4"},"alignment":"center","wordWrap":false,"removeHeaderForExport":false},"grouping":{"useSeparator":true},"view":{"dataRefreshInterval":{"enable":false,"updateInterval":0,"isAll":true,"latestRecord":0},"usePagination":true,"collapseDrilldownByDefault":false,"pageSize":10,"pivotColumnsPerExportedPage":""},"printing":{"usePageBreakAfterSeparator":false}},"settings":{},"title":{"text":"","properties":{},"settings":{"font":{"family":"","size":14,"bold":true,"italic":false,"underline":false,"color":"","highlightColor":""},"alignment":{"alignment":""}},"elements":[]},"description":{"text":"","properties":{},"settings":{"font":{"family":"","size":14,"bold":false,"italic":false,"underline":false,"color":"","highlightColor":""},"alignment":{"alignment":""}},"elements":[]},"expandedLevel":-1,"isCrossFiltering":false,"isFormatted":false},"title":"Grid","positionX":0,"positionY":0,"width":0,"height":0,"reportId":"0ef9192c-121c-421a-8562-0a1fe8b0ade0","numberOfRecord":null,"sourceId":null,"id":"2297e2ca-420b-499c-b628-c4f64ec60375","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-09-22T10:10:22.567","createdBy":"ACME Cooperation","modified":"2017-09-22T10:10:22.567","modifiedBy":"ACME Cooperation"}],"reportFilter":{"filterFields":[],"baseFilterLogic":"","logic":"","visible":false,"reportId":"0ef9192c-121c-421a-8562-0a1fe8b0ade0","id":"03a2bc07-6c19-4038-8f03-786e6050cd43","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-09-22T10:10:22.563","createdBy":"ACME Cooperation","modified":"2017-09-22T10:10:22.563","modifiedBy":"ACME Cooperation"},"calculatedFields":[],"accesses":[],"schedules":[],"reportParams":[{"categories":[{"querySourceNames":["orders"],"id":"94454a0a-17a2-49e5-bebf-9c0d07d95587","name":"northwind"}],"id":"6cc06e5b-0627-432c-bc33-708b0843c7c7","name":"northwind"}],"dynamicQuerySourceFields":[],"name":"test5","reportDataSource":[{"reportId":"0ef9192c-121c-421a-8562-0a1fe8b0ade0","querySourceId":"5eec76ff-4de9-403a-a7dd-66a9db4e6eba","querySourceUniqueName":"[con;#0].[cat;#0].[orders]","querySourceCategoryId":null,"connectionId":null,"selected":false,"id":"2455781c-0daa-4e46-b9f0-3780b518fdce","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-09-22T10:10:22.563","createdBy":"ACME Cooperation","modified":"2017-09-22T10:10:22.563","modifiedBy":"ACME Cooperation"}],"type":0,"previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"categoryId":"5265bffb-dc9b-4403-afa2-a736ec69cfd5","categoryName":"aaa","subCategoryId":"d1d41128-ab4b-44ed-a5b4-73dadbdd8178","subCategoryName":"bbb","tenantId":"b5b3a5cc-9e55-424c-ae85-ba92ec3b934e","tenantName":"ACME","description":"","title":"","lastViewed":"2017-09-28T02:47:52.19","owner":"ACME Cooperation","ownerId":"88ca2835-81e0-443b-b29e-e694a66b8e7a","excludedRelationships":"","numberOfView":1,"renderingTime":359.0,"createdById":"88ca2835-81e0-443b-b29e-e694a66b8e7a","modifiedById":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","snapToGrid":false,"usingFields":"b5ea4297-8fe1-47d2-bfde-13b2eef6c36d","hasDeletedObjects":false,"header":{"visible":false,"items":[{"isDirty":false,"type":"image","label":"Image","id":"formatDetails_40","positionX":0,"positionY":0,"width":6,"height":6,"name":"Logo Image","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","imageUrl":"http://","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_41","positionX":20,"positionY":0,"width":12,"height":2,"name":"Report Name","value":"{reportName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"thinHorizontalRule","label":"Horizontal Rule","id":"formatDetails_42","positionX":20,"positionY":4,"width":12,"height":1,"name":"Upper Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":2,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_43","positionX":20,"positionY":5,"width":6,"height":2,"name":"Report Generated","value":"Report Generated:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_44","positionX":20,"positionY":7,"width":6,"height":2,"name":"User","value":"User:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_45","positionX":20,"positionY":9,"width":6,"height":2,"name":"Tenant","value":"Tenant:","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"dateTime","label":"Date Time","id":"formatDetails_46","positionX":26,"positionY":5,"width":6,"height":2,"name":"Current Date Time","value":"{currentDateTime}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_47","positionX":26,"positionY":7,"width":6,"height":2,"name":"Current User Name","value":"{currentUserName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_48","positionX":26,"positionY":9,"width":6,"height":2,"name":"Tenant Name","value":"{tenantName}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"horizontalRule","label":"Horizontal Rule","id":"formatDetails_49","positionX":0,"positionY":11,"width":32,"height":1,"name":"Lower Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":4,"isSelected":false}]},"footer":{"visible":false,"items":[{"isDirty":false,"type":"horizontalRule","label":"Horizontal Rule","id":"formatDetails_50","positionX":0,"positionY":0,"width":32,"height":1,"name":"Separator Line","value":"{horizontalRule}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":4,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_51","positionX":0,"positionY":1,"width":10,"height":2,"name":"Footer Text","value":"Footer Text","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_52","positionX":20,"positionY":1,"width":4,"height":2,"name":"Page","value":"Page","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"pageNumber","label":"Page Number","id":"formatDetails_53","positionX":24,"positionY":1,"width":8,"height":2,"name":"Page Number","value":"{pageNumber}","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false}]},"titleDescription":{"visible":false,"items":[{"isDirty":false,"type":"title","label":"Title","id":"formatDetails_54","name":"Title","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false},{"isDirty":false,"type":"description","label":"Description","id":"formatDetails_55","name":"Description","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1,"isSelected":false}]},"sourceId":null,"checked":false,"copyDashboard":false,"exportFormatSetting":{"orientation":0,"margins":0,"centerOnPage":{"horizontally":false,"vertically":false},"pageBreakAfterReportPart":false,"marginSettings":[{"type":3,"topValue":0.75,"bottomValue":0.75,"leftValue":0.7,"rightValue":0.7,"headerValue":0.3,"footerValue":0.3},{"type":0,"topValue":0.75,"bottomValue":0.75,"leftValue":0.7,"rightValue":0.7,"headerValue":0.3,"footerValue":0.3},{"type":1,"topValue":0.75,"bottomValue":0.75,"leftValue":0.25,"rightValue":0.25,"headerValue":0.3,"footerValue":0.3},{"type":2,"topValue":1.0,"bottomValue":1.0,"leftValue":1.0,"rightValue":1.0,"headerValue":0.5,"footerValue":0.5}]},"deletable":true,"editable":true,"movable":true,"copyable":true,"accessPriority":1,"active":true,"fullPath":null,"computeNameSettings":null,"isGlobal":false,"isCheck":false,"id":"0ef9192c-121c-421a-8562-0a1fe8b0ade0","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-09-22T10:10:22.447","createdBy":"ACME Cooperation","modified":"2017-09-26T08:52:48.553","modifiedBy":"System5 Admin5"}