Home

APIs that give you full control.

Generate Excel files from JSON\XML\Collections, create BarCodes, export HTML5 data management controls to the format of your choice, perform CRUD operation on cloud storage. With these powerful Web APIs, you can generate excel files from different data sources, split, manipulate and merge excel files, create barcodes on the fly, analyse huge datasets, store, retrieve, delete files on the cloud. The possibilities are limited only by the developer’s imagination.

Excel

Import/Export Services

MVC Controls

Wijmo5 Controls

Generate Excel

GET

/api/excel

Generate from dataset\collection

Description

Generate excel file from dataset\collection configured on server.

Parameters

Parameter Value Description

FileName The exported file name.

TemplateFileName The Template file name (if not provide, use generated template automatically).

Type The file format of the excel

DataName The data name that data provider recognizes.

Request Url

Show Json Data by FlexGrid

Show XML Data

Response Schema

GET

/api/excel

Generate from XML

Description

Generate excel file from XML file available in storage.

Parameters

Parameter Value Description

FileName The exported file name.

TemplateFileName The Template file name (if not provide, use generated template automatically).

Type The file format of the excel

DataFileName The xml data file name that storage manager can recognize. The content of the xml data file is collection-like, a root element with multiple same elements as its children:

<orders>
    <order id="1">
        <price>1000</price>
    </order>
    ......
 </orders>

Request Url

Show Json Data by FlexGrid

Show XML Data

Response Schema

GET

/api/excel

Convert between different formats

Description

Convert excel file available in storage into different format.

Parameters

Parameter Value Description

FileName The exported file name.

Type The file format of the excel

WorkBookFileName The excel file name that storage manager can recognize.

Request Url

Show Json Data by FlexGrid

Show XML Data

Response Schema

POST

/api/excel

Generate from XML

Description

Generate excel file from XML file posted from client.

Parameters

Parameter Value Description

FileName The exported file name.

TemplateFile The Template file (if not provide, use generated template automatically).

Type The file format of the excel.

DataFile The xml data file which is posted from client side.The content of the xml data file is collection-like, a root element with multiple same elements as its children:

<orders>
    <order id="1">
        <price>1000</price>
    </order>
    ......
 </orders>

Request Url

Show Json Data by FlexGrid

Show XML Data

Response Schema

POST

/api/excel

Generate from JSON

Description

Generate excel file from JSON data posted from client.

Parameters

Parameter Value Description

FileName The exported file name.

TemplateFileName The Template file name (if not provide, use generated template automatically).

Type The file format of the excel.

Data A data collection which is posted from client side.

Request Url

Show Json Data by FlexGrid

Show XML Data

Response Schema

POST

/api/excel

Convert between different formats

Description

Convert excel file into different format.

Parameters

Parameter Value Description

FileName The exported file name.

Type The file format of the excel.

WorkbookFile The excel file which is posted from client side. The file can be: xls, xlsx, csv.

Request Url

Show Json Data by FlexGrid

Show XML Data

Response Schema

Merge Excel Files

GET

/api/excel/merge

Description

Merge multiple excel files available in file storage.

Parameters

Parameter Value Description

FileName The exported file name.

Type The file format of the excel.

FileNamesToMerge
The excel file names that storage manager can recognize.

Request Url

Show Json Data by FlexGrid

Show XML Data

Response Schema

POST

/api/excel/merge

Description

Merge multiple files posted from client.

Parameters

Parameter Value Description

FileName The exported file name.

Type The file format of the excel.

FilesToMerge The excel file names that storage manager can recognize.

Request Url

Show Json Data by FlexGrid

Show XML Data

Response Schema

Split Excel File

GET

/api/excel/{excel path}/split

Description

Split an excel file from storage to multiple excel files and save it into storage.

Parameters

Parameter Value Description

Excel Path The excel file name that storage manager can recognize.

Output Path The output path in storage(if not provide, the default output path same as source).

Output Names The output file names (if not provide, the output file names will be generated automatically).

Request Url

Response Data

View Files:

Response Schema

Find/Replace

GET

/api/excel/{excel path}/{sheet name}/find

Description

Find text in excel, return all matches info.

Parameters

Parameter Value Description

Excel Path The excel file name that storage manager can recognize.

Sheet Name The sheet name (if not provide, find in all sheets).

Text The value which is used to search.

Match Case A boolean value indicates whether to search the value with case sensitive.

Whole Cell A boolean value indicates whether to search the value with matching the whole cell.

Request Url

Response Data

Response Schema

GET

/api/excel/{excel path}/{sheet name}/replace

Description

Replace text in excel.

Parameters

Parameter Value Description

Excel Path The excel file name that storage manager can recognize.

Sheet Name The sheet name (if not provide, replace in all sheets).

Text The text which is replaced.

New Text The new text to replace.

Match Case A boolean value indicates whether to search the value with case sensitive.

Whole Cell A boolean value indicates whether to search the value with matching a whole word.

Request Url

Response Data

View Files:

Response Schema

Rows

POST

/api/excel/{excel path}/{sheet name}/rows/{row index}

Description

Add rows.

Parameters

Parameter Value Description

Excel Path The excel file name that storage manager can recognize.

Sheet Name The sheet name.

Row Index The row index.

Count The count of rows.

Request Url

Response Data

View Files:

Response Schema

PUT

/api/excel/{excel path}/{sheet name}/rows/{row indexes}

Description

Update rows, you can use this API to hide/unhide group/ungroup rows.

Parameters

Parameter Value Description

Excel Path The excel file name that storage manager can recognize.

Sheet Name The sheet name.

Row Indexes the row indexes. format: {num}; {num},{num},...; {num}-{num}. for example: 1,3-5

Property Name The property name of row, available properties are "Visible(bool)" and "OutlineLevel(int)"

Property Value The property value of row.

Request Url

Response Data

View Files:

Response Schema

DELETE

/api/excel/{excel path}/{sheet name}/rows/{row indexes}

Description

Delete rows.

Parameters

Parameter Value Description

Excel Path The excel file name that storage manager can recognize.

Sheet Name The sheet name.

Row Indexes the row indexes. format: {num}; {num},{num},...; {num}-{num}. for example: 1,3-5

Request Url

Response Data

View Files:

Response Schema

Columns

POST

/api/excel/{excel path}/{sheet name}/columns/{column index}

Description

Add columns.

Parameters

Parameter Value Description

Excel Path The excel file name that storage manager can recognize.

Sheet Name The sheet name.

Column Index The column index.

Count The count of columns.

Request Url

Response Data

View Files:

Response Schema

PUT

/api/excel/{excel path}/{sheet name}/columns/{column indexes}

Description

Update columns, you can use this API to hide/unhide group/ungroup columns.

Parameters

Parameter Value Description

Excel Path The excel file name that storage manager can recognize.

Sheet Name The sheet name.

Column Indexes The column indexes. format: {num}; {num},{num},...; {num}-{num}. for example: 1,3-5

Property Name The property name of column, available properties are "Visible(bool)" and "OutlineLevel(int)"

Property Value The property value of column.

Request Url

Response Data

View Files:

Response Schema

DELETE

/api/excel/{excel path}/{sheet name}/columns/{column indexes}

Description

Delete columns.

Parameters

Parameter Value Description

Excel Path The excel file name that storage manager can recognize.

Sheet Name The sheet name.

Column Indexes The column indexes. format: {num}; {num},{num},...; {num}-{num}. for example: 1,3-5

Request Url

Response Data

View Files:

Response Schema

Storage

File Management

POST

/api/storage/{path}

Description

Upload a file to storage.

Parameters

Parameter Value Description

path

The file path in storage. DropBox : DropBox/C1WebApi/test.xlsx
step 1: login to your DropBox acount.
step 2: create an App and generate Access Token for this app.
step 3: use Access Token created at step 2 to put into DropBoxStorageAccessTocken
key value in the Web.config.
step 4: open WebApiExplorer project and navigate to Storage api section.
step 5: change "C1WebApi" to your apps name.
step 6: change "test.xlsx" to your file name you want to post.
NOTE: if using List Api, need change "test1" to your sub folder path.
For more information, please refer sample ~\WebApi\Samples\CS

file The upload file. (for demo, please choose a .xlsx file)

Request Url

Response Data

View Files:

Response Schema

DELETE

/api/storage/{path}

Description

Delete a file from storage.

Parameters

Parameter Value Description

path

Request Url

Response Data

Response Schema

GET

/api/storage/List/{path}

Description

List all files, folders from target folder.

Parameters

Parameter Value Description

path

DropBox : DropBox/C1WebApi/test.xlsx
step 1: login to your DropBox acount.
step 2: create an App and generate Access Token for this app.
step 3: use Access Token created at step 2 to put into DropBoxStorageAccessTocken
key value in the Web.config.
step 4: open WebApiExplorer project and navigate to Storage api section.
step 5: change "C1WebApi" to your apps name.
step 6: change "test.xlsx" to your file name you want to post.
NOTE: if using List Api, need change "test1" to your sub folder path.
For more information, please refer sample ~\WebApi\Samples\CS

Request Url

Response Data

Response Schema

Barcode

Generate Barcode

GET

/api/barcode

Description

API to generate barcode

Parameters

Bacis Settings

Parameter Value Description

Type The file type of the barcode image.

Text The value that is encoded as a barcode image.

CodeType The type of encoding to use when generating the barcode image.

BackColor Gets or sets the background color for the barcode image.

ForeColor Gets or sets the foreground color for the barcode image.

CaptionPosition Barcode caption position relative to the barcode symbol.

CaptionAlignment Barcode caption alignment relative to the barcode.

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

QRCode Settings

Model Gets or sets the QRCode model.

ErrorLevel Gets or sets the error correction level for the barcode.

Version Gets 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.

Mask Gets or sets the pattern used for the barcode masking.

ConnectionNumber Gets or sets the connection number for the barcode.

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

PDF417 Settings

Column Gets or sets columns number for the barcode.

Row Gets or sets row numbers for the barcode.

ErrorLevel Gets or sets the error correction level for the barcode.

Type Gets or set the PDF417 barcode's type.

Code49 Settings

Group Gets or sets groups number.

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

RssExpandedStacked Settings

RowCount Gets or sets the number of stacked rows.

MicroPDF417 Settings

CompactionMode Gets or sets the CompactionMode.

FileID Gets or sets the file id of structured append symbol.

SegmentCount Gets or sets the segment count of structured append symbol.

SegmentIndex Gets or sets the segment index of structured append symbol.

Version Gets or sets the symbol version.

Code25intlv Settings

LineStroke The color of bearer bar.

BearBar Whether or not to display bearer bar to ITF barcode.

LineStrokeThickness The line width of bearer bar.

GS1Composite Settings

Type Gets or sets the composite symbol type.

Value Gets or sets the CCA or CCB character data.

Ean128Fnc1 Settings

BarAdjust Gets or sets the adjustment size by dot.

Dpi Gets or sets the resolution of the printer.

ModuleSize Gets or sets the horizontal size of the barcode module.

DataMatrix Settings

EccMode Gets or sets the ECC mode.

Ecc200SymbolSize Gets or sets the size of the ECC200 symbol.

Ecc200EncodingMode Gets or sets the ECC200 encoding mode.

Ecc000_140SymbolSize Gets or sets the size of the ECC000-140 symbol.

StructureNumber Gets 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.

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

Request Url

Barcode

DataEngine

Samples for Services

MVC Controls

Wijmo5 Controls

Services

GET

/api/dataengine/{datasource}/fields

Description

Gets all the fields in the data.

Parameters

Parameter Value Description

Data Source The data source to get the fields information.

Headers

Response Data

Response Schema

Response Messages

HTTP Status Code Reason

200 A field array is returned.

404 {datasource} is invalid.

GET

/api/dataengine/{datasource}?[skip=n&top=m]

Description

Get the raw data. It is not supported when connecting cube data.

Parameters

Parameter Value Description

Data Source The data source to analyze.

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

Top A 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 Code Reason

200 An 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

Parameter Value Description

Data Source The data source to analyze.

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

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

View Definition The view definition to analyze. For example:
{
fields:[
   {"binding":"Active","dataType":3},
   {"binding":"Country","dataType":1},
   {"binding":"Date","dataType":4},
   {"binding":"Discount","dataType":2},
   {"binding":"Downloads","dataType":2},
   {"binding":"ID","dataType":2},
   {"binding":"Product","dataType":1},
   {"binding":"Sales","dataType":2}
],
rowFields:{items:["Product"]},
columnFields:{items:["Country"]},
valueFields:{items:["Sales"]}
}

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 Code Reason

200 An 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.

Parameters

Parameter Value Description

Data Source The data source to analyze.

Field The field to get the unique values for.
For example:
Product

Headers

Response Data

Response Schema

Response Messages

HTTP Status Code Reason

200 An array is returned to specify the unique values of a field.

404 {datasource} or {fieldname} is invalid.

POST

/api/dataengine/{datasource}/analyses

Description

Analyze the data from the specified data source.

Parameters

Parameter Value Description

Data Source The data source to analyze.

Headers

Response Data

Response Schema

Response Messages

HTTP Status Code Reason

201 An 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

Parameter Value Description

Data Source The data source to analyze.

Token The token of analysis instance.

Headers

Response Data

Response Schema

Response Messages

HTTP Status Code Reason

200 An 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

Parameter Value Description

Data Source The data source to analyze.

Token The token of analysis instance.

Headers

Response Data

Response Schema

Response Messages

HTTP Status Code Reason

200 An 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

Parameter Value Description

Data Source The data source to analyze.

Token The token of analysis instance.

Headers

Response Data

Response Schema

Response Messages

HTTP Status Code Reason

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

404 {datasource} or {token} is invalid.

DELETE

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

Description

Clear the analysis.

Parameters

Parameter Value Description

Data Source The data source to analyze.

Token The token of analysis instance.

Headers

Response Data

Response Schema

Response Messages

HTTP Status Code Reason

204 No content for response.

404 {datasource} or {token} is invalid.

Visitor

Samples for Visitor API

Visitor API