TechStacks!

<back to all web services

QueryPosts

AutoQueryPosts
The following routes are available for this service:
GET/posts
import Foundation
import ServiceStack

public class QueryPosts : QueryDb<Post>
{
    public var ids:[Int]
    public var organizationId:Int?
    public var organizationIds:[Int]
    public var types:[String]
    public var anyTechnologyIds:[Int]
    public var `is`:[String]

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

    private enum CodingKeys : String, CodingKey {
        case ids
        case organizationId
        case organizationIds
        case types
        case anyTechnologyIds
        case `is`
    }

    required public init(from decoder: Decoder) throws {
        try super.init(from: decoder)
        let container = try decoder.container(keyedBy: CodingKeys.self)
        ids = try container.decodeIfPresent([Int].self, forKey: .ids) ?? []
        organizationId = try container.decodeIfPresent(Int.self, forKey: .organizationId)
        organizationIds = try container.decodeIfPresent([Int].self, forKey: .organizationIds) ?? []
        types = try container.decodeIfPresent([String].self, forKey: .types) ?? []
        anyTechnologyIds = try container.decodeIfPresent([Int].self, forKey: .anyTechnologyIds) ?? []
        `is` = try container.decodeIfPresent([String].self, forKey: .`is`) ?? []
    }

    public override func encode(to encoder: Encoder) throws {
        try super.encode(to: encoder)
        var container = encoder.container(keyedBy: CodingKeys.self)
        if ids != nil { try container.encode(ids, forKey: .ids) }
        if organizationId != nil { try container.encode(organizationId, forKey: .organizationId) }
        if organizationIds != nil { try container.encode(organizationIds, forKey: .organizationIds) }
        if types != nil { try container.encode(types, forKey: .types) }
        if anyTechnologyIds != nil { try container.encode(anyTechnologyIds, forKey: .anyTechnologyIds) }
        if `is` != nil { try container.encode(`is`, forKey: .`is`) }
    }
}

public class Post : Codable
{
    public var id:Int
    public var organizationId:Int
    public var userId:Int
    public var type:PostType
    public var categoryId:Int
    public var title:String
    public var slug:String
    public var url:String
    public var imageUrl:String
    // @StringLength(Int32.max)
    public var content:String

    // @StringLength(Int32.max)
    public var contentHtml:String

    public var pinCommentId:Int?
    public var technologyIds:[Int]
    public var fromDate:Date?
    public var toDate:Date?
    public var location:String
    public var metaType:String
    public var meta:String
    public var approved:Bool
    public var upVotes:Int
    public var downVotes:Int
    public var points:Int
    public var views:Int
    public var favorites:Int
    public var subscribers:Int
    public var replyCount:Int
    public var commentsCount:Int
    public var wordCount:Int
    public var reportCount:Int
    public var linksCount:Int
    public var linkedToCount:Int
    public var score:Int
    public var rank:Int
    public var labels:[String]
    public var refUserIds:[Int]
    public var refLinks:[String]
    public var muteUserIds:[Int]
    public var lastCommentDate:Date?
    public var lastCommentId:Int?
    public var lastCommentUserId:Int?
    public var deleted:Date?
    public var deletedBy:String
    public var locked:Date?
    public var lockedBy:String
    public var hidden:Date?
    public var hiddenBy:String
    public var status:String
    public var statusDate:Date?
    public var statusBy:String
    public var archived:Bool
    public var bumped:Date?
    public var created:Date
    public var createdBy:String
    public var modified:Date
    public var modifiedBy:String
    public var refId:Int?
    public var refSource:String
    public var refUrn:String

    required public init(){}
}

public enum PostType : String, Codable
{
    case Announcement
    case Post
    case Showcase
    case Question
    case Request
}

Swift QueryPosts 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 /posts HTTP/1.1 
Host: techstacks.io 
Accept: text/csv

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

{"offset":0,"total":0,"results":[{"id":0,"organizationId":0,"userId":0,"type":"Announcement","categoryId":0,"title":"String","slug":"String","url":"String","imageUrl":"String","content":"String","contentHtml":"String","pinCommentId":0,"technologyIds":[0],"fromDate":"0001-01-01T00:00:00.0000000","toDate":"0001-01-01T00:00:00.0000000","location":"String","metaType":"String","meta":"String","approved":false,"upVotes":0,"downVotes":0,"points":0,"views":0,"favorites":0,"subscribers":0,"replyCount":0,"commentsCount":0,"wordCount":0,"reportCount":0,"linksCount":0,"linkedToCount":0,"score":0,"rank":0,"labels":["String"],"refUserIds":[0],"refLinks":["String"],"muteUserIds":[0],"lastCommentDate":"0001-01-01T00:00:00.0000000","lastCommentId":0,"lastCommentUserId":0,"deleted":"0001-01-01T00:00:00.0000000","deletedBy":"String","locked":"0001-01-01T00:00:00.0000000","lockedBy":"String","hidden":"0001-01-01T00:00:00.0000000","hiddenBy":"String","status":"String","statusDate":"0001-01-01T00:00:00.0000000","statusBy":"String","archived":false,"bumped":"0001-01-01T00:00:00.0000000","created":"0001-01-01T00:00:00.0000000","createdBy":"String","modified":"0001-01-01T00:00:00.0000000","modifiedBy":"String","refId":0,"refSource":"String","refUrn":"String"}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}