Northwind Web Services

<back to all web services

QueryOrders

AutoQuery
The following routes are available for this service:
All Verbs/query/orders
Imports System
Imports System.Collections
Imports System.Collections.Generic
Imports System.Runtime.Serialization
Imports ServiceStack
Imports ServiceStack.DataAnnotations
Imports Northwind.ServiceModel
Imports Northwind.ServiceModel.Types

Namespace Global

    Namespace Northwind.ServiceModel

        Public Partial Class QueryOrders
            Inherits QueryDb(Of Order)
            Public Overridable Property Freight As Nullable(Of Decimal)
        End Class
    End Namespace

    Namespace Northwind.ServiceModel.Types

        <DataContract>
        Public Partial Class Customer
            <DataMember>
            Public Overridable Property Id As String

            <DataMember>
            Public Overridable Property CompanyName As String

            <DataMember>
            Public Overridable Property ContactName As String

            <DataMember>
            Public Overridable Property ContactTitle As String

            <DataMember>
            Public Overridable Property Address As String

            <DataMember>
            Public Overridable Property City As String

            <DataMember>
            Public Overridable Property Region As String

            <DataMember>
            Public Overridable Property PostalCode As String

            <DataMember>
            Public Overridable Property Country As String

            <DataMember>
            Public Overridable Property Phone As String

            <DataMember>
            Public Overridable Property Fax As String
        End Class

        <DataContract>
        Public Partial Class Order
            <DataMember>
            Public Overridable Property Id As Integer

            <DataMember>
            Public Overridable Property CustomerId As String

            <DataMember>
            Public Overridable Property EmployeeId As Integer

            <DataMember>
            Public Overridable Property OrderDate As Nullable(Of Date)

            <DataMember>
            Public Overridable Property RequiredDate As Nullable(Of Date)

            <DataMember>
            Public Overridable Property ShippedDate As Nullable(Of Date)

            <DataMember>
            Public Overridable Property ShipVia As Nullable(Of Integer)

            <DataMember>
            Public Overridable Property Freight As Decimal

            <DataMember>
            Public Overridable Property ShipName As String

            <DataMember>
            Public Overridable Property ShipAddress As String

            <DataMember>
            Public Overridable Property ShipCity As String

            <DataMember>
            Public Overridable Property ShipRegion As String

            <DataMember>
            Public Overridable Property ShipPostalCode As String

            <DataMember>
            Public Overridable Property ShipCountry As String
        End Class
    End Namespace

    Namespace ServiceStack

        <DataContract>
        Public Partial Class QueryBase
            Public Sub New()
                Meta = New Dictionary(Of String, String)
            End Sub

            <DataMember(Order:=1)>
            Public Overridable Property Skip As Nullable(Of Integer)

            <DataMember(Order:=2)>
            Public Overridable Property Take As Nullable(Of Integer)

            <DataMember(Order:=3)>
            Public Overridable Property OrderBy As String

            <DataMember(Order:=4)>
            Public Overridable Property OrderByDesc As String

            <DataMember(Order:=5)>
            Public Overridable Property Include As String

            <DataMember(Order:=6)>
            Public Overridable Property Fields As String

            <DataMember(Order:=7)>
            Public Overridable Property Meta As Dictionary(Of String, String)
        End Class

        Public Partial Class QueryDb(Of T)
            Inherits QueryBase
        End Class

        <DataContract>
        Public Partial Class QueryResponse(Of Customer)
            Public Sub New()
                Results = New List(Of Customer)
                Meta = New Dictionary(Of String, String)
            End Sub

            <DataMember(Order:=1)>
            Public Overridable Property Offset As Integer

            <DataMember(Order:=2)>
            Public Overridable Property Total As Integer

            <DataMember(Order:=3)>
            Public Overridable Property Results As List(Of Customer)

            <DataMember(Order:=4)>
            Public Overridable Property Meta As Dictionary(Of String, String)

            <DataMember(Order:=5)>
            Public Overridable Property ResponseStatus As ResponseStatus
        End Class
    End Namespace
End Namespace

VB.NET QueryOrders DTOs

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

HTTP + JSV

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

POST /query/orders HTTP/1.1 
Host: northwind.netcore.io 
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length

{
	freight: 0,
	skip: 0,
	take: 0,
	orderBy: String,
	orderByDesc: String,
	include: String,
	fields: String,
	meta: 
	{
		String: String
	}
}
HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

{
	offset: 0,
	total: 0,
	results: 
	[
		{
			id: 0,
			customerId: String,
			employeeId: 0,
			orderDate: 0001-01-01,
			requiredDate: 0001-01-01,
			shippedDate: 0001-01-01,
			shipVia: 0,
			freight: 0,
			shipName: String,
			shipAddress: String,
			shipCity: String,
			shipRegion: String,
			shipPostalCode: String,
			shipCountry: String
		}
	],
	meta: 
	{
		String: String
	},
	responseStatus: 
	{
		errorCode: String,
		message: String,
		stackTrace: String,
		errors: 
		[
			{
				errorCode: String,
				fieldName: String,
				message: String,
				meta: 
				{
					String: String
				}
			}
		],
		meta: 
		{
			String: String
		}
	}
}