tvpl.api

ReadAndImportDataApi

**Requires Authentication**
Required role:	super-admin

The following routes are available for this service:
POST	/import-from-excel

Imports System
Imports System.Collections
Imports System.Collections.Generic
Imports System.Runtime.Serialization
Imports ServiceStack
Imports ServiceStack.DataAnnotations
Imports tvpl.api.ServiceModel
Imports ServiceStack.Web

Namespace Global

    Namespace ServiceStack.Web

        Public Interface IHttpFile
            Property Name As String
            Property FileName As String
            Property ContentLength As Long
            Property ContentType As String
            Property InputStream As Stream
        End Interface
    End Namespace

    Namespace tvpl.api.ServiceModel

        Public Partial Class ReadAndImportDataApi
            Public Overridable Property DataFile As IHttpFile
            Public Overridable Property IsInternal As Boolean
        End Class

        Public Partial Class ReadExcelResponse
            Public Sub New()
                Rows = New List(Of List(Of String))
            End Sub

            Public Overridable Property Rows As List(Of List(Of String))
            Public Overridable Property MaxColumnR As Decimal
        End Class
    End Namespace
End Namespace

VB.NET ReadAndImportDataApi DTOs

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

HTTP + OTHER

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/jsonl
Content-Type: text/jsonl
Content-Length: length

{"dataFile":null,"isInternal":false}

HTTP/1.1 200 OK
Content-Type: text/jsonl
Content-Length: length

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