JiwaAPI

<back to all web services

SY_UpgradeLogQuery

Requires Authentication
SY_UpgradeLogQuery Parameters:
NameParameterData TypeRequiredDescription
PKqueryint?No
PKGreaterThanOrEqualToqueryint?No
PKGreaterThanqueryint?No
PKLessThanqueryint?No
PKLessThanOrEqualToqueryint?No
PKNotEqualToqueryint?No
PKBetweenqueryint[]No
PKInqueryint[]No
DatabaseMajorqueryint?No
DatabaseMajorGreaterThanOrEqualToqueryint?No
DatabaseMajorGreaterThanqueryint?No
DatabaseMajorLessThanqueryint?No
DatabaseMajorLessThanOrEqualToqueryint?No
DatabaseMajorNotEqualToqueryint?No
DatabaseMajorBetweenqueryint[]No
DatabaseMajorInqueryint[]No
DatabaseMinorqueryint?No
DatabaseMinorGreaterThanOrEqualToqueryint?No
DatabaseMinorGreaterThanqueryint?No
DatabaseMinorLessThanqueryint?No
DatabaseMinorLessThanOrEqualToqueryint?No
DatabaseMinorNotEqualToqueryint?No
DatabaseMinorBetweenqueryint[]No
DatabaseMinorInqueryint[]No
DatabaseReleasequeryint?No
DatabaseReleaseGreaterThanOrEqualToqueryint?No
DatabaseReleaseGreaterThanqueryint?No
DatabaseReleaseLessThanqueryint?No
DatabaseReleaseLessThanOrEqualToqueryint?No
DatabaseReleaseNotEqualToqueryint?No
DatabaseReleaseBetweenqueryint[]No
DatabaseReleaseInqueryint[]No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SY_UpgradeLog Parameters:
NameParameterData TypeRequiredDescription
PKformintNo
DatabaseMajorformintNo
DatabaseMinorformintNo
DatabaseReleaseformintNo
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/SY_UpgradeLogQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"PK":0,"PKGreaterThanOrEqualTo":0,"PKGreaterThan":0,"PKLessThan":0,"PKLessThanOrEqualTo":0,"PKNotEqualTo":0,"PKBetween":[0],"PKIn":[0],"DatabaseMajor":0,"DatabaseMajorGreaterThanOrEqualTo":0,"DatabaseMajorGreaterThan":0,"DatabaseMajorLessThan":0,"DatabaseMajorLessThanOrEqualTo":0,"DatabaseMajorNotEqualTo":0,"DatabaseMajorBetween":[0],"DatabaseMajorIn":[0],"DatabaseMinor":0,"DatabaseMinorGreaterThanOrEqualTo":0,"DatabaseMinorGreaterThan":0,"DatabaseMinorLessThan":0,"DatabaseMinorLessThanOrEqualTo":0,"DatabaseMinorNotEqualTo":0,"DatabaseMinorBetween":[0],"DatabaseMinorIn":[0],"DatabaseRelease":0,"DatabaseReleaseGreaterThanOrEqualTo":0,"DatabaseReleaseGreaterThan":0,"DatabaseReleaseLessThan":0,"DatabaseReleaseLessThanOrEqualTo":0,"DatabaseReleaseNotEqualTo":0,"DatabaseReleaseBetween":[0],"DatabaseReleaseIn":[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":[{}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}