MyApp

<back to all web services

QueryChinookEmployees

Media Store
The following routes are available for this service:
GET/employees
GET/employees/{EmployeeId}
import Foundation
import ServiceStack

public class QueryChinookEmployees : QueryDb<Employees>, IGet
{
    public var employeeId:Int?

    required public init(){ super.init() }

    private enum CodingKeys : String, CodingKey {
        case employeeId
    }

    required public init(from decoder: Decoder) throws {
        try super.init(from: decoder)
        let container = try decoder.container(keyedBy: CodingKeys.self)
        employeeId = try container.decodeIfPresent(Int.self, forKey: .employeeId)
    }

    public override func encode(to encoder: Encoder) throws {
        try super.encode(to: encoder)
        var container = encoder.container(keyedBy: CodingKeys.self)
        if employeeId != nil { try container.encode(employeeId, forKey: .employeeId) }
    }
}

public class Employees : Codable
{
    public var employeeId:Int
    // @Required()
    public var lastName:String?

    // @Required()
    public var firstName:String?

    public var title:String
    public var reportsTo:Int?
    public var birthDate:Date?
    public var hireDate:Date?
    public var address:String
    public var city:String
    public var state:String
    public var country:String
    public var postalCode:String
    public var phone:String
    public var fax:String
    public var email:String

    required public init(){}
}

public class Todo : Codable
{
    public var id:Int
    public var text:String
    public var isFinished:Bool

    required public init(){}
}


Swift QueryChinookEmployees 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.

GET /employees HTTP/1.1 
Host: blazor-gallery.servicestack.net 
Accept: text/csv
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"offset":0,"total":0,"results":[{"employeeId":0,"lastName":"String","firstName":"String","title":"String","reportsTo":0,"birthDate":"0001-01-01T00:00:00","hireDate":"0001-01-01T00:00:00","address":"String","city":"String","state":"String","country":"String","postalCode":"String","phone":"String","fax":"String","email":"String"}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}