EMUN1 ASP.NET

DbRequest

**Requires Authentication**
Required roles:	Administrator, Administrator

The following routes are available for this service:
All Verbs	/service/db
All Verbs	/service/db/{Table}
All Verbs	/service/db/{Table}/{Operation}

**DbRequest** Parameters:
Name	Parameter	Data Type	Required
Table	path	string	No
Operation	path	DbOp	No
Payload	query	string	No
Fields	query	string	No
Skip	query	int?	No
Take	query	int?	No
OrderBy	query	string	No
OrderByDesc	query	string	No
Include	query	string	No
UsePayload	query	bool	No
Meta	query	Dictionary<string, string>	No

**DbResponse** Parameters:
Name	Parameter	Data Type	Required
Inserted	form	long?	No
Updated	form	long?	No
Saved	form	long?	No
Deleted	form	long?	No
Operation	form	DbOp	No
Table	form	string	No
Payload	form	string	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 .xml suffix or ?format=xml

HTTP + XML

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

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

<DbRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Emun.Data">
  <Fields>String</Fields>
  <Include>String</Include>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <Operation>ResolveKeys</Operation>
  <OrderBy>String</OrderBy>
  <OrderByDesc>String</OrderByDesc>
  <Payload i:nil="true" />
  <Skip>0</Skip>
  <Table>String</Table>
  <Take>0</Take>
  <UsePayload>false</UsePayload>
</DbRequest>

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

<DbResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Emun.Data">
  <Offset xmlns="http://schemas.servicestack.net/types">0</Offset>
  <Total xmlns="http://schemas.servicestack.net/types">0</Total>
  <Results xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
    <d2p1:anyType />
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus xmlns="http://schemas.servicestack.net/types">
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
  <Deleted>0</Deleted>
  <Inserted>0</Inserted>
  <Operation>Select</Operation>
  <Payload>String</Payload>
  <Saved>0</Saved>
  <Table>String</Table>
  <Updated>0</Updated>
</DbResponse>