Generate Excel files, BarCodes, Reports, export HTML5 data management or visualization controls to the format of your choice.
With these powerful Web APIs, you can generate excel files from different data sources, manipulate and merge excel files,
create barcodes on the fly, analyze huge datasets and SSAS Cubes, render reports and PDF.
The possibilities are limited only by the developer’s imagination.

Action StringThe action string. This is only for SSRS report and suggest to use report AdventureWorks (SSRS)/Product Line Sales as example. e.g:actionString=77u%2FPD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0idXRmLTgiPz48TFQgcmVmPSIxIiB0eXBlPSJMVCI%2BPERBIHR5cGU9IlNTUlNTQSI%2BPFNJRD4zM2lUMDwvU0lEPjxEPkFzY2VuZGluZzwvRD48L0RBPjwvTFQ%2B

Description

Parameters

Bacis Settings

CodeTypeThe type of encoding to use when generating the barcode image.

BackColorGets or sets the background color for the barcode image.

ForeColorGets or sets the foreground color for the barcode image.

CaptionPositionBarcode caption position relative to the barcode symbol

CaptionAlignmentBarcode caption alignment relative to the barcode

CheckSumEnabledGets or sets a value indicating whether a checksum of the barcode will be computed and included in the barcode when applicable.

QRCode Settings

ModelGets or sets the QRCode model.

ErrorLevelGets or sets the error correction level for the barcode.

VersionGets or sets the QRCode version. Specify any value between 1 and 14 when the Model property is set to Model1 and 1 to 40 for Model2. When -1 is specified, the version
most suited to the value is automatically determined

MaskGets or sets the pattern used for the barcode masking.

ConnectionNumberGets or sets the connection number for the barcode.

Connection
Gets or sets whether connection is used for the barcode.

PDF417 Settings

ColumnGets or sets columns number for the barcode.

RowGets or sets row numbers for the barcode.

ErrorLevelGets or sets the error correction level for the barcode.

TypeGets or set the PDF417 barcode's type.

Code49 Settings

GroupGets or sets groups number.

Grouping
Gets or sets a value indicating whether grouping is set for the barcode.

RssExpandedStacked Settings

RowCountGets or sets the number of stacked rows.

MicroPDF417 Settings

CompactionModeGets or sets the CompactionMode.

FileIDGets or sets the file id of structured append symbol.

SegmentCountGets or sets the segment count of structured append symbol.

SegmentIndexGets or sets the segment index of structured append symbol.

VersionGets or sets the symbol version.

Code25intlv Settings

LineStrokeWhether or not to display bearer bar to ITF barcode.

BearBar
The color of bearer bar.

LineStrokeThicknessThe line width of bearer bar.

GS1Composite Settings

TypeGets or sets the composite symbol type.

ValueGets or sets the CCA or CCB character data.

Ean128Fnc1 Settings

BarAdjustGets or sets the adjustment size by dot.

DpiGets or sets the resolution of the printer.

ModuleSizeGets or sets the horizontal size of the barcode module.

EccModeGets or sets the ECC mode.

Ecc200SymbolSizeGets or sets the size of the ECC200 symbol.

Ecc200EncodingModeGets or sets the ECC200 encoding mode.

Ecc000_140SymbolSizeGets or sets the size of the ECC000-140 symbol.

StructureNumberGets or sets the structure number of current symbol within the structuerd append symbols.

StructuredAppend
Gets or sets a value indicating whether the current symbol is part of structured append symbols.

FileIdentifierGets or sets the file identifier of a related group of structured append symbols.

Request Url

Barcode

Your browser does not support TIFF images, you can click here to download it.

Description

Parameters

SkipA positive integer value to specify the start index of the whole raw data. If not set, then returns the entries from the first one.

TopA positive integer value to specify the count of the returned raw data. If not set, then returns all entries starting with the skip value.

Headers

Response Data

Response Schema

Response Messages

HTTP Status CodeReason

200An IRawData object is returned to specify the aggregated result information. It includes two items: an array for the aggregated data and a number value for the total count of all the raw data without paging.

404{datasource} is invalid.

POST

/api/dataengine/{datasource}

Description

Get a list of objects in the raw data source that define the content of a specific cell in the output table. It is not supported when connecting cube data.

Parameters

ParameterValueDescription

Data SourceThe data source to analyze.

SkipA positive integer value to specify the start index of the whole detail entries. If not set, then returns the entries from the first one.

TopA positive integer value to specify the count of the returned detail entries. If not set, then returns all entries starting with the skip value.

Key
Specify the cell via the corresponding value. It is an array object. Firstly, you need add the values of the fields in rowFields in order into keys. Then add the values of the fields in columnFields in order. If some field value is null, JUST add null into array and DO NOT remove it. You should keep the count of the keys array same as the count of the fields in rowFields and columnFields.
For example:
["Aoba", "China"]

Headers

Response Data

Response Schema

Response Messages

HTTP Status CodeReason

200An IRawData object is returned to specify the detail result information. It includes two parts: an array for the raw data of the cell and the total count of the raw data without paging.

404{datasource} is invalid.

POST

/api/dataengine/{datasource}/fields/{fieldname}/uniquevalues

Description

Get the unique values of a field. It is not supported when connecting cube data.

Headers

Response Data

Response Schema

Response Messages

HTTP Status CodeReason

201An IAnalysis object is returned to specify the analysis result information. It includes the status and the result data. If executingStatus in the status is “Completed”, the result data is an array which stands for the aggregated result data. Otherwise, the result data is always null.\r\nLocation in response header shows the url to access the analysis instance.

404{datasource} is invalid.

GET

/api/dataengine/{datasource}/analyses/{token}/status

Description

Get the status of the analysis.

Parameters

ParameterValueDescription

Data SourceThe data source to analyze.

TokenThe token of analysis instance.

Headers

Response Data

Response Schema

Response Messages

HTTP Status CodeReason

200An IStatus object is returned to specify the status. If the status is still “Executing”, you can send this request repeatedly until the status is changed to other values: Completed, Cleared or Exception. When it is “Completed”, it means the query has been executed successfully and the data is prepared. You can get the data by the 7th service: Get: /host/{datasourcekey}/analyses/{token}/result. If the status is “Exception”, it means some error occurs during the executing. For example, the token provided in this request doesn’t exist, an exception would be returned as response.

404{datasource} or {token} is invalid.

GET

/api/dataengine/{datasource}/analyses/{token}/result

Description

Get the analysis result data.

Parameters

ParameterValueDescription

Data SourceThe data source to analyze.

TokenThe token of analysis instance

Headers

Response Data

Response Schema

Response Messages

HTTP Status CodeReason

200An array object is returned to specify the result data. After calling this service to obtain the data prepared, the token will be removed. You cannot use it in other requests then. Otherwise, an exception would be returned.

404{datasource} or {token} is invalid.

GET

/api/dataengine/{datasource}/analyses/{token}

Description

Get the analysis information.

Parameters

ParameterValueDescription

Data SourceThe data source to analyze.

TokenThe token of analysis instance

Headers

Response Data

Response Schema

Response Messages

HTTP Status CodeReason

200An IAnalysis object is returned to specify the analysis result information.