TechStacks!

<back to all web services

QueryPostComments

AutoQueryPosts
The following routes are available for this service:
GET/posts/comment
namespace TechStacks.ServiceModel

open System
open System.Collections
open System.Collections.Generic
open System.Runtime.Serialization
open ServiceStack
open ServiceStack.DataAnnotations

    [<AllowNullLiteral>]
    type PostComment() = 
        member val Id:Int64 = new Int64() with get,set
        member val PostId:Int64 = new Int64() with get,set
        member val UserId:Int32 = new Int32() with get,set
        member val ReplyId:Nullable<Int64> = new Nullable<Int64>() with get,set
        [<StringLength(Int32.MaxValue)>]
        member val Content:String = null with get,set

        [<StringLength(Int32.MaxValue)>]
        member val ContentHtml:String = null with get,set

        member val Score:Int32 = new Int32() with get,set
        member val Rank:Int32 = new Int32() with get,set
        member val UpVotes:Int64 = new Int64() with get,set
        member val DownVotes:Int64 = new Int64() with get,set
        member val Favorites:Int64 = new Int64() with get,set
        member val WordCount:Int32 = new Int32() with get,set
        member val ReportCount:Int32 = new Int32() with get,set
        member val Deleted:Nullable<DateTime> = new Nullable<DateTime>() with get,set
        member val Hidden:Nullable<DateTime> = new Nullable<DateTime>() with get,set
        member val Modified:DateTime = new DateTime() with get,set
        member val Created:DateTime = new DateTime() with get,set
        member val CreatedBy:String = null with get,set
        member val RefId:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val RefSource:String = null with get,set
        member val RefUrn:String = null with get,set

    [<AllowNullLiteral>]
    type QueryPostComments() = 
        inherit QueryDb<PostComment>()
        member val Id:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val UserId:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val PostId:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val ContentContains:String = null with get,set
        member val UpVotesAbove:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val UpVotesBelow:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val DownVotesAbove:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val DownVotes:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val FavoritesAbove:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val FavoritesBelow:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val WordCountAbove:Nullable<Int32> = new Nullable<Int32>() with get,set
        member val WordCountBelow:Nullable<Int32> = new Nullable<Int32>() with get,set
        member val ReportCountAbove:Nullable<Int32> = new Nullable<Int32>() with get,set
        member val ReportCountBelow:Nullable<Int32> = new Nullable<Int32>() with get,set
        [<DataMember(Order=1)>]
        member val Skip:Nullable<Int32> = new Nullable<Int32>() with get,set

        [<DataMember(Order=2)>]
        member val Take:Nullable<Int32> = new Nullable<Int32>() with get,set

        [<DataMember(Order=3)>]
        member val OrderBy:String = null with get,set

        [<DataMember(Order=4)>]
        member val OrderByDesc:String = null with get,set

        [<DataMember(Order=5)>]
        member val Include:String = null with get,set

        [<DataMember(Order=6)>]
        member val Fields:String = null with get,set

        [<DataMember(Order=7)>]
        member val Meta:Dictionary<String, String> = null with get,set

    [<DataContract>]
    [<AllowNullLiteral>]
    type QueryBase() = 
        [<DataMember(Order=1)>]
        member val Skip:Nullable<Int32> = new Nullable<Int32>() with get,set

        [<DataMember(Order=2)>]
        member val Take:Nullable<Int32> = new Nullable<Int32>() with get,set

        [<DataMember(Order=3)>]
        member val OrderBy:String = null with get,set

        [<DataMember(Order=4)>]
        member val OrderByDesc:String = null with get,set

        [<DataMember(Order=5)>]
        member val Include:String = null with get,set

        [<DataMember(Order=6)>]
        member val Fields:String = null with get,set

        [<DataMember(Order=7)>]
        member val Meta:Dictionary<String, String> = new Dictionary<String, String>() with get,set

    [<AllowNullLiteral>]
    type QueryDb<T>() = 
        inherit QueryBase()
        [<DataMember(Order=1)>]
        member val Skip:Nullable<Int32> = new Nullable<Int32>() with get,set

        [<DataMember(Order=2)>]
        member val Take:Nullable<Int32> = new Nullable<Int32>() with get,set

        [<DataMember(Order=3)>]
        member val OrderBy:String = null with get,set

        [<DataMember(Order=4)>]
        member val OrderByDesc:String = null with get,set

        [<DataMember(Order=5)>]
        member val Include:String = null with get,set

        [<DataMember(Order=6)>]
        member val Fields:String = null with get,set

        [<DataMember(Order=7)>]
        member val Meta:Dictionary<String, String> = new Dictionary<String, String>() with get,set

    type PostType =
        | Announcement = 0
        | Post = 1
        | Showcase = 2
        | Question = 3
        | Request = 4

    [<AllowNullLiteral>]
    type Post() = 
        member val Id:Int64 = new Int64() with get,set
        member val OrganizationId:Int32 = new Int32() with get,set
        member val UserId:Int32 = new Int32() with get,set
        member val Type:PostType = new PostType() with get,set
        member val CategoryId:Int32 = new Int32() with get,set
        member val Title:String = null with get,set
        member val Slug:String = null with get,set
        member val Url:String = null with get,set
        member val ImageUrl:String = null with get,set
        [<StringLength(Int32.MaxValue)>]
        member val Content:String = null with get,set

        [<StringLength(Int32.MaxValue)>]
        member val ContentHtml:String = null with get,set

        member val PinCommentId:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val TechnologyIds:Int32[] = [||] with get,set
        member val FromDate:Nullable<DateTime> = new Nullable<DateTime>() with get,set
        member val ToDate:Nullable<DateTime> = new Nullable<DateTime>() with get,set
        member val Location:String = null with get,set
        member val MetaType:String = null with get,set
        member val Meta:String = null with get,set
        member val Approved:Boolean = new Boolean() with get,set
        member val UpVotes:Int64 = new Int64() with get,set
        member val DownVotes:Int64 = new Int64() with get,set
        member val Points:Int64 = new Int64() with get,set
        member val Views:Int64 = new Int64() with get,set
        member val Favorites:Int64 = new Int64() with get,set
        member val Subscribers:Int32 = new Int32() with get,set
        member val ReplyCount:Int32 = new Int32() with get,set
        member val CommentsCount:Int32 = new Int32() with get,set
        member val WordCount:Int32 = new Int32() with get,set
        member val ReportCount:Int32 = new Int32() with get,set
        member val LinksCount:Int32 = new Int32() with get,set
        member val LinkedToCount:Int32 = new Int32() with get,set
        member val Score:Int32 = new Int32() with get,set
        member val Rank:Int32 = new Int32() with get,set
        member val Labels:String[] = [||] with get,set
        member val RefUserIds:Int32[] = [||] with get,set
        member val RefLinks:String[] = [||] with get,set
        member val MuteUserIds:Int32[] = [||] with get,set
        member val LastCommentDate:Nullable<DateTime> = new Nullable<DateTime>() with get,set
        member val LastCommentId:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val LastCommentUserId:Nullable<Int32> = new Nullable<Int32>() with get,set
        member val Deleted:Nullable<DateTime> = new Nullable<DateTime>() with get,set
        member val DeletedBy:String = null with get,set
        member val Locked:Nullable<DateTime> = new Nullable<DateTime>() with get,set
        member val LockedBy:String = null with get,set
        member val Hidden:Nullable<DateTime> = new Nullable<DateTime>() with get,set
        member val HiddenBy:String = null with get,set
        member val Status:String = null with get,set
        member val StatusDate:Nullable<DateTime> = new Nullable<DateTime>() with get,set
        member val StatusBy:String = null with get,set
        member val Archived:Boolean = new Boolean() with get,set
        member val Bumped:Nullable<DateTime> = new Nullable<DateTime>() with get,set
        member val Created:DateTime = new DateTime() with get,set
        member val CreatedBy:String = null with get,set
        member val Modified:DateTime = new DateTime() with get,set
        member val ModifiedBy:String = null with get,set
        member val RefId:Nullable<Int64> = new Nullable<Int64>() with get,set
        member val RefSource:String = null with get,set
        member val RefUrn:String = null with get,set

    [<DataContract>]
    [<AllowNullLiteral>]
    type QueryResponse<Post>() = 
        [<DataMember(Order=1)>]
        member val Offset:Int32 = new Int32() with get,set

        [<DataMember(Order=2)>]
        member val Total:Int32 = new Int32() with get,set

        [<DataMember(Order=3)>]
        member val Results:ResizeArray<Post> = new ResizeArray<Post>() with get,set

        [<DataMember(Order=4)>]
        member val Meta:Dictionary<String, String> = new Dictionary<String, String>() with get,set

        [<DataMember(Order=5)>]
        member val ResponseStatus:ResponseStatus = null with get,set

F# QueryPostComments 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/comment 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,"postId":0,"userId":0,"replyId":0,"content":"String","contentHtml":"String","score":0,"rank":0,"upVotes":0,"downVotes":0,"favorites":0,"wordCount":0,"reportCount":0,"deleted":"0001-01-01T00:00:00.0000000","hidden":"0001-01-01T00:00:00.0000000","modified":"0001-01-01T00:00:00.0000000","created":"0001-01-01T00:00:00.0000000","createdBy":"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"}}}