Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Datetime format

  1. How-to
0
Votes
Undo
  1. Pepe Cuenca
    Pepe Cuenca
  2. PowerBuilder
  3. Tuesday, 17 March 2020 15:57 PM UTC

Good afternoon everybody, 

I'm calling an external SOAP Webservice, and I'm having problems with the Datetime format. 

I'm declaring my variables as Datetime and when I debug the code, the value of the variable is "17/03/2020 00:00:00".

The call crashes because of an invalida datetime format, which is, according to the provider, "2020-03-17T00:00:00+01:00"

I have to send the value without "+01:00", which I understand is the timezone. 

How can I do this?

Thank you very much, as always.

Pepe. 

 

PBC runtime fails
ODBC Data Sources
Responses (2)
Pepe Cuenca
Pepe Cuenca Accepted Answer Pending Moderation
  1. Wednesday, 18 March 2020 12:18 PM UTC
  2. PowerBuilder
  3. # 1

Hi Chris, Thanks for the reply. 

The problem is that my provider tells me that I am sending him a bad format in my request. 

I'm just declaring a variable as datetime and passing it as a part of an object in the call. 

I'm using proxy object. 

If I do it with http client it just works fine. 

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 18 March 2020 14:35 PM UTC
Is your PB App using the EasySOAP or DotNetSOAP web service feature currently?
  1. Helpful
Pepe Cuenca
  1. Pepe Cuenca
  2. Wednesday, 18 March 2020 14:45 PM UTC
Hi Chris, DotNetSOAP
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 18 March 2020 15:12 PM UTC
Thanks ... I was just curious. Either way, I think that just downloading the WSDL and editing the XML schema on the D/T column format should do the trick. Yes, the HTTPClient should always work as you are in full control of the XML data stream & formatting.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 17 March 2020 19:14 PM UTC
  2. PowerBuilder
  3. # 2

Hi Pepe;

  It sounds like the SOAP Web Service author is returning you a date + time zone and not DateTime.

For example: DT + TZ = "<start>2002-09-24+06:00</start>"

    Where your PB App is expecting standard SOAP D+T... "<start>2002-09-24T06:00:00</start>"

I would suggest that you either:

a) Contact the WS provider to change their D/T format     //OR

b) Download the WSDL and change the XML Schema D/T to the format PB requires.

    Then build your WS DW and/or proxies from that amended WSDL/XML Schema column format.

HTH

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.