TechStacks!

<back to all web services

QueryPosts

AutoQueryPosts
The following routes are available for this service:
GET/posts
using System;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.Serialization;
using ServiceStack;
using ServiceStack.DataAnnotations;
using TechStacks.ServiceModel;
using TechStacks.ServiceModel.Types;

namespace ServiceStack
{
    [DataContract]
    public partial class QueryBase
    {
        public QueryBase()
        {
            Meta = new Dictionary<string, string>{};
        }

        [DataMember(Order=1)]
        public virtual int? Skip { get; set; }

        [DataMember(Order=2)]
        public virtual int? Take { get; set; }

        [DataMember(Order=3)]
        public virtual string OrderBy { get; set; }

        [DataMember(Order=4)]
        public virtual string OrderByDesc { get; set; }

        [DataMember(Order=5)]
        public virtual string Include { get; set; }

        [DataMember(Order=6)]
        public virtual string Fields { get; set; }

        [DataMember(Order=7)]
        public virtual Dictionary<string, string> Meta { get; set; }
    }

    public partial class QueryDb<T>
        : QueryBase
    {
        public QueryDb()
        {
            Meta = new Dictionary<string, string>{};
        }

        [DataMember(Order=1)]
        public virtual int? Skip { get; set; }

        [DataMember(Order=2)]
        public virtual int? Take { get; set; }

        [DataMember(Order=3)]
        public virtual string OrderBy { get; set; }

        [DataMember(Order=4)]
        public virtual string OrderByDesc { get; set; }

        [DataMember(Order=5)]
        public virtual string Include { get; set; }

        [DataMember(Order=6)]
        public virtual string Fields { get; set; }

        [DataMember(Order=7)]
        public virtual Dictionary<string, string> Meta { get; set; }
    }

    [DataContract]
    public partial class QueryResponse<Post>
    {
        public QueryResponse()
        {
            Results = new List<Post>{};
            Meta = new Dictionary<string, string>{};
        }

        [DataMember(Order=1)]
        public virtual int Offset { get; set; }

        [DataMember(Order=2)]
        public virtual int Total { get; set; }

        [DataMember(Order=3)]
        public virtual List<Post> Results { get; set; }

        [DataMember(Order=4)]
        public virtual Dictionary<string, string> Meta { get; set; }

        [DataMember(Order=5)]
        public virtual ResponseStatus ResponseStatus { get; set; }
    }

}

namespace TechStacks.ServiceModel
{
    public partial class QueryPosts
        : QueryDb<Post>
    {
        public virtual int[] Ids { get; set; }
        public virtual int? OrganizationId { get; set; }
        public virtual List<int> OrganizationIds { get; set; }
        public virtual HashSet<string> Types { get; set; }
        public virtual HashSet<int> AnyTechnologyIds { get; set; }
        public virtual string[] Is { get; set; }
        [DataMember(Order=1)]
        public virtual int? Skip { get; set; }

        [DataMember(Order=2)]
        public virtual int? Take { get; set; }

        [DataMember(Order=3)]
        public virtual string OrderBy { get; set; }

        [DataMember(Order=4)]
        public virtual string OrderByDesc { get; set; }

        [DataMember(Order=5)]
        public virtual string Include { get; set; }

        [DataMember(Order=6)]
        public virtual string Fields { get; set; }

        [DataMember(Order=7)]
        public virtual Dictionary<string, string> Meta { get; set; }
    }

}

namespace TechStacks.ServiceModel.Types
{
    public partial class Post
    {
        public Post()
        {
            TechnologyIds = new int[]{};
            Labels = new string[]{};
            RefUserIds = new int[]{};
            RefLinks = new string[]{};
            MuteUserIds = new int[]{};
        }

        public virtual long Id { get; set; }
        public virtual int OrganizationId { get; set; }
        public virtual int UserId { get; set; }
        public virtual PostType Type { get; set; }
        public virtual int CategoryId { get; set; }
        public virtual string Title { get; set; }
        public virtual string Slug { get; set; }
        public virtual string Url { get; set; }
        public virtual string ImageUrl { get; set; }
        [StringLength(int.MaxValue)]
        public virtual string Content { get; set; }

        [StringLength(int.MaxValue)]
        public virtual string ContentHtml { get; set; }

        public virtual long? PinCommentId { get; set; }
        public virtual int[] TechnologyIds { get; set; }
        public virtual DateTime? FromDate { get; set; }
        public virtual DateTime? ToDate { get; set; }
        public virtual string Location { get; set; }
        public virtual string MetaType { get; set; }
        public virtual string Meta { get; set; }
        public virtual bool Approved { get; set; }
        public virtual long UpVotes { get; set; }
        public virtual long DownVotes { get; set; }
        public virtual long Points { get; set; }
        public virtual long Views { get; set; }
        public virtual long Favorites { get; set; }
        public virtual int Subscribers { get; set; }
        public virtual int ReplyCount { get; set; }
        public virtual int CommentsCount { get; set; }
        public virtual int WordCount { get; set; }
        public virtual int ReportCount { get; set; }
        public virtual int LinksCount { get; set; }
        public virtual int LinkedToCount { get; set; }
        public virtual int Score { get; set; }
        public virtual int Rank { get; set; }
        public virtual string[] Labels { get; set; }
        public virtual int[] RefUserIds { get; set; }
        public virtual string[] RefLinks { get; set; }
        public virtual int[] MuteUserIds { get; set; }
        public virtual DateTime? LastCommentDate { get; set; }
        public virtual long? LastCommentId { get; set; }
        public virtual int? LastCommentUserId { get; set; }
        public virtual DateTime? Deleted { get; set; }
        public virtual string DeletedBy { get; set; }
        public virtual DateTime? Locked { get; set; }
        public virtual string LockedBy { get; set; }
        public virtual DateTime? Hidden { get; set; }
        public virtual string HiddenBy { get; set; }
        public virtual string Status { get; set; }
        public virtual DateTime? StatusDate { get; set; }
        public virtual string StatusBy { get; set; }
        public virtual bool Archived { get; set; }
        public virtual DateTime? Bumped { get; set; }
        public virtual DateTime Created { get; set; }
        public virtual string CreatedBy { get; set; }
        public virtual DateTime Modified { get; set; }
        public virtual string ModifiedBy { get; set; }
        public virtual long? RefId { get; set; }
        public virtual string RefSource { get; set; }
        public virtual string RefUrn { get; set; }
    }

    public enum PostType
    {
        Announcement,
        Post,
        Showcase,
        Question,
        Request,
    }

}

C# 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"}}}