Hello ALL,
There is a issue about the date time field in AO.
I am integration Remedy with Exchange Server via AO.
I have a date time field in Remedy named "Start" and "End". When I load the
Orchestrator process in the filter and try to map the date field with the
context item, it could not map, since all the context items are string type.
Yon can see the attached screenshort of filter.
I then create a character field in Remedy named "EndDateChar".I set the date
field in character field, the format of field changes from DD/MM/YYYY HH:MM:SS
to DD.MM.YYYY HH:MM:SS.
I mapped the character field with context item.
Now in AO I changed the format from DD.MM.YYYY HH:MM:SS to
YYYY-MM-DDTHH:MM:SS. Since exchange web service understand this format.
I passed the Start Date and End Date. I could see the structure in the process
log. It is fine as expected by Exchange, but I did not get the correct dates in
Meeting request in Outlook application.
If created a simple AO process with Adapter call and provided the static XML
with Date as sting value. and run the process. In this case I get the calendar
entry with correct date values.
Process Logs:
adapter request=
<request-data>
<soap-rpc-request>
<username>domain.nl\webservicetest</username>
<password>Sahil</password>
<ntlm-authentication>true</ntlm-authentication>
<use-ssl-certificate />
<install-certificate />
<allow-unsigned-certificate>false</allow-unsigned-certificate>
<truststore-file />
<passphrase />
<keystore-file />
<keystore-passphrase />
<client-alias />
<http-connection-properties>
<SoapAction>http://schemas.microsoft.com/exchange/services/2006/messages/CreateItem</SoapAction>
</http-connection-properties>
<transport>http-rpc</transport>
<soap-url>https://mailserver.com/EWS/Exchange.asmx</soap-url>
<character-set />
<download-attachments>false</download-attachments>
<soap-message>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<CreateItem
xmlns="http://schemas.microsoft.com/exchange/services/2006/messages"
SendMeetingInvitations="SendToAllAndSaveCopy">
<SavedItemFolderId>
<t:DistinguishedFolderId
xmlns:t="http://schemas.microsoft.com/exchange/services/2006/types"
Id="calendar" />
</SavedItemFolderId>
<Items>
<t:CalendarItem
xmlns:t="http://schemas.microsoft.com/exchange/services/2006/types">
<Subject
xmlns="http://schemas.microsoft.com/exchange/services/2006/types">test</Subject>
<Body
xmlns="http://schemas.microsoft.com/exchange/services/2006/types"
BodyType="Text">test</Body>
<ReminderIsSet
xmlns="http://schemas.microsoft.com/exchange/services/2006/types">true</ReminderIsSet>
<ReminderMinutesBeforeStart
xmlns="http://schemas.microsoft.com/exchange/services/2006/types">30</ReminderMinutesBeforeStart>
<Start
xmlns="http://schemas.microsoft.com/exchange/services/2006/types">2013-05-25T05:30:00</Start>
<End
xmlns="http://schemas.microsoft.com/exchange/services/2006/types">2013-05-25T07:30:00</End>
<IsAllDayEvent
xmlns="http://schemas.microsoft.com/exchange/services/2006/types">true</IsAllDayEvent>
<LegacyFreeBusyStatus
xmlns="http://schemas.microsoft.com/exchange/services/2006/types">Busy</LegacyFreeBusyStatus>
<Location
xmlns="http://schemas.microsoft.com/exchange/services/2006/types">test</Location>
<RequiredAttendees
xmlns="http://schemas.microsoft.com/exchange/services/2006/types">
<Attendee>
<Mailbox>
<EmailAddress>emailid</EmailAddress>
</Mailbox>
</Attendee>
</RequiredAttendees>
</t:CalendarItem>
</Items>
</CreateItem>
</soap:Body>
</soap:Envelope>
</soap-message>
</soap-rpc-request>
</request-data>
AO Module:
regards
Sahil Pathania
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"