EMUN1 ASP.NET

QueryTableAudit

The following routes are available for this service:
All Verbs	/service/QueryTableAudit

**QueryTableAudit** Parameters:
Name	Parameter	Data Type	Required	Description
Search	query	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

**TableAudit** Parameters:
Name	Parameter	Data Type	Required
Id	form	string	No
TableName	form	string	No
FieldName	form	string	No
ChangeOn	form	DateTime?	No
OldValue	form	string	No
NewValue	form	string	No
isNewAudit	form	bool?	No
KeyField	form	string	No
UserName	form	string	No
KeyField2	form	string	No

**EntityBase<K>** Parameters:
Name	Parameter	Data Type	Required	Description
Id	form	K	No

**QueryResponse<T>** Parameters:
Name	Parameter	Data Type	Required
Offset	form	int	No
Total	form	int	No
Results	form	List<T>	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 .other suffix or ?format=other

HTTP + OTHER

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /service/QueryTableAudit HTTP/1.1 
Host: www.bernhardthospitality.com 
Accept: application/xlsx
Content-Type: application/xlsx
Content-Length: length

{"search":"String","skip":0,"take":0,"orderBy":"String","orderByDesc":"String","include":"String","fields":"String","meta":{"String":"String"}}

HTTP/1.1 200 OK
Content-Type: application/xlsx
Content-Length: length

{"offset":0,"total":0,"results":[{"id":"String","tableName":"String","fieldName":"String","changeOn":"0001-01-01T00:00:00.0000000Z","oldValue":"String","newValue":"String","isNewAudit":false,"keyField":"String","userName":"String","keyField2":"String"}],"meta":{"String":"String"},"responseStatus":{"errorCode":"String","message":"String","stackTrace":"String","errors":[{"errorCode":"String","fieldName":"String","message":"String","meta":{"String":"String"}}],"meta":{"String":"String"}}}