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
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 .xml suffix or ?format=xml

HTTP + XML

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: application/xml
Content-Type: application/xml
Content-Length: length

<ReadAndImportDataApi xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/tvpl.api.ServiceModel">
  <DataFile i:nil="true" />
  <IsInternal>false</IsInternal>
</ReadAndImportDataApi>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<ReadExcelResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/tvpl.api.ServiceModel">
  <MaxColumnR>0</MaxColumnR>
  <Rows xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:ArrayOfstring>
      <d2p1:string>String</d2p1:string>
    </d2p1:ArrayOfstring>
  </Rows>
</ReadExcelResponse>