JiwaAPI

<back to all web services

QO_MainQuery

Requires Authentication
The following routes are available for this service:
GET/Queries/QO_MainRetrieves a list of sales quotes.
QO_MainQuery Parameters:
NameParameterData TypeRequiredDescription
InvoiceIDquerystringNo
InvoiceIDStartsWithquerystringNo
InvoiceIDEndsWithquerystringNo
InvoiceIDContainsquerystringNo
InvoiceIDLikequerystringNo
InvoiceIDBetweenquerystring[]No
InvoiceIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
DebtorIDquerystringNo
DebtorIDStartsWithquerystringNo
DebtorIDEndsWithquerystringNo
DebtorIDContainsquerystringNo
DebtorIDLikequerystringNo
DebtorIDBetweenquerystring[]No
DebtorIDInquerystring[]No
StaffIDquerystringNo
StaffIDStartsWithquerystringNo
StaffIDEndsWithquerystringNo
StaffIDContainsquerystringNo
StaffIDLikequerystringNo
StaffIDBetweenquerystring[]No
StaffIDInquerystring[]No
InvoiceNoquerystringNo
InvoiceNoStartsWithquerystringNo
InvoiceNoEndsWithquerystringNo
InvoiceNoContainsquerystringNo
InvoiceNoLikequerystringNo
InvoiceNoBetweenquerystring[]No
InvoiceNoInquerystring[]No
InvoiceInitDatequeryDateTime?No
InvoiceInitDateGreaterThanOrEqualToqueryDateTime?No
InvoiceInitDateGreaterThanqueryDateTime?No
InvoiceInitDateLessThanqueryDateTime?No
InvoiceInitDateLessThanOrEqualToqueryDateTime?No
InvoiceInitDateNotEqualToqueryDateTime?No
InvoiceInitDateBetweenqueryDateTime[]No
InvoiceInitDateInqueryDateTime[]No
InvoiceLastDatequeryDateTime?No
InvoiceLastDateGreaterThanOrEqualToqueryDateTime?No
InvoiceLastDateGreaterThanqueryDateTime?No
InvoiceLastDateLessThanqueryDateTime?No
InvoiceLastDateLessThanOrEqualToqueryDateTime?No
InvoiceLastDateNotEqualToqueryDateTime?No
InvoiceLastDateBetweenqueryDateTime[]No
InvoiceLastDateInqueryDateTime[]No
OrderNoquerystringNo
OrderNoStartsWithquerystringNo
OrderNoEndsWithquerystringNo
OrderNoContainsquerystringNo
OrderNoLikequerystringNo
OrderNoBetweenquerystring[]No
OrderNoInquerystring[]No
TaxExemptNoquerystringNo
TaxExemptNoStartsWithquerystringNo
TaxExemptNoEndsWithquerystringNo
TaxExemptNoContainsquerystringNo
TaxExemptNoLikequerystringNo
TaxExemptNoBetweenquerystring[]No
TaxExemptNoInquerystring[]No
WholeSaleInvoicequerybool?No
InvoiceTotalquerydecimal?No
InvoiceTotalGreaterThanOrEqualToquerydecimal?No
InvoiceTotalGreaterThanquerydecimal?No
InvoiceTotalLessThanquerydecimal?No
InvoiceTotalLessThanOrEqualToquerydecimal?No
InvoiceTotalNotEqualToquerydecimal?No
InvoiceTotalBetweenqueryNullable<Decimal>[]No
InvoiceTotalInqueryNullable<Decimal>[]No
InvoicePrintedquerybool?No
CurrentHistoryNoqueryshort?No
CurrentHistoryNoGreaterThanOrEqualToqueryshort?No
CurrentHistoryNoGreaterThanqueryshort?No
CurrentHistoryNoLessThanqueryshort?No
CurrentHistoryNoLessThanOrEqualToqueryshort?No
CurrentHistoryNoNotEqualToqueryshort?No
CurrentHistoryNoBetweenqueryNullable<Int16>[]No
CurrentHistoryNoInqueryNullable<Int16>[]No
Statusqueryshort?No
StatusGreaterThanOrEqualToqueryshort?No
StatusGreaterThanqueryshort?No
StatusLessThanqueryshort?No
StatusLessThanOrEqualToqueryshort?No
StatusNotEqualToqueryshort?No
StatusBetweenqueryNullable<Int16>[]No
StatusInqueryNullable<Int16>[]No
BillWhenCompletequeryshort?No
BillWhenCompleteGreaterThanOrEqualToqueryshort?No
BillWhenCompleteGreaterThanqueryshort?No
BillWhenCompleteLessThanqueryshort?No
BillWhenCompleteLessThanOrEqualToqueryshort?No
BillWhenCompleteNotEqualToqueryshort?No
BillWhenCompleteBetweenqueryshort[]No
BillWhenCompleteInqueryshort[]No
InvoiceTypequeryshort?No
InvoiceTypeGreaterThanOrEqualToqueryshort?No
InvoiceTypeGreaterThanqueryshort?No
InvoiceTypeLessThanqueryshort?No
InvoiceTypeLessThanOrEqualToqueryshort?No
InvoiceTypeNotEqualToqueryshort?No
InvoiceTypeBetweenqueryNullable<Int16>[]No
InvoiceTypeInqueryNullable<Int16>[]No
GroupSupplierIDquerystringNo
GroupSupplierIDStartsWithquerystringNo
GroupSupplierIDEndsWithquerystringNo
GroupSupplierIDContainsquerystringNo
GroupSupplierIDLikequerystringNo
GroupSupplierIDBetweenquerystring[]No
GroupSupplierIDInquerystring[]No
GroupOrderedquerybool?No
IN_LogicalIDquerystringNo
IN_LogicalIDStartsWithquerystringNo
IN_LogicalIDEndsWithquerystringNo
IN_LogicalIDContainsquerystringNo
IN_LogicalIDLikequerystringNo
IN_LogicalIDBetweenquerystring[]No
IN_LogicalIDInquerystring[]No
BranchIDquerystringNo
BranchIDStartsWithquerystringNo
BranchIDEndsWithquerystringNo
BranchIDContainsquerystringNo
BranchIDLikequerystringNo
BranchIDBetweenquerystring[]No
BranchIDInquerystring[]No
QOReferencequerystringNo
QOReferenceStartsWithquerystringNo
QOReferenceEndsWithquerystringNo
QOReferenceContainsquerystringNo
QOReferenceLikequerystringNo
QOReferenceBetweenquerystring[]No
QOReferenceInquerystring[]No
JobCostIDquerystringNo
JobCostIDStartsWithquerystringNo
JobCostIDEndsWithquerystringNo
JobCostIDContainsquerystringNo
JobCostIDLikequerystringNo
JobCostIDBetweenquerystring[]No
JobCostIDInquerystring[]No
DocTypequeryint?No
DocTypeGreaterThanOrEqualToqueryint?No
DocTypeGreaterThanqueryint?No
DocTypeLessThanqueryint?No
DocTypeLessThanOrEqualToqueryint?No
DocTypeNotEqualToqueryint?No
DocTypeBetweenqueryint[]No
DocTypeInqueryint[]No
BackOrderModequeryshort?No
BackOrderModeGreaterThanOrEqualToqueryshort?No
BackOrderModeGreaterThanqueryshort?No
BackOrderModeLessThanqueryshort?No
BackOrderModeLessThanOrEqualToqueryshort?No
BackOrderModeNotEqualToqueryshort?No
BackOrderModeBetweenqueryshort[]No
BackOrderModeInqueryshort[]No
ExpectedDeliveryDatequeryDateTime?No
ExpectedDeliveryDateGreaterThanOrEqualToqueryDateTime?No
ExpectedDeliveryDateGreaterThanqueryDateTime?No
ExpectedDeliveryDateLessThanqueryDateTime?No
ExpectedDeliveryDateLessThanOrEqualToqueryDateTime?No
ExpectedDeliveryDateNotEqualToqueryDateTime?No
ExpectedDeliveryDateBetweenqueryNullable<DateTime>[]No
ExpectedDeliveryDateInqueryNullable<DateTime>[]No
DebtorContactNamequerystringNo
DebtorContactNameStartsWithquerystringNo
DebtorContactNameEndsWithquerystringNo
DebtorContactNameContainsquerystringNo
DebtorContactNameLikequerystringNo
DebtorContactNameBetweenquerystring[]No
DebtorContactNameInquerystring[]No
ParentDebtorIDquerystringNo
ParentDebtorIDStartsWithquerystringNo
ParentDebtorIDEndsWithquerystringNo
ParentDebtorIDContainsquerystringNo
ParentDebtorIDLikequerystringNo
ParentDebtorIDBetweenquerystring[]No
ParentDebtorIDInquerystring[]No
PriceSchemeIDquerystringNo
PriceSchemeIDStartsWithquerystringNo
PriceSchemeIDEndsWithquerystringNo
PriceSchemeIDContainsquerystringNo
PriceSchemeIDLikequerystringNo
PriceSchemeIDBetweenquerystring[]No
PriceSchemeIDInquerystring[]No
InvoiceEmailedquerybool?No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
QO_Main Parameters:
NameParameterData TypeRequiredDescription
InvoiceIDformstringNo
LastSavedDateTimeformDateTimeNo
DebtorIDformstringNo
StaffIDformstringNo
InvoiceNoformstringNo
InvoiceInitDateformDateTimeNo
InvoiceLastDateformDateTimeNo
OrderNoformstringNo
TaxExemptNoformstringNo
WholeSaleInvoiceformboolNo
InvoiceTotalformdecimal?No
InvoicePrintedformboolNo
CurrentHistoryNoformshort?No
Statusformshort?No
BillWhenCompleteformshortNo
InvoiceTypeformshort?No
GroupSupplierIDformstringNo
GroupOrderedformboolNo
IN_LogicalIDformstringNo
BranchIDformstringNo
QOReferenceformstringNo
JobCostIDformstringNo
DocTypeformintNo
BackOrderModeformshortNo
ExpectedDeliveryDateformDateTime?No
DebtorContactNameformstringNo
ParentDebtorIDformstringNo
PriceSchemeIDformstringNo
InvoiceEmailedformbool?No
QueryResponse<T> Parameters:
NameParameterData TypeRequiredDescription
OffsetformintNo
TotalformintNo
ResultsformList<T>No
MetaformDictionary<string, string>No
ResponseStatusformResponseStatusNo

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.

GET /Queries/QO_Main HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfQO_Main7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:QO_Main>
      <d2p1:_x003C_BackOrderMode_x003E_k__BackingField>0</d2p1:_x003C_BackOrderMode_x003E_k__BackingField>
      <d2p1:_x003C_BillWhenComplete_x003E_k__BackingField>0</d2p1:_x003C_BillWhenComplete_x003E_k__BackingField>
      <d2p1:_x003C_BranchID_x003E_k__BackingField>String</d2p1:_x003C_BranchID_x003E_k__BackingField>
      <d2p1:_x003C_CurrentHistoryNo_x003E_k__BackingField>0</d2p1:_x003C_CurrentHistoryNo_x003E_k__BackingField>
      <d2p1:_x003C_DebtorContactName_x003E_k__BackingField>String</d2p1:_x003C_DebtorContactName_x003E_k__BackingField>
      <d2p1:_x003C_DebtorID_x003E_k__BackingField>String</d2p1:_x003C_DebtorID_x003E_k__BackingField>
      <d2p1:_x003C_DocType_x003E_k__BackingField>0</d2p1:_x003C_DocType_x003E_k__BackingField>
      <d2p1:_x003C_ExpectedDeliveryDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_ExpectedDeliveryDate_x003E_k__BackingField>
      <d2p1:_x003C_GroupOrdered_x003E_k__BackingField>false</d2p1:_x003C_GroupOrdered_x003E_k__BackingField>
      <d2p1:_x003C_GroupSupplierID_x003E_k__BackingField>String</d2p1:_x003C_GroupSupplierID_x003E_k__BackingField>
      <d2p1:_x003C_IN_LogicalID_x003E_k__BackingField>String</d2p1:_x003C_IN_LogicalID_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceEmailed_x003E_k__BackingField>false</d2p1:_x003C_InvoiceEmailed_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceID_x003E_k__BackingField>String</d2p1:_x003C_InvoiceID_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceInitDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_InvoiceInitDate_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceLastDate_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_InvoiceLastDate_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceNo_x003E_k__BackingField>String</d2p1:_x003C_InvoiceNo_x003E_k__BackingField>
      <d2p1:_x003C_InvoicePrinted_x003E_k__BackingField>false</d2p1:_x003C_InvoicePrinted_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceTotal_x003E_k__BackingField>0</d2p1:_x003C_InvoiceTotal_x003E_k__BackingField>
      <d2p1:_x003C_InvoiceType_x003E_k__BackingField>0</d2p1:_x003C_InvoiceType_x003E_k__BackingField>
      <d2p1:_x003C_JobCostID_x003E_k__BackingField>String</d2p1:_x003C_JobCostID_x003E_k__BackingField>
      <d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_LastSavedDateTime_x003E_k__BackingField>
      <d2p1:_x003C_OrderNo_x003E_k__BackingField>String</d2p1:_x003C_OrderNo_x003E_k__BackingField>
      <d2p1:_x003C_ParentDebtorID_x003E_k__BackingField>String</d2p1:_x003C_ParentDebtorID_x003E_k__BackingField>
      <d2p1:_x003C_PriceSchemeID_x003E_k__BackingField>String</d2p1:_x003C_PriceSchemeID_x003E_k__BackingField>
      <d2p1:_x003C_QOReference_x003E_k__BackingField>String</d2p1:_x003C_QOReference_x003E_k__BackingField>
      <d2p1:_x003C_StaffID_x003E_k__BackingField>String</d2p1:_x003C_StaffID_x003E_k__BackingField>
      <d2p1:_x003C_Status_x003E_k__BackingField>0</d2p1:_x003C_Status_x003E_k__BackingField>
      <d2p1:_x003C_TaxExemptNo_x003E_k__BackingField>String</d2p1:_x003C_TaxExemptNo_x003E_k__BackingField>
      <d2p1:_x003C_WholeSaleInvoice_x003E_k__BackingField>false</d2p1:_x003C_WholeSaleInvoice_x003E_k__BackingField>
    </d2p1:QO_Main>
  </Results>
  <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>
  <ResponseStatus>
    <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>
</QueryResponseOfQO_Main7kRqkrSv>