Note those dates in your example are not the same
2015-10-27T09:00:00-05:00
would be
2015-10-27T14:00:00Z
See http://www.w3.org/TR/NOTE-datetime for a more detailed explanation of
the XML datetime
The only way to force the Z format in the AR System would be to edit the WSDL
(making the date a character field) and format it yourself (with the
appropriate TZ math adjusting for daylight savings). I would of course ask the
vendor why they are not supporting the industry standard format.
Fred
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn
Sent: Tuesday, October 27, 2015 10:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: Web Service Date Question
**
Thanks. My observation is that the web service accepts the format with the
offset, but the vendor I am working with says that I should not send an offset.
So the problem is that my date value might look like this:
2015-10-27T09:00:00-05:00
But the vendor says it should look like this:
2015-10-27T09:00:00Z
I’m not aware of any way to change that within Remedy, nor will the Filter
workflow allow me to map a date attribute on the WSDL to a character field in
Remedy.
Thanks,
Shawn Pierson
Remedy Developer | Energy Transfer
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jayesh
Sent: Tuesday, October 27, 2015 9:29 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Web Service Date Question
**
Hi ,
I am not sure I understood your query but if you want to pass specific offset
in webservice then you can alter the offset using + or - HH:MM
Or you can store the offset in character field and create date format
webservice accepts.
Regards,
Jayesh
________________________________
From: Pierson, Shawn<mailto:shawn.pier...@energytransfer.com>
Sent: 27-10-2015 06:38 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Web Service Date Question
**
Good morning,
I’m currently trying to figure something out connecting to web services from a
filter with AR System. The web service I am connecting to requires the date to
be in a format like “YYYY-MM-DDTHH:MM:SSZ” for GMT. However, the only option
that I seem to be able to send through AR System is
“YYYY-MM-DDTHH:MM:SS-HH:MM:SS” (this accounts for the time zone.) I’ve
considered simply doing date math to account for the time zone but the vendor I
am dealing with is adamant that I send a “Z” at the end or nothing else. Since
Remedy doesn’t let you map dates to text fields, I can’t simply fix it that way
either. The only option I’ve come up with is modifying the WSDL and making it
think that the date is a character field so I can send the value they want, but
I’m not even sure if that will work.
Are there any other suggestions out there, hopefully ones that help me avoid
further modifying the WSDL?
Thanks,
Shawn Pierson
Remedy Developer | Energy Transfer
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
