JiwaAPI

<back to all web services

SO_VInvQuery

Requires Authentication
SO_VInvQuery Parameters:
NameParameterData TypeRequiredDescription
InvoiceIDquerystringNo
InvoiceIDStartsWithquerystringNo
InvoiceIDEndsWithquerystringNo
InvoiceIDContainsquerystringNo
InvoiceIDLikequerystringNo
InvoiceIDBetweenquerystring[]No
InvoiceIDInquerystring[]No
InvIDquerystringNo
InvIDStartsWithquerystringNo
InvIDEndsWithquerystringNo
InvIDContainsquerystringNo
InvIDLikequerystringNo
InvIDBetweenquerystring[]No
InvIDInquerystring[]No
InvoiceNoquerystringNo
InvoiceNoStartsWithquerystringNo
InvoiceNoEndsWithquerystringNo
InvoiceNoContainsquerystringNo
InvoiceNoLikequerystringNo
InvoiceNoBetweenquerystring[]No
InvoiceNoInquerystring[]No
IN_LogicalIDquerystringNo
IN_LogicalIDStartsWithquerystringNo
IN_LogicalIDEndsWithquerystringNo
IN_LogicalIDContainsquerystringNo
IN_LogicalIDLikequerystringNo
IN_LogicalIDBetweenquerystring[]No
IN_LogicalIDInquerystring[]No
BillWhenCompletequeryshort?No
BillWhenCompleteGreaterThanOrEqualToqueryshort?No
BillWhenCompleteGreaterThanqueryshort?No
BillWhenCompleteLessThanqueryshort?No
BillWhenCompleteLessThanOrEqualToqueryshort?No
BillWhenCompleteNotEqualToqueryshort?No
BillWhenCompleteBetweenqueryshort[]No
BillWhenCompleteInqueryshort[]No
OrderNoquerystringNo
OrderNoStartsWithquerystringNo
OrderNoEndsWithquerystringNo
OrderNoContainsquerystringNo
OrderNoLikequerystringNo
OrderNoBetweenquerystring[]No
OrderNoInquerystring[]No
CreditNotequerybool?No
WholeSaleInvoicequerybool?No
TaxExemptNoquerystringNo
TaxExemptNoStartsWithquerystringNo
TaxExemptNoEndsWithquerystringNo
TaxExemptNoContainsquerystringNo
TaxExemptNoLikequerystringNo
TaxExemptNoBetweenquerystring[]No
TaxExemptNoInquerystring[]No
Statusqueryshort?No
StatusGreaterThanOrEqualToqueryshort?No
StatusGreaterThanqueryshort?No
StatusLessThanqueryshort?No
StatusLessThanOrEqualToqueryshort?No
StatusNotEqualToqueryshort?No
StatusBetweenqueryNullable<Int16>[]No
StatusInqueryNullable<Int16>[]No
StaffIDquerystringNo
StaffIDStartsWithquerystringNo
StaffIDEndsWithquerystringNo
StaffIDContainsquerystringNo
StaffIDLikequerystringNo
StaffIDBetweenquerystring[]No
StaffIDInquerystring[]No
BranchIDquerystringNo
BranchIDStartsWithquerystringNo
BranchIDEndsWithquerystringNo
BranchIDContainsquerystringNo
BranchIDLikequerystringNo
BranchIDBetweenquerystring[]No
BranchIDInquerystring[]No
CreditIntoStockquerybool?No
InvoiceHistoryIDquerystringNo
InvoiceHistoryIDStartsWithquerystringNo
InvoiceHistoryIDEndsWithquerystringNo
InvoiceHistoryIDContainsquerystringNo
InvoiceHistoryIDLikequerystringNo
InvoiceHistoryIDBetweenquerystring[]No
InvoiceHistoryIDInquerystring[]No
HistoryTotalquerydecimal?No
HistoryTotalGreaterThanOrEqualToquerydecimal?No
HistoryTotalGreaterThanquerydecimal?No
HistoryTotalLessThanquerydecimal?No
HistoryTotalLessThanOrEqualToquerydecimal?No
HistoryTotalNotEqualToquerydecimal?No
HistoryTotalBetweenqueryNullable<Decimal>[]No
HistoryTotalInqueryNullable<Decimal>[]No
CartageCharge1querydecimal?No
CartageCharge1GreaterThanOrEqualToquerydecimal?No
CartageCharge1GreaterThanquerydecimal?No
CartageCharge1LessThanquerydecimal?No
CartageCharge1LessThanOrEqualToquerydecimal?No
CartageCharge1NotEqualToquerydecimal?No
CartageCharge1BetweenqueryNullable<Decimal>[]No
CartageCharge1InqueryNullable<Decimal>[]No
CartageCharge2querydecimal?No
CartageCharge2GreaterThanOrEqualToquerydecimal?No
CartageCharge2GreaterThanquerydecimal?No
CartageCharge2LessThanquerydecimal?No
CartageCharge2LessThanOrEqualToquerydecimal?No
CartageCharge2NotEqualToquerydecimal?No
CartageCharge2BetweenqueryNullable<Decimal>[]No
CartageCharge2InqueryNullable<Decimal>[]No
CartageCharge3querydecimal?No
CartageCharge3GreaterThanOrEqualToquerydecimal?No
CartageCharge3GreaterThanquerydecimal?No
CartageCharge3LessThanquerydecimal?No
CartageCharge3LessThanOrEqualToquerydecimal?No
CartageCharge3NotEqualToquerydecimal?No
CartageCharge3BetweenqueryNullable<Decimal>[]No
CartageCharge3InqueryNullable<Decimal>[]No
Frieghtquerydecimal?No
FrieghtGreaterThanOrEqualToquerydecimal?No
FrieghtGreaterThanquerydecimal?No
FrieghtLessThanquerydecimal?No
FrieghtLessThanOrEqualToquerydecimal?No
FrieghtNotEqualToquerydecimal?No
FrieghtBetweenqueryNullable<Decimal>[]No
FrieghtInqueryNullable<Decimal>[]No
Frtquerydecimal?No
FrtGreaterThanOrEqualToquerydecimal?No
FrtGreaterThanquerydecimal?No
FrtLessThanquerydecimal?No
FrtLessThanOrEqualToquerydecimal?No
FrtNotEqualToquerydecimal?No
FrtBetweenqueryNullable<Decimal>[]No
FrtInqueryNullable<Decimal>[]No
FrtTaxquerydecimal?No
FrtTaxGreaterThanOrEqualToquerydecimal?No
FrtTaxGreaterThanquerydecimal?No
FrtTaxLessThanquerydecimal?No
FrtTaxLessThanOrEqualToquerydecimal?No
FrtTaxNotEqualToquerydecimal?No
FrtTaxBetweenqueryNullable<Decimal>[]No
FrtTaxInqueryNullable<Decimal>[]No
ProHistoryNoqueryshort?No
ProHistoryNoGreaterThanOrEqualToqueryshort?No
ProHistoryNoGreaterThanqueryshort?No
ProHistoryNoLessThanqueryshort?No
ProHistoryNoLessThanOrEqualToqueryshort?No
ProHistoryNoNotEqualToqueryshort?No
ProHistoryNoBetweenqueryNullable<Int16>[]No
ProHistoryNoInqueryNullable<Int16>[]No
InvHistoryNoqueryshort?No
InvHistoryNoGreaterThanOrEqualToqueryshort?No
InvHistoryNoGreaterThanqueryshort?No
InvHistoryNoLessThanqueryshort?No
InvHistoryNoLessThanOrEqualToqueryshort?No
InvHistoryNoNotEqualToqueryshort?No
InvHistoryNoBetweenqueryNullable<Int16>[]No
InvHistoryNoInqueryNullable<Int16>[]No
ProRunNoquerystringNo
ProRunNoStartsWithquerystringNo
ProRunNoEndsWithquerystringNo
ProRunNoContainsquerystringNo
ProRunNoLikequerystringNo
ProRunNoBetweenquerystring[]No
ProRunNoInquerystring[]No
InvRunNoquerystringNo
InvRunNoStartsWithquerystringNo
InvRunNoEndsWithquerystringNo
InvRunNoContainsquerystringNo
InvRunNoLikequerystringNo
InvRunNoBetweenquerystring[]No
InvRunNoInquerystring[]No
ProDatequeryDateTime?No
ProDateGreaterThanOrEqualToqueryDateTime?No
ProDateGreaterThanqueryDateTime?No
ProDateLessThanqueryDateTime?No
ProDateLessThanOrEqualToqueryDateTime?No
ProDateNotEqualToqueryDateTime?No
ProDateBetweenqueryNullable<DateTime>[]No
ProDateInqueryNullable<DateTime>[]No
InvDatequeryDateTime?No
InvDateGreaterThanOrEqualToqueryDateTime?No
InvDateGreaterThanqueryDateTime?No
InvDateLessThanqueryDateTime?No
InvDateLessThanOrEqualToqueryDateTime?No
InvDateNotEqualToqueryDateTime?No
InvDateBetweenqueryNullable<DateTime>[]No
InvDateInqueryNullable<DateTime>[]No
InvoiceLineIDquerystringNo
InvoiceLineIDStartsWithquerystringNo
InvoiceLineIDEndsWithquerystringNo
InvoiceLineIDContainsquerystringNo
InvoiceLineIDLikequerystringNo
InvoiceLineIDBetweenquerystring[]No
InvoiceLineIDInquerystring[]No
InventoryIDquerystringNo
InventoryIDStartsWithquerystringNo
InventoryIDEndsWithquerystringNo
InventoryIDContainsquerystringNo
InventoryIDLikequerystringNo
InventoryIDBetweenquerystring[]No
InventoryIDInquerystring[]No
PartNoquerystringNo
PartNoStartsWithquerystringNo
PartNoEndsWithquerystringNo
PartNoContainsquerystringNo
PartNoLikequerystringNo
PartNoBetweenquerystring[]No
PartNoInquerystring[]No
DescriptionquerystringNo
DescriptionStartsWithquerystringNo
DescriptionEndsWithquerystringNo
DescriptionContainsquerystringNo
DescriptionLikequerystringNo
DescriptionBetweenquerystring[]No
DescriptionInquerystring[]No
JobIDquerystringNo
JobIDStartsWithquerystringNo
JobIDEndsWithquerystringNo
JobIDContainsquerystringNo
JobIDLikequerystringNo
JobIDBetweenquerystring[]No
JobIDInquerystring[]No
CostInquerydecimal?No
CostInGreaterThanOrEqualToquerydecimal?No
CostInGreaterThanquerydecimal?No
CostInLessThanquerydecimal?No
CostInLessThanOrEqualToquerydecimal?No
CostInNotEqualToquerydecimal?No
CostInBetweenqueryNullable<Decimal>[]No
CostInInqueryNullable<Decimal>[]No
QuantityThisDelquerydecimal?No
QuantityThisDelGreaterThanOrEqualToquerydecimal?No
QuantityThisDelGreaterThanquerydecimal?No
QuantityThisDelLessThanquerydecimal?No
QuantityThisDelLessThanOrEqualToquerydecimal?No
QuantityThisDelNotEqualToquerydecimal?No
QuantityThisDelBetweenqueryNullable<Decimal>[]No
QuantityThisDelInqueryNullable<Decimal>[]No
CurrentLineTotalquerydecimal?No
CurrentLineTotalGreaterThanOrEqualToquerydecimal?No
CurrentLineTotalGreaterThanquerydecimal?No
CurrentLineTotalLessThanquerydecimal?No
CurrentLineTotalLessThanOrEqualToquerydecimal?No
CurrentLineTotalNotEqualToquerydecimal?No
CurrentLineTotalBetweenqueryNullable<Decimal>[]No
CurrentLineTotalInqueryNullable<Decimal>[]No
TaxToChargequerydecimal?No
TaxToChargeGreaterThanOrEqualToquerydecimal?No
TaxToChargeGreaterThanquerydecimal?No
TaxToChargeLessThanquerydecimal?No
TaxToChargeLessThanOrEqualToquerydecimal?No
TaxToChargeNotEqualToquerydecimal?No
TaxToChargeBetweenqueryNullable<Decimal>[]No
TaxToChargeInqueryNullable<Decimal>[]No
TaxPaidquerydecimal?No
TaxPaidGreaterThanOrEqualToquerydecimal?No
TaxPaidGreaterThanquerydecimal?No
TaxPaidLessThanquerydecimal?No
TaxPaidLessThanOrEqualToquerydecimal?No
TaxPaidNotEqualToquerydecimal?No
TaxPaidBetweenqueryNullable<Decimal>[]No
TaxPaidInqueryNullable<Decimal>[]No
DecimalPlacesqueryshort?No
DecimalPlacesGreaterThanOrEqualToqueryshort?No
DecimalPlacesGreaterThanqueryshort?No
DecimalPlacesLessThanqueryshort?No
DecimalPlacesLessThanOrEqualToqueryshort?No
DecimalPlacesNotEqualToqueryshort?No
DecimalPlacesBetweenqueryNullable<Int16>[]No
DecimalPlacesInqueryNullable<Int16>[]No
TaxIDquerystringNo
TaxIDStartsWithquerystringNo
TaxIDEndsWithquerystringNo
TaxIDContainsquerystringNo
TaxIDLikequerystringNo
TaxIDBetweenquerystring[]No
TaxIDInquerystring[]No
PhysicalItemqueryshort?No
PhysicalItemGreaterThanOrEqualToqueryshort?No
PhysicalItemGreaterThanqueryshort?No
PhysicalItemLessThanqueryshort?No
PhysicalItemLessThanOrEqualToqueryshort?No
PhysicalItemNotEqualToqueryshort?No
PhysicalItemBetweenqueryNullable<Int16>[]No
PhysicalItemInqueryNullable<Int16>[]No
NonStockquerybool?No
ClassDescriptionquerystringNo
ClassDescriptionStartsWithquerystringNo
ClassDescriptionEndsWithquerystringNo
ClassDescriptionContainsquerystringNo
ClassDescriptionLikequerystringNo
ClassDescriptionBetweenquerystring[]No
ClassDescriptionInquerystring[]No
DebtorIDquerystringNo
DebtorIDStartsWithquerystringNo
DebtorIDEndsWithquerystringNo
DebtorIDContainsquerystringNo
DebtorIDLikequerystringNo
DebtorIDBetweenquerystring[]No
DebtorIDInquerystring[]No
AccountNoquerystringNo
AccountNoStartsWithquerystringNo
AccountNoEndsWithquerystringNo
AccountNoContainsquerystringNo
AccountNoLikequerystringNo
AccountNoBetweenquerystring[]No
AccountNoInquerystring[]No
NamequerystringNo
NameStartsWithquerystringNo
NameEndsWithquerystringNo
NameContainsquerystringNo
NameLikequerystringNo
NameBetweenquerystring[]No
NameInquerystring[]No
LineCostquerydecimal?No
LineCostGreaterThanOrEqualToquerydecimal?No
LineCostGreaterThanquerydecimal?No
LineCostLessThanquerydecimal?No
LineCostLessThanOrEqualToquerydecimal?No
LineCostNotEqualToquerydecimal?No
LineCostBetweenqueryNullable<Decimal>[]No
LineCostInqueryNullable<Decimal>[]No
Cat1DescriptionquerystringNo
Cat1DescriptionStartsWithquerystringNo
Cat1DescriptionEndsWithquerystringNo
Cat1DescriptionContainsquerystringNo
Cat1DescriptionLikequerystringNo
Cat1DescriptionBetweenquerystring[]No
Cat1DescriptionInquerystring[]No
Cat2DescriptionquerystringNo
Cat2DescriptionStartsWithquerystringNo
Cat2DescriptionEndsWithquerystringNo
Cat2DescriptionContainsquerystringNo
Cat2DescriptionLikequerystringNo
Cat2DescriptionBetweenquerystring[]No
Cat2DescriptionInquerystring[]No
Cat3DescriptionquerystringNo
Cat3DescriptionStartsWithquerystringNo
Cat3DescriptionEndsWithquerystringNo
Cat3DescriptionContainsquerystringNo
Cat3DescriptionLikequerystringNo
Cat3DescriptionBetweenquerystring[]No
Cat3DescriptionInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SO_VInv Parameters:
NameParameterData TypeRequiredDescription
InvoiceIDformstringNo
InvIDformstringNo
InvoiceNoformstringNo
IN_LogicalIDformstringNo
BillWhenCompleteformshortNo
OrderNoformstringNo
CreditNoteformboolNo
WholeSaleInvoiceformboolNo
TaxExemptNoformstringNo
Statusformshort?No
StaffIDformstringNo
BranchIDformstringNo
CreditIntoStockformboolNo
InvoiceHistoryIDformstringNo
HistoryTotalformdecimal?No
CartageCharge1formdecimal?No
CartageCharge2formdecimal?No
CartageCharge3formdecimal?No
Frieghtformdecimal?No
Frtformdecimal?No
FrtTaxformdecimal?No
ProHistoryNoformshort?No
InvHistoryNoformshort?No
ProRunNoformstringNo
InvRunNoformstringNo
ProDateformDateTime?No
InvDateformDateTime?No
InvoiceLineIDformstringNo
InventoryIDformstringNo
PartNoformstringNo
DescriptionformstringNo
JobIDformstringNo
CostInformdecimal?No
QuantityThisDelformdecimal?No
CurrentLineTotalformdecimal?No
TaxToChargeformdecimal?No
TaxPaidformdecimal?No
DecimalPlacesformshort?No
TaxIDformstringNo
PhysicalItemformshort?No
NonStockformbool?No
ClassDescriptionformstringNo
DebtorIDformstringNo
AccountNoformstringNo
NameformstringNo
LineCostformdecimal?No
Cat1DescriptionformstringNo
Cat2DescriptionformstringNo
Cat3DescriptionformstringNo
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 .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.

POST /csv/reply/SO_VInvQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"InvoiceID":"String","InvoiceIDStartsWith":"String","InvoiceIDEndsWith":"String","InvoiceIDContains":"String","InvoiceIDLike":"String","InvoiceIDBetween":["String"],"InvoiceIDIn":["String"],"InvID":"String","InvIDStartsWith":"String","InvIDEndsWith":"String","InvIDContains":"String","InvIDLike":"String","InvIDBetween":["String"],"InvIDIn":["String"],"InvoiceNo":"String","InvoiceNoStartsWith":"String","InvoiceNoEndsWith":"String","InvoiceNoContains":"String","InvoiceNoLike":"String","InvoiceNoBetween":["String"],"InvoiceNoIn":["String"],"IN_LogicalID":"String","IN_LogicalIDStartsWith":"String","IN_LogicalIDEndsWith":"String","IN_LogicalIDContains":"String","IN_LogicalIDLike":"String","IN_LogicalIDBetween":["String"],"IN_LogicalIDIn":["String"],"BillWhenComplete":0,"BillWhenCompleteGreaterThanOrEqualTo":0,"BillWhenCompleteGreaterThan":0,"BillWhenCompleteLessThan":0,"BillWhenCompleteLessThanOrEqualTo":0,"BillWhenCompleteNotEqualTo":0,"BillWhenCompleteBetween":[0],"BillWhenCompleteIn":[0],"OrderNo":"String","OrderNoStartsWith":"String","OrderNoEndsWith":"String","OrderNoContains":"String","OrderNoLike":"String","OrderNoBetween":["String"],"OrderNoIn":["String"],"CreditNote":false,"WholeSaleInvoice":false,"TaxExemptNo":"String","TaxExemptNoStartsWith":"String","TaxExemptNoEndsWith":"String","TaxExemptNoContains":"String","TaxExemptNoLike":"String","TaxExemptNoBetween":["String"],"TaxExemptNoIn":["String"],"Status":0,"StatusGreaterThanOrEqualTo":0,"StatusGreaterThan":0,"StatusLessThan":0,"StatusLessThanOrEqualTo":0,"StatusNotEqualTo":0,"StatusBetween":[0],"StatusIn":[0],"StaffID":"String","StaffIDStartsWith":"String","StaffIDEndsWith":"String","StaffIDContains":"String","StaffIDLike":"String","StaffIDBetween":["String"],"StaffIDIn":["String"],"BranchID":"String","BranchIDStartsWith":"String","BranchIDEndsWith":"String","BranchIDContains":"String","BranchIDLike":"String","BranchIDBetween":["String"],"BranchIDIn":["String"],"CreditIntoStock":false,"InvoiceHistoryID":"String","InvoiceHistoryIDStartsWith":"String","InvoiceHistoryIDEndsWith":"String","InvoiceHistoryIDContains":"String","InvoiceHistoryIDLike":"String","InvoiceHistoryIDBetween":["String"],"InvoiceHistoryIDIn":["String"],"HistoryTotal":0,"HistoryTotalGreaterThanOrEqualTo":0,"HistoryTotalGreaterThan":0,"HistoryTotalLessThan":0,"HistoryTotalLessThanOrEqualTo":0,"HistoryTotalNotEqualTo":0,"HistoryTotalBetween":[0],"HistoryTotalIn":[0],"CartageCharge1":0,"CartageCharge1GreaterThanOrEqualTo":0,"CartageCharge1GreaterThan":0,"CartageCharge1LessThan":0,"CartageCharge1LessThanOrEqualTo":0,"CartageCharge1NotEqualTo":0,"CartageCharge1Between":[0],"CartageCharge1In":[0],"CartageCharge2":0,"CartageCharge2GreaterThanOrEqualTo":0,"CartageCharge2GreaterThan":0,"CartageCharge2LessThan":0,"CartageCharge2LessThanOrEqualTo":0,"CartageCharge2NotEqualTo":0,"CartageCharge2Between":[0],"CartageCharge2In":[0],"CartageCharge3":0,"CartageCharge3GreaterThanOrEqualTo":0,"CartageCharge3GreaterThan":0,"CartageCharge3LessThan":0,"CartageCharge3LessThanOrEqualTo":0,"CartageCharge3NotEqualTo":0,"CartageCharge3Between":[0],"CartageCharge3In":[0],"Frieght":0,"FrieghtGreaterThanOrEqualTo":0,"FrieghtGreaterThan":0,"FrieghtLessThan":0,"FrieghtLessThanOrEqualTo":0,"FrieghtNotEqualTo":0,"FrieghtBetween":[0],"FrieghtIn":[0],"Frt":0,"FrtGreaterThanOrEqualTo":0,"FrtGreaterThan":0,"FrtLessThan":0,"FrtLessThanOrEqualTo":0,"FrtNotEqualTo":0,"FrtBetween":[0],"FrtIn":[0],"FrtTax":0,"FrtTaxGreaterThanOrEqualTo":0,"FrtTaxGreaterThan":0,"FrtTaxLessThan":0,"FrtTaxLessThanOrEqualTo":0,"FrtTaxNotEqualTo":0,"FrtTaxBetween":[0],"FrtTaxIn":[0],"ProHistoryNo":0,"ProHistoryNoGreaterThanOrEqualTo":0,"ProHistoryNoGreaterThan":0,"ProHistoryNoLessThan":0,"ProHistoryNoLessThanOrEqualTo":0,"ProHistoryNoNotEqualTo":0,"ProHistoryNoBetween":[0],"ProHistoryNoIn":[0],"InvHistoryNo":0,"InvHistoryNoGreaterThanOrEqualTo":0,"InvHistoryNoGreaterThan":0,"InvHistoryNoLessThan":0,"InvHistoryNoLessThanOrEqualTo":0,"InvHistoryNoNotEqualTo":0,"InvHistoryNoBetween":[0],"InvHistoryNoIn":[0],"ProRunNo":"String","ProRunNoStartsWith":"String","ProRunNoEndsWith":"String","ProRunNoContains":"String","ProRunNoLike":"String","ProRunNoBetween":["String"],"ProRunNoIn":["String"],"InvRunNo":"String","InvRunNoStartsWith":"String","InvRunNoEndsWith":"String","InvRunNoContains":"String","InvRunNoLike":"String","InvRunNoBetween":["String"],"InvRunNoIn":["String"],"ProDate":"0001-01-01T00:00:00.0000000","ProDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ProDateGreaterThan":"0001-01-01T00:00:00.0000000","ProDateLessThan":"0001-01-01T00:00:00.0000000","ProDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ProDateNotEqualTo":"0001-01-01T00:00:00.0000000","ProDateBetween":["0001-01-01T00:00:00.0000000"],"ProDateIn":["0001-01-01T00:00:00.0000000"],"InvDate":"0001-01-01T00:00:00.0000000","InvDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","InvDateGreaterThan":"0001-01-01T00:00:00.0000000","InvDateLessThan":"0001-01-01T00:00:00.0000000","InvDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","InvDateNotEqualTo":"0001-01-01T00:00:00.0000000","InvDateBetween":["0001-01-01T00:00:00.0000000"],"InvDateIn":["0001-01-01T00:00:00.0000000"],"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"InventoryID":"String","InventoryIDStartsWith":"String","InventoryIDEndsWith":"String","InventoryIDContains":"String","InventoryIDLike":"String","InventoryIDBetween":["String"],"InventoryIDIn":["String"],"PartNo":"String","PartNoStartsWith":"String","PartNoEndsWith":"String","PartNoContains":"String","PartNoLike":"String","PartNoBetween":["String"],"PartNoIn":["String"],"Description":"String","DescriptionStartsWith":"String","DescriptionEndsWith":"String","DescriptionContains":"String","DescriptionLike":"String","DescriptionBetween":["String"],"DescriptionIn":["String"],"JobID":"String","JobIDStartsWith":"String","JobIDEndsWith":"String","JobIDContains":"String","JobIDLike":"String","JobIDBetween":["String"],"JobIDIn":["String"],"CostIn":0,"CostInGreaterThanOrEqualTo":0,"CostInGreaterThan":0,"CostInLessThan":0,"CostInLessThanOrEqualTo":0,"CostInNotEqualTo":0,"CostInBetween":[0],"CostInIn":[0],"QuantityThisDel":0,"QuantityThisDelGreaterThanOrEqualTo":0,"QuantityThisDelGreaterThan":0,"QuantityThisDelLessThan":0,"QuantityThisDelLessThanOrEqualTo":0,"QuantityThisDelNotEqualTo":0,"QuantityThisDelBetween":[0],"QuantityThisDelIn":[0],"CurrentLineTotal":0,"CurrentLineTotalGreaterThanOrEqualTo":0,"CurrentLineTotalGreaterThan":0,"CurrentLineTotalLessThan":0,"CurrentLineTotalLessThanOrEqualTo":0,"CurrentLineTotalNotEqualTo":0,"CurrentLineTotalBetween":[0],"CurrentLineTotalIn":[0],"TaxToCharge":0,"TaxToChargeGreaterThanOrEqualTo":0,"TaxToChargeGreaterThan":0,"TaxToChargeLessThan":0,"TaxToChargeLessThanOrEqualTo":0,"TaxToChargeNotEqualTo":0,"TaxToChargeBetween":[0],"TaxToChargeIn":[0],"TaxPaid":0,"TaxPaidGreaterThanOrEqualTo":0,"TaxPaidGreaterThan":0,"TaxPaidLessThan":0,"TaxPaidLessThanOrEqualTo":0,"TaxPaidNotEqualTo":0,"TaxPaidBetween":[0],"TaxPaidIn":[0],"DecimalPlaces":0,"DecimalPlacesGreaterThanOrEqualTo":0,"DecimalPlacesGreaterThan":0,"DecimalPlacesLessThan":0,"DecimalPlacesLessThanOrEqualTo":0,"DecimalPlacesNotEqualTo":0,"DecimalPlacesBetween":[0],"DecimalPlacesIn":[0],"TaxID":"String","TaxIDStartsWith":"String","TaxIDEndsWith":"String","TaxIDContains":"String","TaxIDLike":"String","TaxIDBetween":["String"],"TaxIDIn":["String"],"PhysicalItem":0,"PhysicalItemGreaterThanOrEqualTo":0,"PhysicalItemGreaterThan":0,"PhysicalItemLessThan":0,"PhysicalItemLessThanOrEqualTo":0,"PhysicalItemNotEqualTo":0,"PhysicalItemBetween":[0],"PhysicalItemIn":[0],"NonStock":false,"ClassDescription":"String","ClassDescriptionStartsWith":"String","ClassDescriptionEndsWith":"String","ClassDescriptionContains":"String","ClassDescriptionLike":"String","ClassDescriptionBetween":["String"],"ClassDescriptionIn":["String"],"DebtorID":"String","DebtorIDStartsWith":"String","DebtorIDEndsWith":"String","DebtorIDContains":"String","DebtorIDLike":"String","DebtorIDBetween":["String"],"DebtorIDIn":["String"],"AccountNo":"String","AccountNoStartsWith":"String","AccountNoEndsWith":"String","AccountNoContains":"String","AccountNoLike":"String","AccountNoBetween":["String"],"AccountNoIn":["String"],"Name":"String","NameStartsWith":"String","NameEndsWith":"String","NameContains":"String","NameLike":"String","NameBetween":["String"],"NameIn":["String"],"LineCost":0,"LineCostGreaterThanOrEqualTo":0,"LineCostGreaterThan":0,"LineCostLessThan":0,"LineCostLessThanOrEqualTo":0,"LineCostNotEqualTo":0,"LineCostBetween":[0],"LineCostIn":[0],"Cat1Description":"String","Cat1DescriptionStartsWith":"String","Cat1DescriptionEndsWith":"String","Cat1DescriptionContains":"String","Cat1DescriptionLike":"String","Cat1DescriptionBetween":["String"],"Cat1DescriptionIn":["String"],"Cat2Description":"String","Cat2DescriptionStartsWith":"String","Cat2DescriptionEndsWith":"String","Cat2DescriptionContains":"String","Cat2DescriptionLike":"String","Cat2DescriptionBetween":["String"],"Cat2DescriptionIn":["String"],"Cat3Description":"String","Cat3DescriptionStartsWith":"String","Cat3DescriptionEndsWith":"String","Cat3DescriptionContains":"String","Cat3DescriptionLike":"String","Cat3DescriptionBetween":["String"],"Cat3DescriptionIn":["String"],"Skip":0,"Take":0,"OrderBy":"String","OrderByDesc":"String","Include":"String","Fields":"String","Meta":{"String":"String"}}
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Results":[{"InvoiceID":"String","InvID":"String","InvoiceNo":"String","IN_LogicalID":"String","OrderNo":"String","TaxExemptNo":"String","Status":0,"StaffID":"String","BranchID":"String","InvoiceHistoryID":"String","HistoryTotal":0,"CartageCharge1":0,"CartageCharge2":0,"CartageCharge3":0,"Frieght":0,"Frt":0,"FrtTax":0,"ProHistoryNo":0,"InvHistoryNo":0,"ProRunNo":"String","InvRunNo":"String","ProDate":"0001-01-01T00:00:00.0000000","InvDate":"0001-01-01T00:00:00.0000000","InvoiceLineID":"String","InventoryID":"String","PartNo":"String","Description":"String","JobID":"String","CostIn":0,"QuantityThisDel":0,"CurrentLineTotal":0,"TaxToCharge":0,"TaxPaid":0,"DecimalPlaces":0,"TaxID":"String","PhysicalItem":0,"NonStock":false,"ClassDescription":"String","DebtorID":"String","AccountNo":"String","Name":"String","LineCost":0,"Cat1Description":"String","Cat2Description":"String","Cat3Description":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}