#Script Pages

<back to all web services

QueryCustomers

import java.math.*
import java.util.*
import java.io.InputStream
import net.servicestack.client.*
import com.google.gson.annotations.*
import com.google.gson.reflect.*


open class QueryCustomers : QueryDb<Customer>()
{
    open var customerId:String? = null
    open var companyNameContains:String? = null
    open var countryIn:ArrayList<String>? = null
}

open class QueryDb<T> : QueryBase()
{
}

@DataContract
open class QueryBase
{
    @DataMember(Order=1)
    open var skip:Int? = null

    @DataMember(Order=2)
    open var take:Int? = null

    @DataMember(Order=3)
    open var orderBy:String? = null

    @DataMember(Order=4)
    open var orderByDesc:String? = null

    @DataMember(Order=5)
    open var include:String? = null

    @DataMember(Order=6)
    open var fields:String? = null

    @DataMember(Order=7)
    open var meta:HashMap<String,String>? = null
}

open class Customer
{
    open var customerId:String? = null
    open var companyName:String? = null
    open var address:String? = null
    open var city:String? = null
    open var region:String? = null
    open var postalCode:String? = null
    open var country:String? = null
    open var phone:String? = null
    open var fax:String? = null
    open var orders:ArrayList<Order> = ArrayList<Order>()
}

open class Order
{
    open var orderId:Int? = null
    open var customerId:String? = null
    open var orderDate:Date? = null
    open var total:Double? = null
}

@DataContract
open class QueryResponse<T>
{
    @DataMember(Order=1)
    open var offset:Int? = null

    @DataMember(Order=2)
    open var total:Int? = null

    @DataMember(Order=3)
    open var results:ArrayList<GithubRepo>? = null

    @DataMember(Order=4)
    open var meta:HashMap<String,String>? = null

    @DataMember(Order=5)
    open var responseStatus:ResponseStatus? = null
}

open class GithubRepo
{
    open var id:Int? = null
    open var name:String? = null
    open var description:String? = null
    open var homepage:String? = null
    open var language:String? = null
    open var watchers_Count:Int? = null
    open var stargazes_Count:Int? = null
    open var forks_Count:Int? = null
    open var open_Issues_Count:Int? = null
    open var size:Int? = null
    open var full_Name:String? = null
    open var created_at:Date? = null
    open var pushed_At:Date? = null
    open var updated_At:Date? = null
    open var has_issues:Boolean? = null
    open var has_Downloads:Boolean? = null
    open var has_Wiki:Boolean? = null
    open var has_Pages:Boolean? = null
    open var fork:Boolean? = null
    open var owner:GithubUser? = null
    open var svn_Url:String? = null
    open var mirror_Url:String? = null
    open var url:String? = null
    open var ssh_Url:String? = null
    open var html_Url:String? = null
    open var clone_Url:String? = null
    open var git_Url:String? = null
    @SerializedName("private") open var Private:Boolean? = null
}

open class GithubUser
{
    open var id:Int? = null
    open var login:String? = null
    open var avatar_Url:String? = null
    open var url:String? = null
    open var followers:Int? = null
    open var following:Int? = null
    @SerializedName("type") open var Type:String? = null
    open var public_Gists:Int? = null
    open var location:String? = null
    open var company:String? = null
    open var html_Url:String? = null
    open var public_Repos:Int? = null
    open var created_At:Date? = null
    open var blog:String? = null
    open var email:String? = null
    open var name:String? = null
    open var hireable:Boolean? = null
    open var gravatar_Id:String? = null
    open var bio:String? = null
}

Kotlin QueryCustomers 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 /csv/reply/QueryCustomers HTTP/1.1 
Host: sharpscript.net 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"customerId":"String","companyNameContains":"String","countryIn":["String"],"skip":0,"take":0,"orderBy":"String","orderByDesc":"String","include":"String","fields":"String","meta":{"String":"String"}}

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

{"offset":0,"total":0,"results":[{"customerId":"String","companyName":"String","address":"String","city":"String","region":"String","postalCode":"String","country":"String","phone":"String","fax":"String","orders":[{"orderId":0,"customerId":"String","orderDate":"\/Date(-62135596800000-0000)\/","total":0}]}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}