Exchange/Graph: Difference between revisions
Jkuehlthau (talk | contribs) No edit summary |
Jkuehlthau (talk | contribs) |
||
Line 25: | Line 25: | ||
=Mapping= | =Mapping= | ||
==Retrieving Attachments== | |||
To retrieve attachments from an email, you must perform a SmartLookup and pass in the attachment's ID. Note that the origin field, @@ORG:AttachmentId@@, will sometimes contain an array of IDs, so you must always do a Split on the Attachment Id (comma-seperated list) and loop through for each id. | |||
<script language="vb"> | |||
Sub VBScriptProcedure | |||
Logmessage SmartLookup("GetAttachment", "Content", "@@ORG:AttachmentId@@") | |||
End Sub | |||
</script> | |||
=Notes= | =Notes= | ||
If you're running into an error and want to log even more, place ";Logfile=C:\inetpub\wwwroot\StarfishEngine\exchange.log;Verbosity=3;" into the "Additional Connection String Parameters" field. | If you're running into an error and want to log even more, place ";Logfile=C:\inetpub\wwwroot\StarfishEngine\exchange.log;Verbosity=3;" into the "Additional Connection String Parameters" field. |
Revision as of 17:09, 5 March 2018
Overview
The "Exchange (NEW)" connector is based on a driver from https://www.cdata.com/. Helpful documentation for using the "Exchange (NEW)" connector can be found here: http://cdn.cdata.com/help/CEC/ado/pg_alltables.htm.
Origin
Web Service URL
If you are using Office 365 for your Exchange server, then your Web Service URL is https://mail.office365.com/ews/exchange.asmx. If you are hosting Exchange yourself or using another cloud provider, then your URL will look slightly different but will still likely end with exhcange.asmx.
Additional Connection String Parameters
See the Connection String Options for more information about what can go here, http://cdn.cdata.com/help/CEC/ado/Connection.htm.
Here are a couple of items:
Parameter | Description |
---|---|
Include Content=true; | A boolean indicating if additional content should be retrieved. Addiditional content includes the body of emails. |
Auth Scheme=NTLM; | Sets the scheme used for authentication. Accepted entries are NTLM, BASIC, DIGEST, NONE, NEGOTIATE, and KERBEROSDELEGATION. |
SQL Selection Statement
Use the Query Builder... hyperlink on the right to build your initial queries. Check out the CData documentation select page for more information about writing queries, http://cdn.cdata.com/help/CEC/ado/pg_select.htm.
Mapping
Retrieving Attachments
To retrieve attachments from an email, you must perform a SmartLookup and pass in the attachment's ID. Note that the origin field, @@ORG:AttachmentId@@, will sometimes contain an array of IDs, so you must always do a Split on the Attachment Id (comma-seperated list) and loop through for each id. <script language="vb"> Sub VBScriptProcedure
Logmessage SmartLookup("GetAttachment", "Content", "@@ORG:AttachmentId@@")
End Sub </script>
Notes
If you're running into an error and want to log even more, place ";Logfile=C:\inetpub\wwwroot\StarfishEngine\exchange.log;Verbosity=3;" into the "Additional Connection String Parameters" field.