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 .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /xml/reply/SM_EmailLogQuery HTTP/1.1 
Host: api.jiwa.com.au 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<SM_EmailLogQuery xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
  <Fields xmlns="http://schemas.servicestack.net/types">String</Fields>
  <Include xmlns="http://schemas.servicestack.net/types">String</Include>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.servicestack.net/types">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <OrderBy xmlns="http://schemas.servicestack.net/types">String</OrderBy>
  <OrderByDesc xmlns="http://schemas.servicestack.net/types">String</OrderByDesc>
  <Skip xmlns="http://schemas.servicestack.net/types">0</Skip>
  <Take xmlns="http://schemas.servicestack.net/types">0</Take>
  <Attachments>String</Attachments>
  <AttachmentsBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AttachmentsBetween>
  <AttachmentsContains>String</AttachmentsContains>
  <AttachmentsEndsWith>String</AttachmentsEndsWith>
  <AttachmentsIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </AttachmentsIn>
  <AttachmentsLike>String</AttachmentsLike>
  <AttachmentsStartsWith>String</AttachmentsStartsWith>
  <BCC>String</BCC>
  <BCCBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BCCBetween>
  <BCCContains>String</BCCContains>
  <BCCEndsWith>String</BCCEndsWith>
  <BCCIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BCCIn>
  <BCCLike>String</BCCLike>
  <BCCStartsWith>String</BCCStartsWith>
  <Body>String</Body>
  <BodyBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BodyBetween>
  <BodyContains>String</BodyContains>
  <BodyEndsWith>String</BodyEndsWith>
  <BodyIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </BodyIn>
  <BodyLike>String</BodyLike>
  <BodyStartsWith>String</BodyStartsWith>
  <CC>String</CC>
  <CCBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CCBetween>
  <CCContains>String</CCContains>
  <CCEndsWith>String</CCEndsWith>
  <CCIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </CCIn>
  <CCLike>String</CCLike>
  <CCStartsWith>String</CCStartsWith>
  <EM_Main_RecID>String</EM_Main_RecID>
  <EM_Main_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </EM_Main_RecIDBetween>
  <EM_Main_RecIDContains>String</EM_Main_RecIDContains>
  <EM_Main_RecIDEndsWith>String</EM_Main_RecIDEndsWith>
  <EM_Main_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </EM_Main_RecIDIn>
  <EM_Main_RecIDLike>String</EM_Main_RecIDLike>
  <EM_Main_RecIDStartsWith>String</EM_Main_RecIDStartsWith>
  <EmailDateTime>0001-01-01T00:00:00</EmailDateTime>
  <EmailDateTimeBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EmailDateTimeBetween>
  <EmailDateTimeGreaterThan>0001-01-01T00:00:00</EmailDateTimeGreaterThan>
  <EmailDateTimeGreaterThanOrEqualTo>0001-01-01T00:00:00</EmailDateTimeGreaterThanOrEqualTo>
  <EmailDateTimeIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:dateTime>0001-01-01T00:00:00</d2p1:dateTime>
  </EmailDateTimeIn>
  <EmailDateTimeLessThan>0001-01-01T00:00:00</EmailDateTimeLessThan>
  <EmailDateTimeLessThanOrEqualTo>0001-01-01T00:00:00</EmailDateTimeLessThanOrEqualTo>
  <EmailDateTimeNotEqualTo>0001-01-01T00:00:00</EmailDateTimeNotEqualTo>
  <From>String</From>
  <FromBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </FromBetween>
  <FromContains>String</FromContains>
  <FromEndsWith>String</FromEndsWith>
  <FromIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </FromIn>
  <FromLike>String</FromLike>
  <FromStartsWith>String</FromStartsWith>
  <HR_Staff_RecID>String</HR_Staff_RecID>
  <HR_Staff_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_RecIDBetween>
  <HR_Staff_RecIDContains>String</HR_Staff_RecIDContains>
  <HR_Staff_RecIDEndsWith>String</HR_Staff_RecIDEndsWith>
  <HR_Staff_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </HR_Staff_RecIDIn>
  <HR_Staff_RecIDLike>String</HR_Staff_RecIDLike>
  <HR_Staff_RecIDStartsWith>String</HR_Staff_RecIDStartsWith>
  <RecID>String</RecID>
  <RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDBetween>
  <RecIDContains>String</RecIDContains>
  <RecIDEndsWith>String</RecIDEndsWith>
  <RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </RecIDIn>
  <RecIDLike>String</RecIDLike>
  <RecIDStartsWith>String</RecIDStartsWith>
  <RequestReadReceipt>false</RequestReadReceipt>
  <SM_Jobs_RecID>String</SM_Jobs_RecID>
  <SM_Jobs_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Jobs_RecIDBetween>
  <SM_Jobs_RecIDContains>String</SM_Jobs_RecIDContains>
  <SM_Jobs_RecIDEndsWith>String</SM_Jobs_RecIDEndsWith>
  <SM_Jobs_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Jobs_RecIDIn>
  <SM_Jobs_RecIDLike>String</SM_Jobs_RecIDLike>
  <SM_Jobs_RecIDStartsWith>String</SM_Jobs_RecIDStartsWith>
  <SM_Tasks_RecID>String</SM_Tasks_RecID>
  <SM_Tasks_RecIDBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Tasks_RecIDBetween>
  <SM_Tasks_RecIDContains>String</SM_Tasks_RecIDContains>
  <SM_Tasks_RecIDEndsWith>String</SM_Tasks_RecIDEndsWith>
  <SM_Tasks_RecIDIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SM_Tasks_RecIDIn>
  <SM_Tasks_RecIDLike>String</SM_Tasks_RecIDLike>
  <SM_Tasks_RecIDStartsWith>String</SM_Tasks_RecIDStartsWith>
  <Subject>String</Subject>
  <SubjectBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SubjectBetween>
  <SubjectContains>String</SubjectContains>
  <SubjectEndsWith>String</SubjectEndsWith>
  <SubjectIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </SubjectIn>
  <SubjectLike>String</SubjectLike>
  <SubjectStartsWith>String</SubjectStartsWith>
  <To>String</To>
  <ToBetween xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ToBetween>
  <ToContains>String</ToContains>
  <ToEndsWith>String</ToEndsWith>
  <ToIn xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </ToIn>
  <ToLike>String</ToLike>
  <ToStartsWith>String</ToStartsWith>
</SM_EmailLogQuery>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<QueryResponseOfSM_EmailLog7kRqkrSv xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.servicestack.net/types">
  <Offset>0</Offset>
  <Total>0</Total>
  <Results xmlns:d2p1="http://schemas.datacontract.org/2004/07/JiwaFinancials.Jiwa.JiwaServiceModel.Tables">
    <d2p1:SM_EmailLog>
      <d2p1:_x003C_Attachments_x003E_k__BackingField>String</d2p1:_x003C_Attachments_x003E_k__BackingField>
      <d2p1:_x003C_BCC_x003E_k__BackingField>String</d2p1:_x003C_BCC_x003E_k__BackingField>
      <d2p1:_x003C_Body_x003E_k__BackingField>String</d2p1:_x003C_Body_x003E_k__BackingField>
      <d2p1:_x003C_CC_x003E_k__BackingField>String</d2p1:_x003C_CC_x003E_k__BackingField>
      <d2p1:_x003C_EM_Main_RecID_x003E_k__BackingField>String</d2p1:_x003C_EM_Main_RecID_x003E_k__BackingField>
      <d2p1:_x003C_EmailDateTime_x003E_k__BackingField>0001-01-01T00:00:00</d2p1:_x003C_EmailDateTime_x003E_k__BackingField>
      <d2p1:_x003C_From_x003E_k__BackingField>String</d2p1:_x003C_From_x003E_k__BackingField>
      <d2p1:_x003C_HR_Staff_RecID_x003E_k__BackingField>String</d2p1:_x003C_HR_Staff_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RecID_x003E_k__BackingField>String</d2p1:_x003C_RecID_x003E_k__BackingField>
      <d2p1:_x003C_RequestReadReceipt_x003E_k__BackingField>false</d2p1:_x003C_RequestReadReceipt_x003E_k__BackingField>
      <d2p1:_x003C_SM_Jobs_RecID_x003E_k__BackingField>String</d2p1:_x003C_SM_Jobs_RecID_x003E_k__BackingField>
      <d2p1:_x003C_SM_Tasks_RecID_x003E_k__BackingField>String</d2p1:_x003C_SM_Tasks_RecID_x003E_k__BackingField>
      <d2p1:_x003C_Subject_x003E_k__BackingField>String</d2p1:_x003C_Subject_x003E_k__BackingField>
      <d2p1:_x003C_To_x003E_k__BackingField>String</d2p1:_x003C_To_x003E_k__BackingField>
    </d2p1:SM_EmailLog>
  </Results>
  <Meta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringstring>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value>String</d2p1:Value>
    </d2p1:KeyValueOfstringstring>
  </Meta>
  <ResponseStatus>
    <ErrorCode>String</ErrorCode>
    <Message>String</Message>
    <StackTrace>String</StackTrace>
    <Errors>
      <ResponseError>
        <ErrorCode>String</ErrorCode>
        <FieldName>String</FieldName>
        <Message>String</Message>
        <Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </Meta>
      </ResponseError>
    </Errors>
    <Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </Meta>
  </ResponseStatus>
</QueryResponseOfSM_EmailLog7kRqkrSv>