tvpl.api

<back to all web services

ReadAndImportDataApi

Requires Authentication
Required role:super-admin
The following routes are available for this service:
POST/import-from-excel

export class ReadExcelResponse
{
    public rows: string[][];
    public maxColumnR: number;

    public constructor(init?: Partial<ReadExcelResponse>) { (Object as any).assign(this, init); }
}

export interface IHttpFile
{
    name: string;
    fileName: string;
    contentLength: number;
    contentType: string;
    inputStream: string;
}

export class ReadAndImportDataApi
{
    public dataFile: IHttpFile;
    public isInternal: boolean;

    public constructor(init?: Partial<ReadAndImportDataApi>) { (Object as any).assign(this, init); }
}

TypeScript ReadAndImportDataApi DTOs

To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv

HTTP + CSV

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /import-from-excel HTTP/1.1 
Host: etc-api.vsmlab.vn 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"dataFile":null,"isInternal":false}
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"rows":[["String"]],"maxColumnR":0}