Report Designer Data and Expressions APIs
The Report Designer page allows users to:
- create a report
- select report data sources
- create report filters
- design report layout
- set up report schedule
This page documents the APIs related to data and expressions.
Summary
| API | Purpose | Usage in Izenda Front-end |
|---|---|---|
| POST fusion/validateExpression | Validates calculated field expression syntax and returns a suggested data type (can handle multiple data sources). See also: POST fusion/validateDataModelExpression |
Report Designer > Fields > Add Calculated Field > Expression |
| POST fusion/validateGrandTotalExpression | Validates grand total expression syntax and returns a suggested data type. | In Report Designer > Field Properties > Grand Total > Choose [Expression] in Grand Total Funtion dropdown list > Input an expression |
| POST fusion/validateSubTotalExpression | Validates sub total expression syntax and returns a suggested data type. Same request and response as POST fusion/validateGrandTotalExpression |
In Report Designer > Field Properties > Sub Total > Choose [Expression] in Sub Total Funtion dropdown list > Input an expression |
| POST fusion/loadData | Loads data for report. | Report Viewer |
| POST fusion/reportPartPreview | Loads preview data for report part. | In Report Designer: - Add any field to the container - OR Copy a report part |
| POST fusion/previewGrandTotal | Loads preview data for grand total. | In Report Designer > Field Properties > Grand Total > Input all required fields in Grand Total Settings popup > Click on “Preview” button |
| GET fusion/{report_id}/{report_part_id}/(pageIndex)/(pageSize) | Loads report part data with paging and optional overridden filter values and operators. | |
| POST fusion/validateDataModelExpression | Validates a calculated field expression in Data Model and returns a suggested data type (in a single data source). See also: POST fusion/validateExpression |
Settings > Data Setup > Data Model > Tables > Add Calculated Field > Expression |
| POST fusion/previewCalculatedField | Loads preview data for a calculated field. | Report Designer - Field > Addd Calculated Field > Preview |
| POST fusion/previewSubTotal | Loads preview data for sub total. | In Report Designer > Field Properties > Sub Total > Input all required fields in Sub Total Settings popup > Click on “Preview” button |
| POST fusion/calculatedFieldValue | Returns a single calculated field value for preview section. | |
| POST fusion/retrieveRandomExpandedLevelData | Returns random expanded level data. | |
| POST fusion/printQuery | Returns the sql query for a data request. | |
| POST fusion/reportPartPreview | Returns data for a report part preview request. |
|
| GET fusion/printQuery/{reportId}/{reportPartId}/(pageIndex)/(pageSize) | Returns the sql query for a report part load with paging and optional overridden filter values and operators. |
POST fusion/validateExpression
Validates filter expression syntax and returns a suggested data type (can handle multiple data sources).
See also: POST fusion/validateDataModelExpression
Request
Payload: a ReportExpressionParameter object
Response
A ValidationOperationResult object
Samples
POST/api/fusion/validateExpressionHTTP/1.1Request payload:
{"reportKey":{"key":"c0091e01-22f9-44a5-99e3-eb656a1fcebd"},"expression":"RUNNINGCOUNT([SQL-Northwind].[dbo].[Order Details].[OrderID])","izendaDataType":"Numeric","querySourceFieldId":null,"previewRecord":10}Response:
{"result":{"izendaDataType":"Numeric","isRunningField":false,"isCompositeField":false},"success":true,"messages":[],"data":null}
POST fusion/validateGrandTotalExpression
Validates grand total expression syntax and returns a suggested data type.
Request
Payload: a ReportPartValidateExpressionParameter object
Response
An ValidationOperationResult object
Samples
POST/api/fusion/validateGrandTotalExpressionHTTP/1.1Request payload:{"reportKey":{"key":"1e1316a9-b6ce-46c8-9496-671fd5ddeee1"},"report":{"name":"","type":"Templates","previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"category":{"id":null,"name":"","type":"Templates"},"subCategory":{"id":null,"name":"","type":"Templates"},"reportDataSource":[{"aliasId":"1641cb37-b60c-42bc-b986-c51667e8037d_Suppliers","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceName":"Suppliers","selected":true,"categoryId":"00000000-0000-0000-0000-000000000000","primaryFields":[{"name":"SupplierID","alias":"","dataType":"int","izendaDataType":"Numeric","allowDistinct":false,"visible":true,"filterable":true,"deleted":false,"querySourceId":"00000000-0000-0000-0000-000000000000","parentId":null,"expressionFields":[],"filteredValue":"","type":0,"groupPosition":0,"position":0,"extendedProperties":"{\"PrimaryKey\":true}","physicalChange":0,"approval":0,"existed":false,"matchedTenant":false,"functionName":null,"expression":null,"fullName":null,"calculatedTree":null,"reportId":null,"originalName":"SupplierID","isParameter":false,"isCalculated":false,"querySource":null,"id":"47954424-fff3-4157-9296-ad08b751e71d","state":0,"inserted":true,"version":null,"created":null,"createdBy":null,"modified":"0001-01-01T00:00:00.0000000-08:00","modifiedBy":null}]}],"reportRelationship":[],"reportFilter":{"logic":"","visible":false,"filterFields":[],"id":"4a75d01f-1fb3-4eca-ae13-8f17d41289ea","reportId":"1e1316a9-b6ce-46c8-9496-671fd5ddeee1"},"reportPart":[{"isDirty":true,"reportPartContent":{"isDirty":false,"type":3,"columns":{"text":null,"properties":{},"settings":{},"elements":[{"reportPartContent":null,"isDirty":false,"name":"Country","properties":{"isDirty":false,"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{},"format":{},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"alignment":"alignLeft","sort":"","color":{"textColor":{},"cellColor":{}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"Open link in New Window"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","previewResult":"","fieldDataType":"Text"},"grandTotal":{"label":"Total Number of Countries","function":"Count Distinct","expression":"","dataType":"Numeric","previewResult":10,"fieldDataType":"Text"}},"headerFormating":{"width":{"value":0,"unit":"pixels"},"height":0,"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":[]}},"otherProps":{}},"position":1,"field":{"fieldId":"76139896-c2c3-432e-898a-2c2205bb2e35","fieldName":"Country","fieldNameAlias":"Country","dataFieldType":"Text","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceType":"Table","sourceAlias":"Suppliers","relationshipId":null,"visible":true,"calculatedTree":null,"schemaName":"dbo","querySourceName":"Suppliers","databaseName":"Northwind","isCalculated":false},"isDeleted":false,"isSelected":true},{"reportPartContent":null,"isDirty":true,"name":"Count (SupplierID)","properties":{"isDirty":true,"fieldItemVisible":true,"dataFormattings":{"function":"8a74f4e0-b845-4b9e-adfa-bb678a116878","functionInfo":{"id":"8a74f4e0-b845-4b9e-adfa-bb678a116878","name":"Count","expression":null,"dataType":"Numeric","formatDataType":"Numeric","syntax":null,"expressionSyntax":null,"isOperator":false},"format":{},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"alignment":"alignLeft","sort":"","color":{"textColor":{},"cellColor":{}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"Open link in New Window"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","previewResult":"","fieldDataType":"Numeric"},"grandTotal":{"label":"","function":"","expression":"","dataType":"","previewResult":"","fieldDataType":"Numeric"}},"headerFormating":{"width":{"value":0,"unit":"pixels"},"height":{},"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":[]}},"otherProps":{}},"position":2,"field":{"fieldId":"47954424-fff3-4157-9296-ad08b751e71d","fieldName":"SupplierID","fieldNameAlias":"Count (SupplierID)","dataFieldType":"Numeric","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceType":"Table","sourceAlias":"Suppliers","relationshipId":null,"visible":true,"calculatedTree":null,"schemaName":"dbo","querySourceName":"Suppliers","databaseName":"Northwind","isCalculated":false},"isDeleted":false,"isSelected":false}],"name":"columns"},"rows":{"text":null,"properties":{},"settings":{},"elements":[],"name":"rows"},"values":{"text":null,"properties":{},"settings":{},"elements":[],"name":"values"},"separators":{"text":null,"properties":{},"settings":{},"elements":[],"name":"separators"},"properties":{"isDirty":true,"generalInfo":{"gridStyle":"Vertical","separatorStyle":"Comma"},"table":{"backgroundColor":"#efefef","border":{"top":{},"right":{},"bottom":{},"midVer":{},"left":{},"midHor":{}}},"columns":{"width":{"value":null,"unit":"Pixels"},"alterBackgroundColor":false},"rows":{"height":40,"alterBackgroundColor":false},"headers":{"font":{"family":"Roboto","size":14,"bold":true,"italic":false,"underline":false,"backgroundColor":"#dbf2ff"},"alignment":"left","wordWrap":true,"removeHeaderForExport":false},"grouping":{"useSeparator":false},"view":{"dataRefreshInterval":{"enable":false,"updateInterval":0,"isAll":true,"latestRecord":0}}},"settings":{},"dataSource":{},"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":[]}},"reportId":"00000000-0000-0000-0000-000000000000","positionX":0,"positionY":0,"width":12,"height":4,"state":3,"modified":null,"numberOfRecord":0,"isBackSide":true,"expandedLevel":0,"points":[{"key":"All","filter":[{"key":"","value":""}],"expandedLevel":0,"isViewSeparator":false}],"isSelected":true,"title":"Grid","id":"561dba1e-f799-42be-be9d-bbfa078aee43"}],"version":0},"title":"Grid","expression":"","reportField":{"fieldId":"76139896-c2c3-432e-898a-2c2205bb2e35","fieldName":"Country","fieldNameAlias":"Country","dataFieldType":"Text","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceType":"Table","sourceAlias":"Suppliers","relationshipId":null,"visible":true,"calculatedTree":null,"schemaName":"dbo","querySourceName":"Suppliers","databaseName":"Northwind","isCalculated":false}}Response:
{"result":{"izendaDataType":"Numeric"},"success":true,"messages":[],"data":null}
POST fusion/validateSubTotalExpression
Validates sub total expression syntax and returns a suggested data type.
Request
Payload: a ReportPartValidateExpressionParameter object
Response
An ValidationOperationResult object
Samples
POST/api/fusion/validateSubTotalExpressionHTTP/1.1Request payload:{"reportKey":{"key":"eb627589-cc33-47a6-9031-3ad1f2787638","tenantId":"28788c9b-4e0d-464e-b588-ea5bee676bd3"},"report":{"name":"exReport","type":0,"previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"categoryId":"c279ed4d-f4d0-4abd-8d10-d396512ee77a","category":{"id":"c279ed4d-f4d0-4abd-8d10-d396512ee77a","name":"myCategory","type":0,"tenantId":"28788c9b-4e0d-464e-b588-ea5bee676bd3"},"subCategory":{"id":null,"name":"","type":0,"tenantId":"28788c9b-4e0d-464e-b588-ea5bee676bd3"},"subCategoryId":null,"reportDataSource":[{"aliasId":"7a9c6bda-ac03-4f79-9c8e-9d4c21a2bc03_film_actor","querySourceId":"7a9c6bda-ac03-4f79-9c8e-9d4c21a2bc03","querySourceName":"film_actor","selected":true,"categoryId":"30077a15-9fef-42af-8b24-d224ab7757ba","primaryFields":[{"name":"actor_id","alias":"","dataType":"smallint","izendaDataType":"Numeric","allowDistinct":false,"visible":true,"filterable":true,"querySourceId":"00000000-0000-0000-0000-000000000000","parentId":null,"expressionFields":[],"filteredValue":"","type":0,"groupPosition":0,"position":0,"extendedProperties":"{\"PrimaryKey\":true}","physicalChange":0,"approval":0,"existed":false,"matchedTenant":false,"functionName":null,"expression":null,"isRunningField":false,"fullName":null,"calculatedTree":null,"reportId":null,"originalName":"actor_id","originalId":"00000000-0000-0000-0000-000000000000","isParameter":false,"isCalculated":false,"hasAggregatedFunction":false,"querySource":null,"querySourceName":null,"categoryName":null,"inaccessible":false,"originalAlias":null,"fullPath":null,"isCheck":false,"id":"070926fc-0ffe-449c-aa4b-867cc09c6399","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"System5 Admin5","modified":"0001-01-01T00:00:00","modifiedBy":null},{"name":"film_id","alias":"","dataType":"smallint","izendaDataType":"Numeric","allowDistinct":false,"visible":true,"filterable":true,"querySourceId":"00000000-0000-0000-0000-000000000000","parentId":null,"expressionFields":[],"filteredValue":"","type":0,"groupPosition":0,"position":0,"extendedProperties":"{\"PrimaryKey\":true}","physicalChange":0,"approval":0,"existed":false,"matchedTenant":false,"functionName":null,"expression":null,"isRunningField":false,"fullName":null,"calculatedTree":null,"reportId":null,"originalName":"film_id","originalId":"00000000-0000-0000-0000-000000000000","isParameter":false,"isCalculated":false,"hasAggregatedFunction":false,"querySource":null,"querySourceName":null,"categoryName":null,"inaccessible":false,"originalAlias":null,"fullPath":null,"isCheck":false,"id":"bf92615e-e775-422e-8ef7-335affbe9fad","state":0,"deleted":false,"inserted":true,"version":null,"created":null,"createdBy":"System5 Admin5","modified":"0001-01-01T00:00:00","modifiedBy":null}]}],"reportRelationship":[],"reportFilter":{"logic":"","visible":false,"filterFields":[],"id":"f018f1f9-e5ac-4569-869e-c3c5417dbde1","reportId":"eb627589-cc33-47a6-9031-3ad1f2787638"},"reportPart":[{"isDirty":false,"reportPartContent":{"subReportDefinitionCollection":[],"collapseStatus":0,"isDirty":false,"isCrossFiltering":false,"type":"3","columns":{"text":null,"properties":{},"settings":{},"elements":[{"reportPartContent":null,"isDirty":false,"name":"actor_id","properties":null,"position":1,"field":{"fieldId":"070926fc-0ffe-449c-aa4b-867cc09c6399","fieldName":"actor_id","fieldNameAlias":"actor_id","dataFieldType":"Numeric","querySourceId":"7a9c6bda-ac03-4f79-9c8e-9d4c21a2bc03","querySourceType":"Table","sourceAlias":"film_actor","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"isRunningField":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false,"offset":null},{"reportPartContent":null,"isDirty":false,"name":"film_id","properties":{"isDirty":false,"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{"id":null,"name":""},"format":{"createNewHiddenPercenOfGroupField":false},"font":null,"width":{"value":null},"alignment":"alignLeft","sort":"Unsort","color":null,"alternativeText":null,"customURL":null,"embeddedJavascript":null,"subTotal":{"label":"Subtotal film_id","function":"[Expression]","expression":"COUNT([film_id]) * 10","dataType":"Numeric","format":{},"previewResult":"","fieldDataType":"Numeric","previewRecord":10},"grandTotal":null},"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":{}},"position":2,"field":{"fieldId":"bf92615e-e775-422e-8ef7-335affbe9fad","fieldName":"film_id","fieldNameAlias":"film_id","dataFieldType":"Numeric","querySourceId":"7a9c6bda-ac03-4f79-9c8e-9d4c21a2bc03","querySourceType":"Table","sourceAlias":"film_actor","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"isRunningField":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false,"offset":null}],"name":"columns"},"rows":null,"values":null,"separators":null,"properties":{"isDirty":false,"generalInfo":{"gridStyle":"Vertical","separatorStyle":"Comma"},"table":null,"columns":{"width":{"value":150},"alterBackgroundColor":false},"rows":{"alterBackgroundColor":false},"headers":null,"grouping":{"useSeparator":true},"view":{"dataRefreshInterval":{"enable":false,"updateInterval":0,"isAll":true,"latestRecord":0},"usePagination":true,"collapseDrilldownByDefault":false,"pageSize":10,"pivotColumnsPerExportedPage":""},"printing":{"usePageBreakAfterSeparator":false}},"settings":null,"changeGridStyleStatus":true,"inconsitentFunction":false,"dataSource":{},"title":null,"description":null},"reportId":"eb627589-cc33-47a6-9031-3ad1f2787638","width":4,"height":6,"state":0,"modified":null,"numberOfRecord":null,"configField":{"reportPartContent":null,"isDirty":false,"name":"film_id","properties":{"isDirty":false,"fieldItemVisible":true,"dataFormattings":null,"headerFormating":null,"drillDown":{"subReport":{"selectedReport":null,"style":null,"reportPartUsed":null,"reportFilter":true,"mappingFields":[],"selectedIconValue":{"icon":null,"value":null},"viewSettingByLink":null}},"otherProps":{}},"position":2,"field":{"fieldId":"bf92615e-e775-422e-8ef7-335affbe9fad","fieldName":"film_id","fieldNameAlias":"film_id","dataFieldType":"Numeric","querySourceId":"7a9c6bda-ac03-4f79-9c8e-9d4c21a2bc03","querySourceType":"Table","sourceAlias":"film_actor","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"isRunningField":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false,"offset":{"x":561.15625,"y":582,"width":79.84375,"height":22,"left":561.15625,"right":641,"top":582,"bottom":604}},"stateReview":0,"refreshDataProcess":null,"refreshDataInterval":null,"positionY":0,"positionX":0,"title":"Grid","id":"8a23ae27-7e6f-4236-ad74-8e42c89ddcf1"}],"header":null,"footer":null,"titleDescription":null,"version":1,"schedules":[],"ownerId":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","accesses":[],"exportFormatSetting":null,"createdById":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","dynamicQuerySourceFields":[],"snapToGrid":false,"excludedRelationships":"","isGlobal":false},"title":"Grid","expression":"COUNT([film_id]) * 10","izendaDataType":"Numeric","reportField":{"fieldId":"bf92615e-e775-422e-8ef7-335affbe9fad","fieldName":"film_id","fieldNameAlias":"film_id","dataFieldType":"Numeric","querySourceId":"7a9c6bda-ac03-4f79-9c8e-9d4c21a2bc03","querySourceType":"Table","sourceAlias":"film_actor","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"isRunningField":false,"hasAggregatedFunction":false},"querySourceFieldId":null,"previewRecord":10}Sample succesful response:
{"result":{"izendaDataType":"Numeric"},"success":true,"messages":[],"data":null}
POST fusion/loadData
Loads data for report.
Request
Payload: a FusionDataRequest object
Response
A FusionResult object
Samples
POST/api/fusion/loadDataHTTP/1.1Request payload:
{"reportId":"49911d8e-aed6-43f2-8df6-35d82a1c2d49","reportPartId":"a83414fa-7616-4a1b-8e2c-89289deb509c","expandedLevel":-1}Sample response:
{"grandTotalMapping":[],"subTotalMapping":[],"sideTotalMapping":[],"records":[{"customerid_e0272ef4_a4b8_":"VINET","employeeid_32f2548d_87bf_":5},{"customerid_e0272ef4_a4b8_":"TOMSP","employeeid_32f2548d_87bf_":6},{"customerid_e0272ef4_a4b8_":"HANAR","employeeid_32f2548d_87bf_":4},{"customerid_e0272ef4_a4b8_":"VICTE","employeeid_32f2548d_87bf_":3},{"customerid_e0272ef4_a4b8_":"SUPRD","employeeid_32f2548d_87bf_":4},{"customerid_e0272ef4_a4b8_":"HANAR","employeeid_32f2548d_87bf_":3},{"customerid_e0272ef4_a4b8_":"CHOPS","employeeid_32f2548d_87bf_":5},{"customerid_e0272ef4_a4b8_":"RICSU","employeeid_32f2548d_87bf_":9},{"customerid_e0272ef4_a4b8_":"WELLI","employeeid_32f2548d_87bf_":3},{"customerid_e0272ef4_a4b8_":"HILAA","employeeid_32f2548d_87bf_":4}],"fieldsMapping":[{"fieldId":"e0272ef4-a4b8-4cc6-b319-3c2794688e7c","fieldNameAlias":"CustomerID","columnName":"customerid_e0272ef4_a4b8_"},{"fieldId":"32f2548d-87bf-468d-846c-c7cc665da203","fieldNameAlias":"EmployeeID","columnName":"employeeid_32f2548d_87bf_"}],"paging":{"pageIndex":0,"pageSize":0,"total":0}}
POST fusion/reportPartPreview
Loads preview data for report part.
Request
Payload: a ReportPartPreviewParameter object
Response
An object or an array of FusionResult objects
Samples
POST/api/fusion/reportPartPreviewHTTP/1.1Request payload:{"reportKey":{"key":"1e1316a9-b6ce-46c8-9496-671fd5ddeee1","modified":null},"section":2,"saveAs":false,"ignoreCheckChange":false,"report":{"name":"","type":"Templates","previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"category":{"id":null,"name":"","type":"Templates"},"subCategory":{"id":null,"name":"","type":"Templates"},"reportDataSource":[{"aliasId":"1641cb37-b60c-42bc-b986-c51667e8037d_Suppliers","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceName":"Suppliers","selected":true,"categoryId":"00000000-0000-0000-0000-000000000000","primaryFields":[{"name":"SupplierID","alias":"","dataType":"int","izendaDataType":"Numeric","allowDistinct":false,"visible":true,"filterable":true,"deleted":false,"querySourceId":"00000000-0000-0000-0000-000000000000","parentId":null,"expressionFields":[],"filteredValue":"","type":0,"groupPosition":0,"position":0,"extendedProperties":"{\"PrimaryKey\":true}","physicalChange":0,"approval":0,"existed":false,"matchedTenant":false,"functionName":null,"expression":null,"fullName":null,"calculatedTree":null,"reportId":null,"originalName":"SupplierID","isParameter":false,"isCalculated":false,"querySource":null,"id":"47954424-fff3-4157-9296-ad08b751e71d","state":0,"inserted":true,"version":null,"created":null,"createdBy":null,"modified":"0001-01-01T00:00:00.0000000-08:00","modifiedBy":null}]}],"reportRelationship":[],"reportFilter":{"logic":"","visible":false,"filterFields":[],"id":"4a75d01f-1fb3-4eca-ae13-8f17d41289ea","reportId":"1e1316a9-b6ce-46c8-9496-671fd5ddeee1"},"reportPart":[{"isDirty":true,"reportPartContent":{"isDirty":false,"type":3,"columns":{"text":null,"properties":{},"settings":{},"elements":[{"reportPartContent":null,"isDirty":true,"name":"Country","properties":{"isDirty":true,"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{},"format":{},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"alignment":"alignLeft","sort":"","color":{"textColor":{},"cellColor":{}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"Open link in New Window"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","previewResult":"","fieldDataType":"Text"},"grandTotal":{"label":"Total Number of Countries","function":"Count Distinct","expression":"","dataType":"Numeric","previewResult":10,"fieldDataType":"Text"}},"headerFormating":{"width":{"value":0,"unit":"pixels"},"height":{},"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":[]}},"otherProps":{}},"position":1,"field":{"fieldId":"76139896-c2c3-432e-898a-2c2205bb2e35","fieldName":"Country","fieldNameAlias":"Country","dataFieldType":"Text","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceType":"Table","sourceAlias":"Suppliers","relationshipId":null,"visible":true,"calculatedTree":null,"schemaName":"dbo","querySourceName":"Suppliers","databaseName":"Northwind","isCalculated":false},"isDeleted":false,"isSelected":true},{"reportPartContent":null,"isDirty":true,"name":"Count (SupplierID)","properties":{"isDirty":true,"fieldItemVisible":true,"dataFormattings":{"function":"8a74f4e0-b845-4b9e-adfa-bb678a116878","functionInfo":{"id":"8a74f4e0-b845-4b9e-adfa-bb678a116878","name":"Count","expression":null,"dataType":"Numeric","formatDataType":"Numeric","syntax":null,"expressionSyntax":null,"isOperator":false},"format":{},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"alignment":"alignLeft","sort":"","color":{"textColor":{},"cellColor":{}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"Open link in New Window"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","previewResult":"","fieldDataType":"Numeric"},"grandTotal":{"label":"","function":"","expression":"","dataType":"","previewResult":"","fieldDataType":"Numeric"}},"headerFormating":{"width":{"value":0,"unit":"pixels"},"height":{},"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":[]}},"otherProps":{}},"position":2,"field":{"fieldId":"47954424-fff3-4157-9296-ad08b751e71d","fieldName":"SupplierID","fieldNameAlias":"Count (SupplierID)","dataFieldType":"Numeric","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceType":"Table","sourceAlias":"Suppliers","relationshipId":null,"visible":true,"calculatedTree":null,"schemaName":"dbo","querySourceName":"Suppliers","databaseName":"Northwind","isCalculated":false},"isDeleted":false,"isSelected":false}],"name":"columns"},"rows":{"text":null,"properties":{},"settings":{},"elements":[],"name":"rows"},"values":{"text":null,"properties":{},"settings":{},"elements":[],"name":"values"},"separators":{"text":null,"properties":{},"settings":{},"elements":[],"name":"separators"},"properties":{"isDirty":true,"generalInfo":{"gridStyle":"Vertical","separatorStyle":"Comma"},"table":{"backgroundColor":"#efefef","border":{"top":{},"right":{},"bottom":{},"midVer":{},"left":{},"midHor":{}}},"columns":{"width":{"value":null,"unit":"Pixels"},"alterBackgroundColor":false},"rows":{"height":40,"alterBackgroundColor":false},"headers":{"font":{"family":"Roboto","size":14,"bold":true,"italic":false,"underline":false,"backgroundColor":"#dbf2ff"},"alignment":"left","wordWrap":true,"removeHeaderForExport":false},"grouping":{"useSeparator":false},"view":{"dataRefreshInterval":{"enable":false,"updateInterval":0,"isAll":true,"latestRecord":0}}},"settings":{},"dataSource":{},"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":[]}},"reportId":"00000000-0000-0000-0000-000000000000","positionX":0,"positionY":0,"width":12,"height":4,"state":3,"modified":null,"numberOfRecord":0,"isBackSide":true,"expandedLevel":0,"points":[{"key":"All","filter":[{"key":"","value":""}],"expandedLevel":0,"isViewSeparator":false}],"isSelected":true,"title":"Grid","id":"561dba1e-f799-42be-be9d-bbfa078aee43"}],"version":0},"expandedLevel":-1,"filters":[],"title":"Grid"}Response:
{"grandTotalMapping":[{"fieldNameAlias":"Country","columnName":"grandtotal_country"}],"subTotalMapping":[],"sideTotalMapping":[],"records":[{"country_76139896_c2c3_":"Australia","countsup_supplieri_1e0310bebb":2,"grandtotal_country":10},{"country_76139896_c2c3_":"Brazil","countsup_supplieri_1e0310bebb":1,"grandtotal_country":10},{"country_76139896_c2c3_":"Canada","countsup_supplieri_1e0310bebb":2,"grandtotal_country":10},{"country_76139896_c2c3_":"Denmark","countsup_supplieri_1e0310bebb":1,"grandtotal_country":10},{"country_76139896_c2c3_":"Finland","countsup_supplieri_1e0310bebb":1,"grandtotal_country":10},{"country_76139896_c2c3_":"France","countsup_supplieri_1e0310bebb":3,"grandtotal_country":10},{"country_76139896_c2c3_":"Germany","countsup_supplieri_1e0310bebb":3,"grandtotal_country":10},{"country_76139896_c2c3_":"Italy","countsup_supplieri_1e0310bebb":2,"grandtotal_country":10},{"country_76139896_c2c3_":"Japan","countsup_supplieri_1e0310bebb":2,"grandtotal_country":10},{"country_76139896_c2c3_":"Netherlands","countsup_supplieri_1e0310bebb":1,"grandtotal_country":10}],"fieldsMapping":[{"fieldId":"76139896-c2c3-432e-898a-2c2204bb2e35","fieldNameAlias":"Country","columnName":"country_76139896_c2c3_"},{"fieldId":"47954424-fff3-4157-9296-ad08b751e71d","fieldNameAlias":"Count (SupplierID)","columnName":"countsup_supplieri_1e0310bebb"}]}
POST fusion/previewGrandTotal
Loads preview data for grand total.
Request
Payload: a ReportPartValidateExpressionParameter object
Response
A FusionPreviewResult object
Samples
POST/api/fusion/previewGrandTotalHTTP/1.1Request payload:{"reportKey":{"key":"1e1316a9-b6ce-46c8-9496-671fd5ddeee1"},"report":{"name":"","type":"Templates","previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"category":{"id":null,"name":"","type":"Templates"},"subCategory":{"id":null,"name":"","type":"Templates"},"reportDataSource":[{"aliasId":"1641cb37-b60c-42bc-b986-c51667e8037d_Suppliers","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceName":"Suppliers","selected":true,"categoryId":"00000000-0000-0000-0000-000000000000","primaryFields":[{"name":"SupplierID","alias":"","dataType":"int","izendaDataType":"Numeric","allowDistinct":false,"visible":true,"filterable":true,"deleted":false,"querySourceId":"00000000-0000-0000-0000-000000000000","parentId":null,"expressionFields":[],"filteredValue":"","type":0,"groupPosition":0,"position":0,"extendedProperties":"{\"PrimaryKey\":true}","physicalChange":0,"approval":0,"existed":false,"matchedTenant":false,"functionName":null,"expression":null,"fullName":null,"calculatedTree":null,"reportId":null,"originalName":"SupplierID","isParameter":false,"isCalculated":false,"querySource":null,"id":"47954424-fff3-4157-9296-ad08b751e71d","state":0,"inserted":true,"version":null,"created":null,"createdBy":null,"modified":"0001-01-01T00:00:00.0000000-08:00","modifiedBy":null}]}],"reportRelationship":[],"reportFilter":{"logic":"","visible":false,"filterFields":[],"id":"4a75d01f-1fb3-4eca-ae13-8f17d41289ea","reportId":"1e1316a9-b6ce-46c8-9496-671fd5ddeee1"},"reportPart":[{"isDirty":true,"reportPartContent":{"isDirty":false,"type":3,"columns":{"text":null,"properties":{},"settings":{},"elements":[{"reportPartContent":null,"isDirty":false,"name":"Country","properties":{"isDirty":false,"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{},"format":{},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"alignment":"alignLeft","sort":"","color":{"textColor":{},"cellColor":{}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"Open link in New Window"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","previewResult":"","fieldDataType":"Text"},"grandTotal":{"label":"Total Number of Countries","function":"Count Distinct","expression":"","dataType":"Numeric","previewResult":"","fieldDataType":"Text"}},"headerFormating":{"width":{"value":0,"unit":"pixels"},"height":0,"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":[]}},"otherProps":{}},"position":1,"field":{"fieldId":"76139896-c2c3-432e-898a-2c2205bb2e35","fieldName":"Country","fieldNameAlias":"Country","dataFieldType":"Text","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceType":"Table","sourceAlias":"Suppliers","relationshipId":null,"visible":true,"calculatedTree":null,"schemaName":"dbo","querySourceName":"Suppliers","databaseName":"Northwind","isCalculated":false},"isDeleted":false,"isSelected":true},{"reportPartContent":null,"isDirty":true,"name":"Count (SupplierID)","properties":{"isDirty":true,"fieldItemVisible":true,"dataFormattings":{"function":"8a74f4e0-b845-4b9e-adfa-bb678a116878","functionInfo":{"id":"8a74f4e0-b845-4b9e-adfa-bb678a116878","name":"Count","expression":null,"dataType":"Numeric","formatDataType":"Numeric","syntax":null,"expressionSyntax":null,"isOperator":false},"format":{},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"alignment":"alignLeft","sort":"","color":{"textColor":{},"cellColor":{}},"alternativeText":{"rangePercent":null,"rangeValue":null,"value":null},"customURL":{"url":"","option":"Open link in New Window"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","previewResult":"","fieldDataType":"Numeric"},"grandTotal":{"label":"","function":"","expression":"","dataType":"","previewResult":"","fieldDataType":"Numeric"}},"headerFormating":{"width":{"value":0,"unit":"pixels"},"height":{},"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":[]}},"otherProps":{}},"position":2,"field":{"fieldId":"47954424-fff3-4157-9296-ad08b751e71d","fieldName":"SupplierID","fieldNameAlias":"Count (SupplierID)","dataFieldType":"Numeric","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceType":"Table","sourceAlias":"Suppliers","relationshipId":null,"visible":true,"calculatedTree":null,"schemaName":"dbo","querySourceName":"Suppliers","databaseName":"Northwind","isCalculated":false},"isDeleted":false,"isSelected":false}],"name":"columns"},"rows":{"text":null,"properties":{},"settings":{},"elements":[],"name":"rows"},"values":{"text":null,"properties":{},"settings":{},"elements":[],"name":"values"},"separators":{"text":null,"properties":{},"settings":{},"elements":[],"name":"separators"},"properties":{"isDirty":true,"generalInfo":{"gridStyle":"Vertical","separatorStyle":"Comma"},"table":{"backgroundColor":"#efefef","border":{"top":{},"right":{},"bottom":{},"midVer":{},"left":{},"midHor":{}}},"columns":{"width":{"value":null,"unit":"Pixels"},"alterBackgroundColor":false},"rows":{"height":40,"alterBackgroundColor":false},"headers":{"font":{"family":"Roboto","size":14,"bold":true,"italic":false,"underline":false,"backgroundColor":"#dbf2ff"},"alignment":"left","wordWrap":true,"removeHeaderForExport":false},"grouping":{"useSeparator":false},"view":{"dataRefreshInterval":{"enable":false,"updateInterval":0,"isAll":true,"latestRecord":0}}},"settings":{},"dataSource":{},"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":[]}},"reportId":"00000000-0000-0000-0000-000000000000","positionX":0,"positionY":0,"width":12,"height":4,"state":3,"modified":null,"numberOfRecord":0,"isBackSide":true,"expandedLevel":0,"points":[{"key":"All","filter":[{"key":"","value":""}],"expandedLevel":0,"isViewSeparator":false}],"isSelected":true,"title":"Grid","id":"561dba1e-f799-42be-be9d-bbfa078aee43"}],"version":0},"title":"Grid","expression":"","reportField":{"fieldId":"76139896-c2c3-432e-898a-2c2205bb2e35","fieldName":"Country","fieldNameAlias":"Country","dataFieldType":"Text","querySourceId":"1641cb37-b60c-42bc-b986-c51667e8037d","querySourceType":"Table","sourceAlias":"Suppliers","relationshipId":null,"visible":true,"calculatedTree":null,"schemaName":"dbo","querySourceName":"Suppliers","databaseName":"Northwind","isCalculated":false}}Response:
{"value":10,"hasRecord":false,"dataType":"Numeric"}
GET fusion/{report_id}/{report_part_id}/(pageIndex)/(pageSize)
Loads report part data with paging and optional overridden filter values and operators.
Request
No payload
Optional overridden filter values and operators are passed as query string parameters:
- value:
&p{filter_number}Value={filter_value}- operator:
&p{filter_number}Operator={filter_operator_id}For example, to load data from a report part while overriding the second filter to
equal"t-shirt":GET /api/fusion/81a64b45-fc04-4026-8708-244f341b4284/6493401d-c0b6-4f4a-801d-51e4b0ac3bb1?p2Value=t-shirt&p2Operator=042A04A3-DFE1-4EF9-BD27-1B657886F02E(
042A04A3-DFE1-4EF9-BD27-1B657886F02Eis the id of Equals filter operator from GET report/filter/operators)
Response
A FusionResult object
Samples
POST/api/fusion/9197f210-766a-45d3-a1f9-5c4f4a4aa8ba/90ff323c-38f8-4663-823f-35afd85239eeHTTP/1.1Sample response:
{"grandTotalMapping":[],"subTotalMapping":[],"sideTotalMapping":[],"executionTrace":[],"records":[{"orderid_2be8c595_91a3_":10250,"shipcountry_bfeceef4_e536_":"Brazil","rowNumber":1},{"orderid_2be8c595_91a3_":10253,"shipcountry_bfeceef4_e536_":"Brazil","rowNumber":2},],"fieldsMapping":[{"fieldId":"2be8c595-91a3-4250-8828-dbbc07eaba83","fieldNameAlias":"OrderID","columnName":"orderid_2be8c595_91a3_"},{"fieldId":"bfeceef4-e536-4823-8cde-adb8f71d52f5","fieldNameAlias":"ShipCountry","columnName":"shipcountry_bfeceef4_e536_"}],"paging":{"pageIndex":1,"pageSize":100000,"total":2,"skipItems":0,"isLastPage":false},"pivotHeaderValues":[],"cities":[],"postalCodes":[]}
POST fusion/validateDataModelExpression
Validates a calculated field expression in Data Model and returns a suggested data type (in a single data source).
See also: POST fusion/validateExpression
Request
Field NULL Description Note querySourceId
string (GUID)The id of the query source expression
stringThe expression izendaDataType
stringThe output data type querySourceFieldId
string (GUID)The id of the query source field tenantId
string (GUID)The id of the tenant
Response
A ValidationOperationResult object
Samples
POST/api/fusion/validateDataModelExpressionHTTP/1.1Request payload:
{"querySourceId":"e1bc9a64-c12c-41fd-b8c9-5e7bccf754e9","expression":"RUNNINGSUM([FREIGHT])","izendaDataType":null,"querySourceFieldId":null,"tenantId":"b5b3a5cc-9e55-424c-ae85-ba92ec3b934e"}Sample response:
{"result":{"izendaDataType":"Numeric","isRunningField":false,"isCompositeField":false},"success":true,"messages":[],"data":null}
POST fusion/previewCalculatedField
Loads preview data for a calculated field.
Obsolete, use POST fusion/validateExpression instead
Request
Payload: a ReportExpressionParameter object
Response
A FusionPreviewResult object
Samples
POST/api/fusion/previewCalculatedFieldHTTP/1.1Request payload:
{"reportKey":{"key":"9197f210-766a-45d3-a1f9-5c4f4a4aa8ba"},"expression":"Sum([Northwind-BA].[dbo].[Orders].[Freight])","izendaDataType":"Money","querySourceFieldId":null,"previewRecord":10}Sample response:
{"value":25733.12,"hasRecord":true,"dataType":"Money"}
POST fusion/previewSubTotal
Loads preview data for sub total.
Request
Payload: a ReportPartValidateExpressionParameter object
Response
A FusionPreviewResult object
Samples
POST/api/fusion/previewSubTotalHTTP/1.1Request payload:{"reportKey":{"key":"2a1bf476-d6c7-4869-b625-30f5423948b7"},"report":{"name":"Total Testing Report","type":0,"previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"category":{"id":null,"name":"","type":0},"subCategory":{"id":null,"name":"","type":0},"reportDataSource":[{"aliasId":"72bf3820-3259-4b77-8f99-c2c001388413_Order Details","querySourceId":"72bf3820-3259-4b77-8f99-c2c001388413","querySourceName":"Order Details","selected":true,"categoryId":"00000000-0000-0000-0000-000000000000","primaryFields":[{"name":"OrderID","alias":"","dataType":"int","izendaDataType":"Numeric","allowDistinct":false,"visible":true,"filterable":true,"deleted":false,"querySourceId":"00000000-0000-0000-0000-000000000000","parentId":null,"expressionFields":[],"filteredValue":"","type":0,"groupPosition":0,"position":0,"extendedProperties":"{\"PrimaryKey\":true}","physicalChange":0,"approval":0,"existed":false,"matchedTenant":false,"functionName":null,"expression":null,"fullName":null,"calculatedTree":null,"reportId":null,"originalName":"OrderID","isParameter":false,"isCalculated":false,"hasAggregatedFunction":false,"querySource":null,"fullPath":null,"id":"507012a6-fb37-4035-b64b-7e5d82493889","state":0,"inserted":true,"version":null,"created":null,"createdBy":null,"modified":"0001-01-01T00:00:00.0000000-08:00","modifiedBy":null},{"name":"ProductID","alias":"","dataType":"int","izendaDataType":"Numeric","allowDistinct":false,"visible":true,"filterable":true,"deleted":false,"querySourceId":"00000000-0000-0000-0000-000000000000","parentId":null,"expressionFields":[],"filteredValue":"","type":0,"groupPosition":0,"position":0,"extendedProperties":"{\"PrimaryKey\":true}","physicalChange":0,"approval":0,"existed":false,"matchedTenant":false,"functionName":null,"expression":null,"fullName":null,"calculatedTree":null,"reportId":null,"originalName":"ProductID","isParameter":false,"isCalculated":false,"hasAggregatedFunction":false,"querySource":null,"fullPath":null,"id":"8cc4ea1e-fa55-4721-9963-c65602e5757a","state":0,"inserted":true,"version":null,"created":null,"createdBy":null,"modified":"0001-01-01T00:00:00.0000000-08:00","modifiedBy":null}]}],"reportRelationship":[],"reportFilter":{"logic":"","visible":true,"filterFields":[],"id":"ad432d5c-a450-4624-b741-69674f8652c1","reportId":"2a1bf476-d6c7-4869-b625-30f5423948b7"},"reportPart":[{"isDirty":false,"reportPartContent":{"isDirty":false,"type":3,"columns":{"text":null,"properties":{},"settings":{},"elements":[{"reportPartContent":null,"isDirty":false,"name":"ProductID","properties":{"isDirty":true,"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{},"format":{"formatId":"","groupBy":null},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"alignment":"alignLeft","sort":"","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":"Open link in New Window"},"embeddedJavascript":{"script":""},"subTotal":{"label":"T1","function":"Sum","expression":"","dataType":"Numeric","previewResult":"","fieldDataType":"Numeric"},"grandTotal":{"label":"T1","function":"Sum","expression":"","dataType":"Numeric","previewResult":"","fieldDataType":"Numeric"}},"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":[]}}},"position":1,"field":{"fieldId":"8cc4ea1e-fa55-4721-9963-c65602e5757a","fieldName":"ProductID","fieldNameAlias":"ProductID","dataFieldType":"Numeric","querySourceId":"72bf3820-3259-4b77-8f99-c2c001388413","querySourceType":"Table","sourceAlias":"Order Details","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false},"isDeleted":false,"isSelected":false},{"reportPartContent":null,"isDirty":false,"name":"UnitPrice","properties":{"isDirty":true,"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{},"format":{"formatId":"","groupBy":null},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"alignment":"alignLeft","sort":"","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":"Open link in New Window"},"embeddedJavascript":{"script":""},"subTotal":{"label":"","function":"","expression":"","dataType":"","previewResult":""},"grandTotal":{"label":"","function":"","expression":"","dataType":"","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":[]}}},"position":2,"field":{"fieldId":"9820a839-11a2-4b01-a5a9-a9028b34c319","fieldName":"UnitPrice","fieldNameAlias":"UnitPrice","dataFieldType":"Money","querySourceId":"72bf3820-3259-4b77-8f99-c2c001388413","querySourceType":"Table","sourceAlias":"Order Details","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false},"isDeleted":false,"isSelected":false}],"name":"columns"},"rows":{"text":null,"properties":{},"settings":{},"elements":[],"name":"rows"},"values":{"text":null,"properties":{},"settings":{},"elements":[],"name":"values"},"separators":{"text":null,"properties":{},"settings":{},"elements":[],"name":"separators"},"properties":{"isDirty":true,"generalInfo":{"gridStyle":"Vertical","separatorStyle":"Comma"},"table":{"border":{"top":{},"right":{},"bottom":{},"midVer":{},"left":{},"midHor":{}},"backgroundColor":"#efefef"},"columns":{"width":{"value":null,"unit":"Pixels"},"alterBackgroundColor":false},"rows":{"height":40,"alterBackgroundColor":false},"headers":{"font":{"family":"Roboto","size":14,"bold":true,"italic":false,"underline":false,"backgroundColor":"#dbf2ff"},"alignment":"left","wordWrap":false,"removeHeaderForExport":false},"grouping":{"useSeparator":true},"view":{"dataRefreshInterval":{"enable":false,"updateInterval":0,"isAll":true,"latestRecord":0},"usePagination":false},"printing":{"usePageBreakAfterSeparator":false}},"settings":{},"dataSource":{},"isActiveForEdit":false,"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":[]}},"reportId":"2a1bf476-d6c7-4869-b625-30f5423948b7","positionX":0,"positionY":0,"width":12,"height":4,"state":3,"modified":null,"numberOfRecord":0,"isBackSide":true,"points":[{"key":"All","filter":[{"key":"","value":""}],"expandedLevel":0,"isViewSeparator":false}],"configField":{"reportPartContent":null,"isDirty":false,"name":"ProductID","properties":{"isDirty":true,"fieldItemVisible":true,"dataFormattings":{"function":"","functionInfo":{},"format":{"formatId":"","groupBy":null},"font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"","backgroundColor":""},"alignment":"alignLeft","sort":"","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":"Open link in New Window"},"embeddedJavascript":{"script":""},"subTotal":{"label":"T1","function":"Sum","expression":"","dataType":"Numeric","previewResult":"","fieldDataType":"Numeric"},"grandTotal":{"label":"T1","function":"Sum","expression":"","dataType":"Numeric","previewResult":"","fieldDataType":"Numeric"}},"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":[]}}},"position":1,"field":{"fieldId":"8cc4ea1e-fa55-4721-9963-c65602e5757a","fieldName":"ProductID","fieldNameAlias":"ProductID","dataFieldType":"Numeric","querySourceId":"72bf3820-3259-4b77-8f99-c2c001388413","querySourceType":"Table","sourceAlias":"Order Details","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false},"isDeleted":false,"isSelected":false},"expandedLevel":0,"title":"Grid","id":"eca9c621-08da-4919-814f-2c6396ca7700"}],"header":{"visible":false,"items":[{"isDirty":false,"type":"image","label":"Image","id":"formatDetails_385","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},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_386","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},{"isDirty":false,"type":"thinHorizontalRule","label":"Horizontal Rule","id":"formatDetails_387","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},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_388","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},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_389","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},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_390","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},{"isDirty":false,"type":"dateTime","label":"Date Time","id":"formatDetails_391","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},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_392","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},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_393","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},{"isDirty":false,"type":"horizontalRule","label":"Horizontal Rule","id":"formatDetails_394","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}]},"footer":{"visible":false,"items":[{"isDirty":false,"type":"horizontalRule","label":"Horizontal Rule","id":"formatDetails_395","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},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_396","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},{"isDirty":false,"type":"text","label":"Text","id":"formatDetails_397","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},{"isDirty":false,"type":"pageNumber","label":"Page Number","id":"formatDetails_398","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}]},"titleDescription":{"visible":false,"items":[{"isDirty":false,"type":"title","label":"Title","id":"formatDetails_399","name":"Title","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1},{"isDirty":false,"type":"description","label":"Description","id":"formatDetails_400","name":"Description","value":"","font":{"family":"Roboto","size":14,"bold":false,"italic":false,"underline":false,"color":"#000","backgroundColor":"#fff"},"color":"#000","dashStyle":"solid","thickness":1}]},"version":1,"schedules":[]},"title":"Grid","expression":"","izendaDataType":"Numeric","reportField":{"fieldId":"8cc4ea1e-fa55-4721-9963-c65602e5757a","fieldName":"ProductID","fieldNameAlias":"ProductID","dataFieldType":"Numeric","querySourceId":"72bf3820-3259-4b77-8f99-c2c001388413","querySourceType":"Table","sourceAlias":"Order Details","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false}}Sample response:
{"value":426.0,"dataType":"Money","hasRecord":false}
POST fusion/calculatedFieldValue
Returns a single calculated field value for preview section.
Request
Field NULL Description Note querySourceId
string (GUID)The id of the query source expression
stringThe expression izendaDataType
stringThe output data type tenantId
string (GUID)Y The id of the tenant
Response
A FusionPreviewResult object
Samples
POST/api/fusion/calculatedFieldValueHTTP/1.1Request payload:
{"querySourceId":"72bf3820-3259-4b77-8f99-c2c001388413","expression":"[Discount] * [UnitPrice]","izendaDataType":"Numeric"}Response:
{"value":0.0,"hasRecord":true,"dataType":"Numeric"}
POST fusion/retrieveRandomExpandedLevelData
Returns random expanded level data.
Request
Payload: a ReportPartPreviewParameter object
Response
An object or an array of FusionResult objects
Samples
POST/api/fusion/retrieveRandomExpandedLevelDataHTTP/1.1Request payload:{"reportKey":{"key":"9197f210-766a-45d3-a1f9-5c4f4a4aa8ba","modified":null,"tenantId":null},"section":2,"saveAs":false,"ignoreCheckChange":false,"report":{"name":"091217-test","type":0,"previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"categoryId":"dc04087a-a761-43fb-b82d-5dd56fe8d9e3","category":{"id":"dc04087a-a761-43fb-b82d-5dd56fe8d9e3","name":"","type":0,"tenantId":null},"subCategory":{"id":null,"name":"","type":0,"tenantId":null},"subCategoryId":null,"reportDataSource":[{"reportId":"9197f210-766a-45d3-a1f9-5c4f4a4aa8ba","querySourceId":"205c0e5f-fff8-409b-a54a-b6687619486d","querySourceUniqueName":"[con;#0].[cat;#0].[Orders]","querySourceCategoryId":null,"connectionId":null,"selected":false,"id":"e8cd9782-98bc-4f6b-9251-e48c756c9937","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-09-12T06:30:52.84","createdBy":"System5 Admin5","modified":"2017-09-12T06:30:52.84","modifiedBy":"System5 Admin5"}],"reportRelationship":[],"reportFilter":{"logic":"","visible":false,"filterFields":[],"id":"e7845036-2d0c-4576-ab76-53b0e0e41ea3","reportId":"9197f210-766a-45d3-a1f9-5c4f4a4aa8ba"},"reportPart":[{"isDirty":true,"reportPartContent":{"subReportDefinitionCollection":[],"collapseStatus":0,"isDirty":true,"isCrossFiltering":false,"type":3,"columns":{"text":null,"properties":{},"settings":{},"elements":[{"reportPartContent":null,"isDirty":false,"name":"OrderID","properties":{"isDirty":false,"fieldItemVisible":true,"dataFormattings":{"function":"7f942ac7-08d8-41fa-9e89-bad96f07f102","functionInfo":{"dataType":"Numeric","expression":null,"expressionSyntax":null,"extendedProperties":{},"id":"7f942ac7-08d8-41fa-9e89-bad96f07f102","isOperator":false,"name":"Group","syntax":null,"userDefined":false,"formatDataType":"Numeric"},"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":{}},"position":1,"field":{"fieldId":"2be8c595-91a3-4250-8828-dbbc07eaba83","fieldName":"OrderID","fieldNameAlias":"OrderID","dataFieldType":"Numeric","querySourceId":"205c0e5f-fff8-409b-a54a-b6687619486d","querySourceType":"Table","sourceAlias":"Orders","relationshipId":"00000000-0000-0000-0000-000000000000","visible":true,"calculatedTree":null,"isCalculated":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false,"offset":{}}],"name":"columns"},"rows":{"text":null,"properties":{},"settings":{},"elements":[],"name":"rows"},"values":{"text":null,"properties":{},"settings":{},"elements":[],"name":"values"},"separators":{"text":null,"properties":{},"settings":{},"elements":[],"name":"separators"},"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":{},"changeGridStyleStatus":true,"inconsitentFunction":false,"dataSource":{},"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":[]}},"reportId":"9197f210-766a-45d3-a1f9-5c4f4a4aa8ba","width":5,"height":6,"state":3,"modified":null,"numberOfRecord":null,"configField":null,"stateReview":0,"refreshDataProcess":null,"refreshDataInterval":null,"positionY":0,"positionX":0,"title":"Grid","id":"90ff323c-38f8-4663-823f-35afd85239ee"}],"header":{"visible":false,"items":[{"isDirty":false,"type":"image","label":"Image","id":"formatDetails_154","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_155","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_156","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_157","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_158","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_159","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_160","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_161","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_162","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_163","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_164","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_165","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_166","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_167","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_168","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_169","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}]},"version":4,"schedules":[],"ownerId":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","accesses":[],"exportFormatSetting":{"orientation":0,"margins":0,"centerOnPage":{"horizontally":false,"vertically":false},"pageBreakAfterReportPart":false,"marginSettings":[{"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},{"type":3,"topValue":0.75,"bottomValue":0.75,"leftValue":0.7,"rightValue":0.7,"headerValue":0.3,"footerValue":0.3}]},"createdById":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","dynamicQuerySourceFields":[],"snapToGrid":false,"excludedRelationships":"","isGlobal":false},"expandedLevel":-1,"title":"Grid","paging":{"pageIndex":1,"pageSize":10},"sortOrders":[{"key":"OrderID","sortingType":"Unsort"}],"filters":[]}Response:
{"grandTotalMapping":[],"subTotalMapping":[],"sideTotalMapping":[],"executionTrace":[],"records":[{"orderid_2be8c595_91a3_":10250,"rowNumber":1},{"orderid_2be8c595_91a3_":10283,"rowNumber":10}],"fieldsMapping":[{"fieldId":"2be8c595-91a3-4250-8828-dbbc07eaba83","fieldNameAlias":"OrderID","columnName":"orderid_2be8c595_91a3_"}],"paging":{"pageIndex":1,"pageSize":10,"total":2,"skipItems":0,"isLastPage":false},"pivotHeaderValues":[],"cities":[],"postalCodes":[]}
POST fusion/printQuery
Returns the sql query for a data request.
Request
Payload: a FusionDataRequest object
Response
The query a text (.txt) file
Samples
POST/api/fusion/printQueryHTTP/1.1Request payload:
{"loadDraft":false,"reportId":"9197f210-766a-45d3-a1f9-5c4f4a4aa8ba","reportPartId":"90ff323c-38f8-4663-823f-35afd85239ee","tenantId":null,"userAction":null,"paging":{"pageIndex":1,"pageSize":10},"expandedLevel":-1,"sortOrders":[{"key":"OrderID","sortingType":"Unsort"},{"key":"Sum(Frieght)","sortingType":"Unsort"},{"key":"ShipCountry","sortingType":"ASC"}],"filters":[]}
POST fusion/printQuery/reportPartPreview
Returns the sql query for a report part preview request.
Request
Payload: a ReportPartPreviewParameter object
Response
The query a text (.txt) file
Samples
POST/api/fusion/printQuery/reportPartPreviewHTTP/1.1Request payload:{"reportKey":{"key":"9197f210-766a-45d3-a1f9-5c4f4a4aa8ba","modified":null,"tenantId":null},"section":2,"saveAs":false,"ignoreCheckChange":true,"report":{"name":"091217-test","type":0,"previewRecord":10,"advancedMode":true,"allowNulls":false,"isDistinct":false,"categoryId":"dc04087a-a761-43fb-b82d-5dd56fe8d9e3","category":{"id":"dc04087a-a761-43fb-b82d-5dd56fe8d9e3","name":"","type":0,"tenantId":null},"subCategory":{"id":null,"name":"","type":0,"tenantId":null},"subCategoryId":null,"reportDataSource":[{"reportId":"9197f210-766a-45d3-a1f9-5c4f4a4aa8ba","querySourceId":"205c0e5f-fff8-409b-a54a-b6687619486d","querySourceUniqueName":"[con;#0].[cat;#0].[Orders]","querySourceCategoryId":null,"connectionId":null,"selected":false,"id":"e8cd9782-98bc-4f6b-9251-e48c756c9937","state":0,"deleted":false,"inserted":true,"version":1,"created":"2017-09-12T06:30:52.84","createdBy":"System5 Admin5","modified":"2017-09-12T06:30:52.84","modifiedBy":"System5 Admin5"}],"reportRelationship":[],"reportFilter":null,"reportPart":[{"isDirty":true,"reportPartContent":{"subReportDefinitionCollection":[],"collapseStatus":0,"isDirty":false,"isCrossFiltering":false,"type":3,"columns":{"elements":[{"reportPartContent":null,"isDirty":false,"name":"OrderID","properties":{"isDirty":false,"fieldItemVisible":true,"dataFormattings":null,"headerFormating":null,"drillDown":{"subReport":{"selectedReport":null,"style":null,"reportPartUsed":null,"reportFilter":true,"mappingFields":[],"selectedIconValue":{"icon":null,"value":null},"viewSettingByLink":null}},"otherProps":{}},"position":1,"field":{"fieldId":"2be8c595-91a3-4250-8828-dbbc07eaba83","fieldName":"OrderID","fieldNameAlias":"OrderID","dataFieldType":"Numeric","querySourceId":"205c0e5f-fff8-409b-a54a-b6687619486d","querySourceType":"Table","sourceAlias":"Orders","relationshipId":null,"visible":true,"calculatedTree":null,"schemaName":"dbo","querySourceName":"Orders","databaseName":"Northwind-BA","isCalculated":false,"hasAggregatedFunction":false},"isDeleted":false,"isSelected":false,"offset":{}}],"name":"columns"},"rows":{"elements":[],"name":"rows"},"values":{"elements":[],"name":"values"},"separators":{"elements":[],"name":"separators"},"properties":{"isDirty":false,"generalInfo":{"gridStyle":"Vertical","separatorStyle":"Comma"},"table":null,"columns":{"width":{"value":150},"alterBackgroundColor":false},"rows":{"alterBackgroundColor":false},"headers":null,"grouping":{"useSeparator":true},"view":{"dataRefreshInterval":{"enable":false,"updateInterval":0,"isAll":true,"latestRecord":0},"usePagination":true,"collapseDrilldownByDefault":false,"pageSize":10,"pivotColumnsPerExportedPage":""},"printing":{"usePageBreakAfterSeparator":false}},"settings":{},"changeGridStyleStatus":true,"inconsitentFunction":false,"title":null,"description":null},"width":0,"height":0,"state":1,"modified":null,"configField":{},"stateReview":0,"positionY":0,"positionX":0,"title":"Grid"}],"header":null,"footer":null,"titleDescription":null,"version":5,"schedules":[],"ownerId":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","accesses":[],"exportFormatSetting":null,"createdById":"9d2f1d51-0e3d-44db-bfc7-da94a7581bfe","dynamicQuerySourceFields":[],"snapToGrid":false,"excludedRelationships":"","isGlobal":false},"expandedLevel":-1,"title":"Grid","paging":{"pageIndex":1,"pageSize":10},"sortOrders":[{"key":"OrderID","sortingType":"Unsort"}],"filters":[]}
GET fusion/printQuery/{reportId}/{reportPartId}/(pageIndex)/(pageSize)
Returns the sql query for a report part load with paging and optional overridden filter values and operators.
Request
No payload
Response
The query a text (.txt) file
Samples
GET/api/fusion/printQuery/9197f210-766a-45d3-a1f9-5c4f4a4aa8ba/79bf6715-4467-4f1b-8289-ad81c9defd6bHTTP/1.1