TechStacks!

<back to all web services

QueryPosts

AutoQueryPosts
The following routes are available for this service:
GET/posts
import java.math.*;
import java.util.*;
import net.servicestack.client.*;
import com.google.gson.annotations.*;
import com.google.gson.reflect.*;

public class dtos
{

    public static class QueryPosts extends QueryDb<Post>
    {
        public ArrayList<Integer> ids = null;
        public Integer organizationId = null;
        public ArrayList<Integer> organizationIds = null;
        public ArrayList<String> types = null;
        public ArrayList<Integer> anyTechnologyIds = null;
        public ArrayList<String> is = null;
        @DataMember(Order=1)
        public Integer skip = null;

        @DataMember(Order=2)
        public Integer take = null;

        @DataMember(Order=3)
        public String orderBy = null;

        @DataMember(Order=4)
        public String orderByDesc = null;

        @DataMember(Order=5)
        public String include = null;

        @DataMember(Order=6)
        public String fields = null;

        @DataMember(Order=7)
        public HashMap<String,String> meta = null;
        
        public ArrayList<Integer> getIds() { return ids; }
        public QueryPosts setIds(ArrayList<Integer> value) { this.ids = value; return this; }
        public Integer getOrganizationId() { return organizationId; }
        public QueryPosts setOrganizationId(Integer value) { this.organizationId = value; return this; }
        public ArrayList<Integer> getOrganizationIds() { return organizationIds; }
        public QueryPosts setOrganizationIds(ArrayList<Integer> value) { this.organizationIds = value; return this; }
        public ArrayList<String> getTypes() { return types; }
        public QueryPosts setTypes(ArrayList<String> value) { this.types = value; return this; }
        public ArrayList<Integer> getAnyTechnologyIds() { return anyTechnologyIds; }
        public QueryPosts setAnyTechnologyIds(ArrayList<Integer> value) { this.anyTechnologyIds = value; return this; }
        public ArrayList<String> getIs() { return is; }
        public QueryPosts setIs(ArrayList<String> value) { this.is = value; return this; }
        public Integer getSkip() { return skip; }
        public QueryPosts setSkip(Integer value) { this.skip = value; return this; }
        public Integer getTake() { return take; }
        public QueryPosts setTake(Integer value) { this.take = value; return this; }
        public String getOrderBy() { return orderBy; }
        public QueryPosts setOrderBy(String value) { this.orderBy = value; return this; }
        public String getOrderByDesc() { return orderByDesc; }
        public QueryPosts setOrderByDesc(String value) { this.orderByDesc = value; return this; }
        public String getInclude() { return include; }
        public QueryPosts setInclude(String value) { this.include = value; return this; }
        public String getFields() { return fields; }
        public QueryPosts setFields(String value) { this.fields = value; return this; }
        public HashMap<String,String> getMeta() { return meta; }
        public QueryPosts setMeta(HashMap<String,String> value) { this.meta = value; return this; }
    }

    public static class QueryDb<T> extends QueryBase
    {
        @DataMember(Order=1)
        public Integer skip = null;

        @DataMember(Order=2)
        public Integer take = null;

        @DataMember(Order=3)
        public String orderBy = null;

        @DataMember(Order=4)
        public String orderByDesc = null;

        @DataMember(Order=5)
        public String include = null;

        @DataMember(Order=6)
        public String fields = null;

        @DataMember(Order=7)
        public HashMap<String,String> meta = null;
        
        public Integer getSkip() { return skip; }
        public QueryDb<T> setSkip(Integer value) { this.skip = value; return this; }
        public Integer getTake() { return take; }
        public QueryDb<T> setTake(Integer value) { this.take = value; return this; }
        public String getOrderBy() { return orderBy; }
        public QueryDb<T> setOrderBy(String value) { this.orderBy = value; return this; }
        public String getOrderByDesc() { return orderByDesc; }
        public QueryDb<T> setOrderByDesc(String value) { this.orderByDesc = value; return this; }
        public String getInclude() { return include; }
        public QueryDb<T> setInclude(String value) { this.include = value; return this; }
        public String getFields() { return fields; }
        public QueryDb<T> setFields(String value) { this.fields = value; return this; }
        public HashMap<String,String> getMeta() { return meta; }
        public QueryDb<T> setMeta(HashMap<String,String> value) { this.meta = value; return this; }
    }

    @DataContract
    public static class QueryBase
    {
        @DataMember(Order=1)
        public Integer skip = null;

        @DataMember(Order=2)
        public Integer take = null;

        @DataMember(Order=3)
        public String orderBy = null;

        @DataMember(Order=4)
        public String orderByDesc = null;

        @DataMember(Order=5)
        public String include = null;

        @DataMember(Order=6)
        public String fields = null;

        @DataMember(Order=7)
        public HashMap<String,String> meta = null;
        
        public Integer getSkip() { return skip; }
        public QueryBase setSkip(Integer value) { this.skip = value; return this; }
        public Integer getTake() { return take; }
        public QueryBase setTake(Integer value) { this.take = value; return this; }
        public String getOrderBy() { return orderBy; }
        public QueryBase setOrderBy(String value) { this.orderBy = value; return this; }
        public String getOrderByDesc() { return orderByDesc; }
        public QueryBase setOrderByDesc(String value) { this.orderByDesc = value; return this; }
        public String getInclude() { return include; }
        public QueryBase setInclude(String value) { this.include = value; return this; }
        public String getFields() { return fields; }
        public QueryBase setFields(String value) { this.fields = value; return this; }
        public HashMap<String,String> getMeta() { return meta; }
        public QueryBase setMeta(HashMap<String,String> value) { this.meta = value; return this; }
    }

    public static class Post
    {
        public Long id = null;
        public Integer organizationId = null;
        public Integer userId = null;
        public PostType type = null;
        public Integer categoryId = null;
        public String title = null;
        public String slug = null;
        public String url = null;
        public String imageUrl = null;
        @StringLength(2147483647)
        public String content = null;

        @StringLength(2147483647)
        public String contentHtml = null;

        public Long pinCommentId = null;
        public ArrayList<Integer> technologyIds = null;
        public Date fromDate = null;
        public Date toDate = null;
        public String location = null;
        public String metaType = null;
        public String meta = null;
        public Boolean approved = null;
        public Long upVotes = null;
        public Long downVotes = null;
        public Long points = null;
        public Long views = null;
        public Long favorites = null;
        public Integer subscribers = null;
        public Integer replyCount = null;
        public Integer commentsCount = null;
        public Integer wordCount = null;
        public Integer reportCount = null;
        public Integer linksCount = null;
        public Integer linkedToCount = null;
        public Integer score = null;
        public Integer rank = null;
        public ArrayList<String> labels = null;
        public ArrayList<Integer> refUserIds = null;
        public ArrayList<String> refLinks = null;
        public ArrayList<Integer> muteUserIds = null;
        public Date lastCommentDate = null;
        public Long lastCommentId = null;
        public Integer lastCommentUserId = null;
        public Date deleted = null;
        public String deletedBy = null;
        public Date locked = null;
        public String lockedBy = null;
        public Date hidden = null;
        public String hiddenBy = null;
        public String status = null;
        public Date statusDate = null;
        public String statusBy = null;
        public Boolean archived = null;
        public Date bumped = null;
        public Date created = null;
        public String createdBy = null;
        public Date modified = null;
        public String modifiedBy = null;
        public Long refId = null;
        public String refSource = null;
        public String refUrn = null;
        
        public Long getId() { return id; }
        public Post setId(Long value) { this.id = value; return this; }
        public Integer getOrganizationId() { return organizationId; }
        public Post setOrganizationId(Integer value) { this.organizationId = value; return this; }
        public Integer getUserId() { return userId; }
        public Post setUserId(Integer value) { this.userId = value; return this; }
        public PostType getType() { return type; }
        public Post setType(PostType value) { this.type = value; return this; }
        public Integer getCategoryId() { return categoryId; }
        public Post setCategoryId(Integer value) { this.categoryId = value; return this; }
        public String getTitle() { return title; }
        public Post setTitle(String value) { this.title = value; return this; }
        public String getSlug() { return slug; }
        public Post setSlug(String value) { this.slug = value; return this; }
        public String getUrl() { return url; }
        public Post setUrl(String value) { this.url = value; return this; }
        public String getImageUrl() { return imageUrl; }
        public Post setImageUrl(String value) { this.imageUrl = value; return this; }
        public String getContent() { return content; }
        public Post setContent(String value) { this.content = value; return this; }
        public String getContentHtml() { return contentHtml; }
        public Post setContentHtml(String value) { this.contentHtml = value; return this; }
        public Long getPinCommentId() { return pinCommentId; }
        public Post setPinCommentId(Long value) { this.pinCommentId = value; return this; }
        public ArrayList<Integer> getTechnologyIds() { return technologyIds; }
        public Post setTechnologyIds(ArrayList<Integer> value) { this.technologyIds = value; return this; }
        public Date getFromDate() { return fromDate; }
        public Post setFromDate(Date value) { this.fromDate = value; return this; }
        public Date getToDate() { return toDate; }
        public Post setToDate(Date value) { this.toDate = value; return this; }
        public String getLocation() { return location; }
        public Post setLocation(String value) { this.location = value; return this; }
        public String getMetaType() { return metaType; }
        public Post setMetaType(String value) { this.metaType = value; return this; }
        public String getMeta() { return meta; }
        public Post setMeta(String value) { this.meta = value; return this; }
        public Boolean isApproved() { return approved; }
        public Post setApproved(Boolean value) { this.approved = value; return this; }
        public Long getUpVotes() { return upVotes; }
        public Post setUpVotes(Long value) { this.upVotes = value; return this; }
        public Long getDownVotes() { return downVotes; }
        public Post setDownVotes(Long value) { this.downVotes = value; return this; }
        public Long getPoints() { return points; }
        public Post setPoints(Long value) { this.points = value; return this; }
        public Long getViews() { return views; }
        public Post setViews(Long value) { this.views = value; return this; }
        public Long getFavorites() { return favorites; }
        public Post setFavorites(Long value) { this.favorites = value; return this; }
        public Integer getSubscribers() { return subscribers; }
        public Post setSubscribers(Integer value) { this.subscribers = value; return this; }
        public Integer getReplyCount() { return replyCount; }
        public Post setReplyCount(Integer value) { this.replyCount = value; return this; }
        public Integer getCommentsCount() { return commentsCount; }
        public Post setCommentsCount(Integer value) { this.commentsCount = value; return this; }
        public Integer getWordCount() { return wordCount; }
        public Post setWordCount(Integer value) { this.wordCount = value; return this; }
        public Integer getReportCount() { return reportCount; }
        public Post setReportCount(Integer value) { this.reportCount = value; return this; }
        public Integer getLinksCount() { return linksCount; }
        public Post setLinksCount(Integer value) { this.linksCount = value; return this; }
        public Integer getLinkedToCount() { return linkedToCount; }
        public Post setLinkedToCount(Integer value) { this.linkedToCount = value; return this; }
        public Integer getScore() { return score; }
        public Post setScore(Integer value) { this.score = value; return this; }
        public Integer getRank() { return rank; }
        public Post setRank(Integer value) { this.rank = value; return this; }
        public ArrayList<String> getLabels() { return labels; }
        public Post setLabels(ArrayList<String> value) { this.labels = value; return this; }
        public ArrayList<Integer> getRefUserIds() { return refUserIds; }
        public Post setRefUserIds(ArrayList<Integer> value) { this.refUserIds = value; return this; }
        public ArrayList<String> getRefLinks() { return refLinks; }
        public Post setRefLinks(ArrayList<String> value) { this.refLinks = value; return this; }
        public ArrayList<Integer> getMuteUserIds() { return muteUserIds; }
        public Post setMuteUserIds(ArrayList<Integer> value) { this.muteUserIds = value; return this; }
        public Date getLastCommentDate() { return lastCommentDate; }
        public Post setLastCommentDate(Date value) { this.lastCommentDate = value; return this; }
        public Long getLastCommentId() { return lastCommentId; }
        public Post setLastCommentId(Long value) { this.lastCommentId = value; return this; }
        public Integer getLastCommentUserId() { return lastCommentUserId; }
        public Post setLastCommentUserId(Integer value) { this.lastCommentUserId = value; return this; }
        public Date getDeleted() { return deleted; }
        public Post setDeleted(Date value) { this.deleted = value; return this; }
        public String getDeletedBy() { return deletedBy; }
        public Post setDeletedBy(String value) { this.deletedBy = value; return this; }
        public Date getLocked() { return locked; }
        public Post setLocked(Date value) { this.locked = value; return this; }
        public String getLockedBy() { return lockedBy; }
        public Post setLockedBy(String value) { this.lockedBy = value; return this; }
        public Date getHidden() { return hidden; }
        public Post setHidden(Date value) { this.hidden = value; return this; }
        public String getHiddenBy() { return hiddenBy; }
        public Post setHiddenBy(String value) { this.hiddenBy = value; return this; }
        public String getStatus() { return status; }
        public Post setStatus(String value) { this.status = value; return this; }
        public Date getStatusDate() { return statusDate; }
        public Post setStatusDate(Date value) { this.statusDate = value; return this; }
        public String getStatusBy() { return statusBy; }
        public Post setStatusBy(String value) { this.statusBy = value; return this; }
        public Boolean isArchived() { return archived; }
        public Post setArchived(Boolean value) { this.archived = value; return this; }
        public Date getBumped() { return bumped; }
        public Post setBumped(Date value) { this.bumped = value; return this; }
        public Date getCreated() { return created; }
        public Post setCreated(Date value) { this.created = value; return this; }
        public String getCreatedBy() { return createdBy; }
        public Post setCreatedBy(String value) { this.createdBy = value; return this; }
        public Date getModified() { return modified; }
        public Post setModified(Date value) { this.modified = value; return this; }
        public String getModifiedBy() { return modifiedBy; }
        public Post setModifiedBy(String value) { this.modifiedBy = value; return this; }
        public Long getRefId() { return refId; }
        public Post setRefId(Long value) { this.refId = value; return this; }
        public String getRefSource() { return refSource; }
        public Post setRefSource(String value) { this.refSource = value; return this; }
        public String getRefUrn() { return refUrn; }
        public Post setRefUrn(String value) { this.refUrn = value; return this; }
    }

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

    @DataContract
    public static class QueryResponse<Post>
    {
        @DataMember(Order=1)
        public Integer offset = null;

        @DataMember(Order=2)
        public Integer total = null;

        @DataMember(Order=3)
        public ArrayList<Post> results = null;

        @DataMember(Order=4)
        public HashMap<String,String> meta = null;

        @DataMember(Order=5)
        public ResponseStatus responseStatus = null;
        
        public Integer getOffset() { return offset; }
        public QueryResponse<Post> setOffset(Integer value) { this.offset = value; return this; }
        public Integer getTotal() { return total; }
        public QueryResponse<Post> setTotal(Integer value) { this.total = value; return this; }
        public ArrayList<Post> getResults() { return results; }
        public QueryResponse<Post> setResults(ArrayList<Post> value) { this.results = value; return this; }
        public HashMap<String,String> getMeta() { return meta; }
        public QueryResponse<Post> setMeta(HashMap<String,String> value) { this.meta = value; return this; }
        public ResponseStatus getResponseStatus() { return responseStatus; }
        public QueryResponse<Post> setResponseStatus(ResponseStatus value) { this.responseStatus = value; return this; }
    }

}

Java 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"}}}