TechStacks!

QueryPosts

AutoQueryPosts

The following routes are available for this service:
GET	/posts

**QueryPosts** Parameters:
Name	Parameter	Data Type	Required
Ids	query	int[]	No
OrganizationId	query	int?	No
OrganizationIds	query	List<int>	No
Types	query	HashSet<string>	No
AnyTechnologyIds	query	HashSet<int>	No
Is	query	string[]	No
Skip	query	int?	No
Take	query	int?	No
OrderBy	query	string	No
OrderByDesc	query	string	No
Include	query	string	No
Fields	query	string	No
Meta	query	Dictionary<string, string>	No

**QueryDb<T>** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**QueryBase** Parameters:
Name	Parameter	Data Type	Required
Skip	form	int?	No
Take	form	int?	No
OrderBy	form	string	No
OrderByDesc	form	string	No
Include	form	string	No
Fields	form	string	No
Meta	form	Dictionary<string, string>	No

**Post** Parameters:
Name	Parameter	Data Type	Required
Id	form	long	No
OrganizationId	form	int	No
UserId	form	int	No
Type	form	PostType	No
CategoryId	form	int	No
Title	form	string	No
Slug	form	string	No
Url	form	string	No
ImageUrl	form	string	No
Content	form	string	No
ContentHtml	form	string	No
PinCommentId	form	long?	No
TechnologyIds	form	int[]	No
FromDate	form	DateTime?	No
ToDate	form	DateTime?	No
Location	form	string	No
MetaType	form	string	No
Meta	form	string	No
Approved	form	bool	No
UpVotes	form	long	No
DownVotes	form	long	No
Points	form	long	No
Views	form	long	No
Favorites	form	long	No
Subscribers	form	int	No
ReplyCount	form	int	No
CommentsCount	form	int	No
WordCount	form	int	No
ReportCount	form	int	No
LinksCount	form	int	No
LinkedToCount	form	int	No
Score	form	int	No
Rank	form	int	No
Labels	form	string[]	No
RefUserIds	form	int[]	No
RefLinks	form	string[]	No
MuteUserIds	form	int[]	No
LastCommentDate	form	DateTime?	No
LastCommentId	form	long?	No
LastCommentUserId	form	int?	No
Deleted	form	DateTime?	No
DeletedBy	form	string	No
Locked	form	DateTime?	No
LockedBy	form	string	No
Hidden	form	DateTime?	No
HiddenBy	form	string	No
Status	form	string	No
StatusDate	form	DateTime?	No
StatusBy	form	string	No
Archived	form	bool	No
Bumped	form	DateTime?	No
Created	form	DateTime	No
CreatedBy	form	string	No
Modified	form	DateTime	No
ModifiedBy	form	string	No
RefId	form	long?	No
RefSource	form	string	No
RefUrn	form	string	No

**PostType** Enum:
Announcement	Announcements
Post	Posts
Showcase	Showcase
Question	Questions
Request	Feature Requests

**QueryResponse<Post>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<Post>	No
Meta	form	Dictionary<string, string>	No
ResponseStatus	form	ResponseStatus	No

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