JiwaAPI

<back to all web services

SO_HistoryConsignmentNotesQuery

Requires Authentication
SO_HistoryConsignmentNotesQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
SO_History_InvoiceHistoryIDquerystringNo
SO_History_InvoiceHistoryIDStartsWithquerystringNo
SO_History_InvoiceHistoryIDEndsWithquerystringNo
SO_History_InvoiceHistoryIDContainsquerystringNo
SO_History_InvoiceHistoryIDLikequerystringNo
SO_History_InvoiceHistoryIDBetweenquerystring[]No
SO_History_InvoiceHistoryIDInquerystring[]No
ConsignmentNoteNoquerystringNo
ConsignmentNoteNoStartsWithquerystringNo
ConsignmentNoteNoEndsWithquerystringNo
ConsignmentNoteNoContainsquerystringNo
ConsignmentNoteNoLikequerystringNo
ConsignmentNoteNoBetweenquerystring[]No
ConsignmentNoteNoInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryDateTime[]No
LastSavedDateTimeInqueryDateTime[]No
ConsignmentNoteDatequeryDateTime?No
ConsignmentNoteDateGreaterThanOrEqualToqueryDateTime?No
ConsignmentNoteDateGreaterThanqueryDateTime?No
ConsignmentNoteDateLessThanqueryDateTime?No
ConsignmentNoteDateLessThanOrEqualToqueryDateTime?No
ConsignmentNoteDateNotEqualToqueryDateTime?No
ConsignmentNoteDateBetweenqueryNullable<DateTime>[]No
ConsignmentNoteDateInqueryNullable<DateTime>[]No
ExGSTAmountquerydecimal?No
ExGSTAmountGreaterThanOrEqualToquerydecimal?No
ExGSTAmountGreaterThanquerydecimal?No
ExGSTAmountLessThanquerydecimal?No
ExGSTAmountLessThanOrEqualToquerydecimal?No
ExGSTAmountNotEqualToquerydecimal?No
ExGSTAmountBetweenquerydecimal[]No
ExGSTAmountInquerydecimal[]No
GSTAmountquerydecimal?No
GSTAmountGreaterThanOrEqualToquerydecimal?No
GSTAmountGreaterThanquerydecimal?No
GSTAmountLessThanquerydecimal?No
GSTAmountLessThanOrEqualToquerydecimal?No
GSTAmountNotEqualToquerydecimal?No
GSTAmountBetweenquerydecimal[]No
GSTAmountInquerydecimal[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SO_HistoryConsignmentNotes Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
SO_History_InvoiceHistoryIDformstringNo
ConsignmentNoteNoformstringNo
LastSavedDateTimeformDateTimeNo
ConsignmentNoteDateformDateTime?No
ExGSTAmountformdecimalNo
GSTAmountformdecimalNo
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_HistoryConsignmentNotesQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"RecID":"String","RecIDStartsWith":"String","RecIDEndsWith":"String","RecIDContains":"String","RecIDLike":"String","RecIDBetween":["String"],"RecIDIn":["String"],"SO_History_InvoiceHistoryID":"String","SO_History_InvoiceHistoryIDStartsWith":"String","SO_History_InvoiceHistoryIDEndsWith":"String","SO_History_InvoiceHistoryIDContains":"String","SO_History_InvoiceHistoryIDLike":"String","SO_History_InvoiceHistoryIDBetween":["String"],"SO_History_InvoiceHistoryIDIn":["String"],"ConsignmentNoteNo":"String","ConsignmentNoteNoStartsWith":"String","ConsignmentNoteNoEndsWith":"String","ConsignmentNoteNoContains":"String","ConsignmentNoteNoLike":"String","ConsignmentNoteNoBetween":["String"],"ConsignmentNoteNoIn":["String"],"LastSavedDateTime":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThan":"0001-01-01T00:00:00.0000000","LastSavedDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","LastSavedDateTimeBetween":["0001-01-01T00:00:00.0000000"],"LastSavedDateTimeIn":["0001-01-01T00:00:00.0000000"],"ConsignmentNoteDate":"0001-01-01T00:00:00.0000000","ConsignmentNoteDateGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","ConsignmentNoteDateGreaterThan":"0001-01-01T00:00:00.0000000","ConsignmentNoteDateLessThan":"0001-01-01T00:00:00.0000000","ConsignmentNoteDateLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","ConsignmentNoteDateNotEqualTo":"0001-01-01T00:00:00.0000000","ConsignmentNoteDateBetween":["0001-01-01T00:00:00.0000000"],"ConsignmentNoteDateIn":["0001-01-01T00:00:00.0000000"],"ExGSTAmount":0,"ExGSTAmountGreaterThanOrEqualTo":0,"ExGSTAmountGreaterThan":0,"ExGSTAmountLessThan":0,"ExGSTAmountLessThanOrEqualTo":0,"ExGSTAmountNotEqualTo":0,"ExGSTAmountBetween":[0],"ExGSTAmountIn":[0],"GSTAmount":0,"GSTAmountGreaterThanOrEqualTo":0,"GSTAmountGreaterThan":0,"GSTAmountLessThan":0,"GSTAmountLessThanOrEqualTo":0,"GSTAmountNotEqualTo":0,"GSTAmountBetween":[0],"GSTAmountIn":[0],"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":[{"RecID":"String","SO_History_InvoiceHistoryID":"String","ConsignmentNoteNo":"String","ConsignmentNoteDate":"0001-01-01T00:00:00.0000000"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}