POST api/Invoices/Search

Searches for Invoices in Sertica

Required Headers:
Authorization:
Depending on Website configuration use either
Basic Http Authorization with valid Sertica credentials
or
Windows Authentication (Negotiate) with either NTLM or Kerberos tickets

Request Information

URI Parameters

None.

Body Parameters

SearchDefinition

Name	Type	Additional information
Distinct	boolean	None.
IncludeSubObjects	boolean	None.
SubObjectsToInclude	Collection of string	None.
Contains	Collection of string	None.
Criteria	Collection of SearchCriteria	None.
Sorting	Collection of OrderBy	None.
Columns	Collection of string	None.
ForDeviceRequest	ForDeviceRequest	None.
UnitFilter	Collection of string	None.

Request Formats

application/json, text/json

Sample:

{
  "Distinct": true,
  "IncludeSubObjects": true,
  "SubObjectsToInclude": [
    "sample string 1",
    "sample string 2"
  ],
  "Contains": [
    "sample string 1",
    "sample string 2"
  ],
  "Criteria": [
    {
      "Field": "sample string 1",
      "Operator": "Equals",
      "Values": [
        {},
        {}
      ],
      "ValuesMatching": "All",
      "LogicalOperator": "And"
    },
    {
      "Field": "sample string 1",
      "Operator": "Equals",
      "Values": [
        {},
        {}
      ],
      "ValuesMatching": "All",
      "LogicalOperator": "And"
    }
  ],
  "Sorting": [
    {
      "Field": "sample string 1",
      "Direction": "Asc"
    },
    {
      "Field": "sample string 1",
      "Direction": "Asc"
    }
  ],
  "Columns": [
    "sample string 1",
    "sample string 2"
  ],
  "ForDeviceRequest": {
    "DeviceGuid": "75449d90-b868-40b2-a42c-b63269ea268a",
    "RequestIdGuid": "3d9e3fdb-f246-4a13-b1d2-d9dc2d52e241",
    "FullSynchronization": true,
    "AppType": 2
  },
  "UnitFilter": [
    "sample string 1",
    "sample string 2"
  ]
}

application/xml, text/xml

Sample:

<SearchDefinition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Distinct>true</Distinct>
  <SubObjectsToInclude>
    <string>sample string 1</string>
    <string>sample string 2</string>
  </SubObjectsToInclude>
  <Contains>
    <string>sample string 1</string>
    <string>sample string 2</string>
  </Contains>
  <Criteria>
    <SearchCriteria>
      <Field>sample string 1</Field>
      <Operator>Equals</Operator>
      <Values>
        <anyType />
        <anyType />
      </Values>
      <ValuesMatching>All</ValuesMatching>
    </SearchCriteria>
    <SearchCriteria>
      <Field>sample string 1</Field>
      <Operator>Equals</Operator>
      <Values>
        <anyType />
        <anyType />
      </Values>
      <ValuesMatching>All</ValuesMatching>
    </SearchCriteria>
  </Criteria>
  <Sorting>
    <OrderBy>
      <Field>sample string 1</Field>
      <Direction>Asc</Direction>
    </OrderBy>
    <OrderBy>
      <Field>sample string 1</Field>
      <Direction>Asc</Direction>
    </OrderBy>
  </Sorting>
  <Columns>
    <string>sample string 1</string>
    <string>sample string 2</string>
  </Columns>
  <ForDeviceRequest>
    <DeviceGuid>75449d90-b868-40b2-a42c-b63269ea268a</DeviceGuid>
    <RequestIdGuid>3d9e3fdb-f246-4a13-b1d2-d9dc2d52e241</RequestIdGuid>
    <FullSynchronization>true</FullSynchronization>
    <AppType>2</AppType>
  </ForDeviceRequest>
  <UnitFilter>
    <string>sample string 1</string>
    <string>sample string 2</string>
  </UnitFilter>
</SearchDefinition>

Response Information

Resource Description

HttpResponseMessage

Name	Type	Additional information
Version	Version	None.
Content	HttpContent	None.
StatusCode	HttpStatusCode	None.
ReasonPhrase	string	None.
Headers	Collection of Object	None.
RequestMessage	HttpRequestMessage	None.
IsSuccessStatusCode	boolean	None.