JiwaAPI

<back to all web services

QO_LineExtraQuery

Requires Authentication
QO_LineExtraQuery Parameters:
NameParameterData TypeRequiredDescription
SOLineExtraRecIDquerystringNo
SOLineExtraRecIDStartsWithquerystringNo
SOLineExtraRecIDEndsWithquerystringNo
SOLineExtraRecIDContainsquerystringNo
SOLineExtraRecIDLikequerystringNo
SOLineExtraRecIDBetweenquerystring[]No
SOLineExtraRecIDInquerystring[]No
InvoiceLineIDquerystringNo
InvoiceLineIDStartsWithquerystringNo
InvoiceLineIDEndsWithquerystringNo
InvoiceLineIDContainsquerystringNo
InvoiceLineIDLikequerystringNo
InvoiceLineIDBetweenquerystring[]No
InvoiceLineIDInquerystring[]No
InvoiceHistoryIDquerystringNo
InvoiceHistoryIDStartsWithquerystringNo
InvoiceHistoryIDEndsWithquerystringNo
InvoiceHistoryIDContainsquerystringNo
InvoiceHistoryIDLikequerystringNo
InvoiceHistoryIDBetweenquerystring[]No
InvoiceHistoryIDInquerystring[]No
LedgerReversePurchaseAccIDquerystringNo
LedgerReversePurchaseAccIDStartsWithquerystringNo
LedgerReversePurchaseAccIDEndsWithquerystringNo
LedgerReversePurchaseAccIDContainsquerystringNo
LedgerReversePurchaseAccIDLikequerystringNo
LedgerReversePurchaseAccIDBetweenquerystring[]No
LedgerReversePurchaseAccIDInquerystring[]No
LedgerMovement_COGAccIDquerystringNo
LedgerMovement_COGAccIDStartsWithquerystringNo
LedgerMovement_COGAccIDEndsWithquerystringNo
LedgerMovement_COGAccIDContainsquerystringNo
LedgerMovement_COGAccIDLikequerystringNo
LedgerMovement_COGAccIDBetweenquerystring[]No
LedgerMovement_COGAccIDInquerystring[]No
LedgerSalesAccIDquerystringNo
LedgerSalesAccIDStartsWithquerystringNo
LedgerSalesAccIDEndsWithquerystringNo
LedgerSalesAccIDContainsquerystringNo
LedgerSalesAccIDLikequerystringNo
LedgerSalesAccIDBetweenquerystring[]No
LedgerSalesAccIDInquerystring[]No
LedgerSalesReturnsAccIDquerystringNo
LedgerSalesReturnsAccIDStartsWithquerystringNo
LedgerSalesReturnsAccIDEndsWithquerystringNo
LedgerSalesReturnsAccIDContainsquerystringNo
LedgerSalesReturnsAccIDLikequerystringNo
LedgerSalesReturnsAccIDBetweenquerystring[]No
LedgerSalesReturnsAccIDInquerystring[]No
LedgerTaxLiabAccIDquerystringNo
LedgerTaxLiabAccIDStartsWithquerystringNo
LedgerTaxLiabAccIDEndsWithquerystringNo
LedgerTaxLiabAccIDContainsquerystringNo
LedgerTaxLiabAccIDLikequerystringNo
LedgerTaxLiabAccIDBetweenquerystring[]No
LedgerTaxLiabAccIDInquerystring[]No
LedgerTaxExpAccIDquerystringNo
LedgerTaxExpAccIDStartsWithquerystringNo
LedgerTaxExpAccIDEndsWithquerystringNo
LedgerTaxExpAccIDContainsquerystringNo
LedgerTaxExpAccIDLikequerystringNo
LedgerTaxExpAccIDBetweenquerystring[]No
LedgerTaxExpAccIDInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
QO_LineExtra Parameters:
NameParameterData TypeRequiredDescription
SOLineExtraRecIDformstringNo
InvoiceLineIDformstringNo
InvoiceHistoryIDformstringNo
LedgerReversePurchaseAccIDformstringNo
LedgerMovement_COGAccIDformstringNo
LedgerSalesAccIDformstringNo
LedgerSalesReturnsAccIDformstringNo
LedgerTaxLiabAccIDformstringNo
LedgerTaxExpAccIDformstringNo
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/QO_LineExtraQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"SOLineExtraRecID":"String","SOLineExtraRecIDStartsWith":"String","SOLineExtraRecIDEndsWith":"String","SOLineExtraRecIDContains":"String","SOLineExtraRecIDLike":"String","SOLineExtraRecIDBetween":["String"],"SOLineExtraRecIDIn":["String"],"InvoiceLineID":"String","InvoiceLineIDStartsWith":"String","InvoiceLineIDEndsWith":"String","InvoiceLineIDContains":"String","InvoiceLineIDLike":"String","InvoiceLineIDBetween":["String"],"InvoiceLineIDIn":["String"],"InvoiceHistoryID":"String","InvoiceHistoryIDStartsWith":"String","InvoiceHistoryIDEndsWith":"String","InvoiceHistoryIDContains":"String","InvoiceHistoryIDLike":"String","InvoiceHistoryIDBetween":["String"],"InvoiceHistoryIDIn":["String"],"LedgerReversePurchaseAccID":"String","LedgerReversePurchaseAccIDStartsWith":"String","LedgerReversePurchaseAccIDEndsWith":"String","LedgerReversePurchaseAccIDContains":"String","LedgerReversePurchaseAccIDLike":"String","LedgerReversePurchaseAccIDBetween":["String"],"LedgerReversePurchaseAccIDIn":["String"],"LedgerMovement_COGAccID":"String","LedgerMovement_COGAccIDStartsWith":"String","LedgerMovement_COGAccIDEndsWith":"String","LedgerMovement_COGAccIDContains":"String","LedgerMovement_COGAccIDLike":"String","LedgerMovement_COGAccIDBetween":["String"],"LedgerMovement_COGAccIDIn":["String"],"LedgerSalesAccID":"String","LedgerSalesAccIDStartsWith":"String","LedgerSalesAccIDEndsWith":"String","LedgerSalesAccIDContains":"String","LedgerSalesAccIDLike":"String","LedgerSalesAccIDBetween":["String"],"LedgerSalesAccIDIn":["String"],"LedgerSalesReturnsAccID":"String","LedgerSalesReturnsAccIDStartsWith":"String","LedgerSalesReturnsAccIDEndsWith":"String","LedgerSalesReturnsAccIDContains":"String","LedgerSalesReturnsAccIDLike":"String","LedgerSalesReturnsAccIDBetween":["String"],"LedgerSalesReturnsAccIDIn":["String"],"LedgerTaxLiabAccID":"String","LedgerTaxLiabAccIDStartsWith":"String","LedgerTaxLiabAccIDEndsWith":"String","LedgerTaxLiabAccIDContains":"String","LedgerTaxLiabAccIDLike":"String","LedgerTaxLiabAccIDBetween":["String"],"LedgerTaxLiabAccIDIn":["String"],"LedgerTaxExpAccID":"String","LedgerTaxExpAccIDStartsWith":"String","LedgerTaxExpAccIDEndsWith":"String","LedgerTaxExpAccIDContains":"String","LedgerTaxExpAccIDLike":"String","LedgerTaxExpAccIDBetween":["String"],"LedgerTaxExpAccIDIn":["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":[{"SOLineExtraRecID":"String","InvoiceLineID":"String","InvoiceHistoryID":"String","LedgerReversePurchaseAccID":"String","LedgerMovement_COGAccID":"String","LedgerSalesAccID":"String","LedgerSalesReturnsAccID":"String","LedgerTaxLiabAccID":"String","LedgerTaxExpAccID":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}