JiwaAPI

<back to all web services

SM_EmailLogQuery

Requires Authentication
SM_EmailLogQuery Parameters:
NameParameterData TypeRequiredDescription
RecIDquerystringNo
RecIDStartsWithquerystringNo
RecIDEndsWithquerystringNo
RecIDContainsquerystringNo
RecIDLikequerystringNo
RecIDBetweenquerystring[]No
RecIDInquerystring[]No
SM_Tasks_RecIDquerystringNo
SM_Tasks_RecIDStartsWithquerystringNo
SM_Tasks_RecIDEndsWithquerystringNo
SM_Tasks_RecIDContainsquerystringNo
SM_Tasks_RecIDLikequerystringNo
SM_Tasks_RecIDBetweenquerystring[]No
SM_Tasks_RecIDInquerystring[]No
EmailDateTimequeryDateTime?No
EmailDateTimeGreaterThanOrEqualToqueryDateTime?No
EmailDateTimeGreaterThanqueryDateTime?No
EmailDateTimeLessThanqueryDateTime?No
EmailDateTimeLessThanOrEqualToqueryDateTime?No
EmailDateTimeNotEqualToqueryDateTime?No
EmailDateTimeBetweenqueryDateTime[]No
EmailDateTimeInqueryDateTime[]No
FromquerystringNo
FromStartsWithquerystringNo
FromEndsWithquerystringNo
FromContainsquerystringNo
FromLikequerystringNo
FromBetweenquerystring[]No
FromInquerystring[]No
ToquerystringNo
ToStartsWithquerystringNo
ToEndsWithquerystringNo
ToContainsquerystringNo
ToLikequerystringNo
ToBetweenquerystring[]No
ToInquerystring[]No
CCquerystringNo
CCStartsWithquerystringNo
CCEndsWithquerystringNo
CCContainsquerystringNo
CCLikequerystringNo
CCBetweenquerystring[]No
CCInquerystring[]No
BCCquerystringNo
BCCStartsWithquerystringNo
BCCEndsWithquerystringNo
BCCContainsquerystringNo
BCCLikequerystringNo
BCCBetweenquerystring[]No
BCCInquerystring[]No
AttachmentsquerystringNo
AttachmentsStartsWithquerystringNo
AttachmentsEndsWithquerystringNo
AttachmentsContainsquerystringNo
AttachmentsLikequerystringNo
AttachmentsBetweenquerystring[]No
AttachmentsInquerystring[]No
SubjectquerystringNo
SubjectStartsWithquerystringNo
SubjectEndsWithquerystringNo
SubjectContainsquerystringNo
SubjectLikequerystringNo
SubjectBetweenquerystring[]No
SubjectInquerystring[]No
BodyquerystringNo
BodyStartsWithquerystringNo
BodyEndsWithquerystringNo
BodyContainsquerystringNo
BodyLikequerystringNo
BodyBetweenquerystring[]No
BodyInquerystring[]No
SM_Jobs_RecIDquerystringNo
SM_Jobs_RecIDStartsWithquerystringNo
SM_Jobs_RecIDEndsWithquerystringNo
SM_Jobs_RecIDContainsquerystringNo
SM_Jobs_RecIDLikequerystringNo
SM_Jobs_RecIDBetweenquerystring[]No
SM_Jobs_RecIDInquerystring[]No
HR_Staff_RecIDquerystringNo
HR_Staff_RecIDStartsWithquerystringNo
HR_Staff_RecIDEndsWithquerystringNo
HR_Staff_RecIDContainsquerystringNo
HR_Staff_RecIDLikequerystringNo
HR_Staff_RecIDBetweenquerystring[]No
HR_Staff_RecIDInquerystring[]No
EM_Main_RecIDquerystringNo
EM_Main_RecIDStartsWithquerystringNo
EM_Main_RecIDEndsWithquerystringNo
EM_Main_RecIDContainsquerystringNo
EM_Main_RecIDLikequerystringNo
EM_Main_RecIDBetweenquerystring[]No
EM_Main_RecIDInquerystring[]No
RequestReadReceiptquerybool?No
QueryBase Parameters:
NameParameterData TypeRequiredDescription
Skipformint?No
Takeformint?No
OrderByformstringNo
OrderByDescformstringNo
IncludeformstringNo
FieldsformstringNo
MetaformDictionary<string, string>No
SM_EmailLog Parameters:
NameParameterData TypeRequiredDescription
RecIDformstringNo
SM_Tasks_RecIDformstringNo
EmailDateTimeformDateTimeNo
FromformstringNo
ToformstringNo
CCformstringNo
BCCformstringNo
AttachmentsformstringNo
SubjectformstringNo
BodyformstringNo
SM_Jobs_RecIDformstringNo
HR_Staff_RecIDformstringNo
EM_Main_RecIDformstringNo
RequestReadReceiptformbool?No
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/SM_EmailLogQuery 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"],"SM_Tasks_RecID":"String","SM_Tasks_RecIDStartsWith":"String","SM_Tasks_RecIDEndsWith":"String","SM_Tasks_RecIDContains":"String","SM_Tasks_RecIDLike":"String","SM_Tasks_RecIDBetween":["String"],"SM_Tasks_RecIDIn":["String"],"EmailDateTime":"0001-01-01T00:00:00.0000000","EmailDateTimeGreaterThanOrEqualTo":"0001-01-01T00:00:00.0000000","EmailDateTimeGreaterThan":"0001-01-01T00:00:00.0000000","EmailDateTimeLessThan":"0001-01-01T00:00:00.0000000","EmailDateTimeLessThanOrEqualTo":"0001-01-01T00:00:00.0000000","EmailDateTimeNotEqualTo":"0001-01-01T00:00:00.0000000","EmailDateTimeBetween":["0001-01-01T00:00:00.0000000"],"EmailDateTimeIn":["0001-01-01T00:00:00.0000000"],"From":"String","FromStartsWith":"String","FromEndsWith":"String","FromContains":"String","FromLike":"String","FromBetween":["String"],"FromIn":["String"],"To":"String","ToStartsWith":"String","ToEndsWith":"String","ToContains":"String","ToLike":"String","ToBetween":["String"],"ToIn":["String"],"CC":"String","CCStartsWith":"String","CCEndsWith":"String","CCContains":"String","CCLike":"String","CCBetween":["String"],"CCIn":["String"],"BCC":"String","BCCStartsWith":"String","BCCEndsWith":"String","BCCContains":"String","BCCLike":"String","BCCBetween":["String"],"BCCIn":["String"],"Attachments":"String","AttachmentsStartsWith":"String","AttachmentsEndsWith":"String","AttachmentsContains":"String","AttachmentsLike":"String","AttachmentsBetween":["String"],"AttachmentsIn":["String"],"Subject":"String","SubjectStartsWith":"String","SubjectEndsWith":"String","SubjectContains":"String","SubjectLike":"String","SubjectBetween":["String"],"SubjectIn":["String"],"Body":"String","BodyStartsWith":"String","BodyEndsWith":"String","BodyContains":"String","BodyLike":"String","BodyBetween":["String"],"BodyIn":["String"],"SM_Jobs_RecID":"String","SM_Jobs_RecIDStartsWith":"String","SM_Jobs_RecIDEndsWith":"String","SM_Jobs_RecIDContains":"String","SM_Jobs_RecIDLike":"String","SM_Jobs_RecIDBetween":["String"],"SM_Jobs_RecIDIn":["String"],"HR_Staff_RecID":"String","HR_Staff_RecIDStartsWith":"String","HR_Staff_RecIDEndsWith":"String","HR_Staff_RecIDContains":"String","HR_Staff_RecIDLike":"String","HR_Staff_RecIDBetween":["String"],"HR_Staff_RecIDIn":["String"],"EM_Main_RecID":"String","EM_Main_RecIDStartsWith":"String","EM_Main_RecIDEndsWith":"String","EM_Main_RecIDContains":"String","EM_Main_RecIDLike":"String","EM_Main_RecIDBetween":["String"],"EM_Main_RecIDIn":["String"],"RequestReadReceipt":false,"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","SM_Tasks_RecID":"String","From":"String","To":"String","CC":"String","BCC":"String","Attachments":"String","Subject":"String","Body":"String","SM_Jobs_RecID":"String","HR_Staff_RecID":"String","EM_Main_RecID":"String","RequestReadReceipt":false}],"Meta":{"String":"String"},"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}