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"