sfgboxapi

<back to all web services

ProductsMetricsAutoQueryLookup

Imports System
Imports System.Collections
Imports System.Collections.Generic
Imports System.Runtime.Serialization
Imports ServiceStack
Imports ServiceStack.DataAnnotations
Imports sfgboxapi.ServiceModel
Imports sfgboxapi.ServiceModel.Types

Namespace Global

    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 Tenants)
            Public Sub New()
                Results = New List(Of Tenants)
                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 Tenants)

            <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

    Namespace sfgboxapi.ServiceModel

        Public Partial Class ProductsMetricsAutoQueryLookup
            Inherits QueryDb(Of ProductsMetrics)
        End Class
    End Namespace

    Namespace sfgboxapi.ServiceModel.Types

        Public Partial Class ProductsMetrics
            <DataMember(Order:=1)>
            <Required>
            Public Overridable Property Id As Long

            <DataMember(Order:=2)>
            <Required>
            <References(GetType(Tenants))>
            Public Overridable Property TenantsId As Long

            <DataMember(Order:=3)>
            <Required>
            <References(GetType(Zones))>
            Public Overridable Property ZonesId As Long

            <DataMember(Order:=4)>
            <Required>
            <References(GetType(Products))>
            Public Overridable Property ProductsId As Long

            <DataMember(Order:=5)>
            <Required>
            Public Overridable Property PriceKg As Double

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

            <DataMember(Order:=8)>
            Public Overridable Property BetaineMg As Nullable(Of Double)

            <DataMember(Order:=10)>
            Public Overridable Property CalciumMg As Nullable(Of Double)

            <DataMember(Order:=18)>
            Public Overridable Property CholineMg As Nullable(Of Double)

            <DataMember(Order:=20)>
            Public Overridable Property CopperMg As Nullable(Of Double)

            <DataMember(Order:=25)>
            Public Overridable Property FiberG As Nullable(Of Double)

            <DataMember(Order:=27)>
            Public Overridable Property FluorideMg As Nullable(Of Double)

            <DataMember(Order:=29)>
            Public Overridable Property FolateMcg As Nullable(Of Double)

            <DataMember(Order:=31)>
            Public Overridable Property IronMg As Nullable(Of Double)

            <DataMember(Order:=34)>
            Public Overridable Property MagnesiumMg As Nullable(Of Double)

            <DataMember(Order:=36)>
            Public Overridable Property MangeneseMg As Nullable(Of Double)

            <DataMember(Order:=37)>
            Public Overridable Property MonoG As Nullable(Of Double)

            <DataMember(Order:=39)>
            Public Overridable Property NiacinMg As Nullable(Of Double)

            <DataMember(Order:=40)>
            Public Overridable Property Omega3Mg As Nullable(Of Double)

            <DataMember(Order:=41)>
            Public Overridable Property Omega6Mg As Nullable(Of Double)

            <DataMember(Order:=43)>
            Public Overridable Property PanthenicAcidMg As Nullable(Of Double)

            <DataMember(Order:=45)>
            Public Overridable Property PhosphorusMg As Nullable(Of Double)

            <DataMember(Order:=46)>
            Public Overridable Property PolyG As Nullable(Of Double)

            <DataMember(Order:=48)>
            Public Overridable Property PotassiumMg As Nullable(Of Double)

            <DataMember(Order:=50)>
            Public Overridable Property ProteinG As Nullable(Of Double)

            <DataMember(Order:=54)>
            Public Overridable Property RiboflavinMg As Nullable(Of Double)

            <DataMember(Order:=55)>
            Public Overridable Property SaturatedG As Nullable(Of Double)

            <DataMember(Order:=57)>
            Public Overridable Property SeleniumMcg As Nullable(Of Double)

            <DataMember(Order:=59)>
            Public Overridable Property SodiumMg As Nullable(Of Double)

            <DataMember(Order:=60)>
            Public Overridable Property StarchG As Nullable(Of Double)

            <DataMember(Order:=61)>
            Public Overridable Property SugarsG As Nullable(Of Double)

            <DataMember(Order:=63)>
            Public Overridable Property ThiaminMg As Nullable(Of Double)

            <DataMember(Order:=65)>
            Public Overridable Property VitaminAMcg As Nullable(Of Double)

            <DataMember(Order:=67)>
            Public Overridable Property VitaminB12Mcg As Nullable(Of Double)

            <DataMember(Order:=69)>
            Public Overridable Property VitaminB6Mg As Nullable(Of Double)

            <DataMember(Order:=71)>
            Public Overridable Property VitaminCMg As Nullable(Of Double)

            <DataMember(Order:=73)>
            Public Overridable Property VitaminDMg As Nullable(Of Double)

            <DataMember(Order:=75)>
            Public Overridable Property VitaminEMg As Nullable(Of Double)

            <DataMember(Order:=77)>
            Public Overridable Property VitaminKMcg As Nullable(Of Double)

            <DataMember(Order:=79)>
            Public Overridable Property ZincMg As Nullable(Of Double)

            <DataMember(Order:=80)>
            Public Overridable Property TransG As Nullable(Of Double)
        End Class

        Public Partial Class Tenants
            <DataMember(Order:=1)>
            <Required>
            Public Overridable Property Id As Long

            <DataMember(Order:=2)>
            <Required>
            <References(GetType(Zones))>
            Public Overridable Property MainZonesId As Long

            <DataMember(Order:=3)>
            Public Overridable Property IsPublic As Boolean
        End Class
    End Namespace
End Namespace

VB.NET ProductsMetricsAutoQueryLookup 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 /jsonl/reply/ProductsMetricsAutoQueryLookup HTTP/1.1 
Host: api-stage.smartfarmertech.com 
Accept: text/jsonl
Content-Type: text/jsonl
Content-Length: length

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

{"offset":0,"total":0,"results":[{"id":0,"tenantsId":0,"zonesId":0,"productsId":0,"priceKg":0,"priceDescription":"String","betaineMg":0,"calciumMg":0,"cholineMg":0,"copperMg":0,"fiberG":0,"fluorideMg":0,"folateMcg":0,"ironMg":0,"magnesiumMg":0,"mangeneseMg":0,"monoG":0,"niacinMg":0,"omega3Mg":0,"omega6Mg":0,"panthenicAcidMg":0,"phosphorusMg":0,"polyG":0,"potassiumMg":0,"proteinG":0,"riboflavinMg":0,"saturatedG":0,"seleniumMcg":0,"sodiumMg":0,"starchG":0,"sugarsG":0,"thiaminMg":0,"vitaminAMcg":0,"vitaminB12Mcg":0,"vitaminB6Mg":0,"vitaminCMg":0,"vitaminDMg":0,"vitaminEMg":0,"vitaminKMcg":0,"zincMg":0,"transG":0}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}