JiwaAPI

<back to all web services

CR_AutoTranQuery

Requires Authentication
CR_AutoTranQuery Parameters:
NameParameterData TypeRequiredDescription
CRAutoTranIDquerystringNo
CRAutoTranIDStartsWithquerystringNo
CRAutoTranIDEndsWithquerystringNo
CRAutoTranIDContainsquerystringNo
CRAutoTranIDLikequerystringNo
CRAutoTranIDBetweenquerystring[]No
CRAutoTranIDInquerystring[]No
LastSavedDateTimequeryDateTime?No
LastSavedDateTimeGreaterThanOrEqualToqueryDateTime?No
LastSavedDateTimeGreaterThanqueryDateTime?No
LastSavedDateTimeLessThanqueryDateTime?No
LastSavedDateTimeLessThanOrEqualToqueryDateTime?No
LastSavedDateTimeNotEqualToqueryDateTime?No
LastSavedDateTimeBetweenqueryNullable<DateTime>[]No
LastSavedDateTimeInqueryNullable<DateTime>[]No
RunDateTimequeryDateTime?No
RunDateTimeGreaterThanOrEqualToqueryDateTime?No
RunDateTimeGreaterThanqueryDateTime?No
RunDateTimeLessThanqueryDateTime?No
RunDateTimeLessThanOrEqualToqueryDateTime?No
RunDateTimeNotEqualToqueryDateTime?No
RunDateTimeBetweenqueryNullable<DateTime>[]No
RunDateTimeInqueryNullable<DateTime>[]No
UserNamequerystringNo
UserNameStartsWithquerystringNo
UserNameEndsWithquerystringNo
UserNameContainsquerystringNo
UserNameLikequerystringNo
UserNameBetweenquerystring[]No
UserNameInquerystring[]No
RunNoquerystringNo
RunNoStartsWithquerystringNo
RunNoEndsWithquerystringNo
RunNoContainsquerystringNo
RunNoLikequerystringNo
RunNoBetweenquerystring[]No
RunNoInquerystring[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
CR_AutoTran Parameters:
NameParameterData TypeRequiredDescription
CRAutoTranIDformstringNo
LastSavedDateTimeformDateTime?No
RunDateTimeformDateTime?No
UserNameformstringNo
RunNoformstringNo
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/CR_AutoTranQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"CRAutoTranID":"String","CRAutoTranIDStartsWith":"String","CRAutoTranIDEndsWith":"String","CRAutoTranIDContains":"String","CRAutoTranIDLike":"String","CRAutoTranIDBetween":["String"],"CRAutoTranIDIn":["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"],"RunDateTime":"0001-01-01T00:00:00.0000000","RunDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","RunDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","RunDateTimeLessThan":"0001-01-01T00:00:00.0000000","RunDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","RunDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","RunDateTimeBetween":["0001-01-01T00:00:00.0000000"],"RunDateTimeIn":["0001-01-01T00:00:00.0000000"],"UserName":"String","UserNameStartsWith":"String","UserNameEndsWith":"String","UserNameContains":"String","UserNameLike":"String","UserNameBetween":["String"],"UserNameIn":["String"],"RunNo":"String","RunNoStartsWith":"String","RunNoEndsWith":"String","RunNoContains":"String","RunNoLike":"String","RunNoBetween":["String"],"RunNoIn":["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":[{"CRAutoTranID":"String","LastSavedDateTime":"0001-01-01T00:00:00.0000000","RunDateTime":"0001-01-01T00:00:00.0000000","UserName":"String","RunNo":"String"}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}