1. Milton Jiménez
  2. PowerBuilder
  3. Thursday, 28 December 2017 21:54 PM UTC

Hi, Friends,

I am consuming a webservice using SOAP .net Engine (pbwsclient170.pbx​) 

https://celcer.sri.gob.ec/comprobantes-electronicos-ws/AutorizacionComprobantesOffline?wsdl

​but the message is (INVALID RESULTSET PARAMETER TYPE WAS DETECTED); in a retrieval datawindow

​2. When I try creating soap connection, it returns empty (0)​

​Please Any idea to do it directly without third-party

PD: ​return a Object content in other Object, but the object return [0] 

Thanks, 

 

 

 

 

 

 

 

Accepted Answer
Marco Meoni Accepted Answer Pending Moderation
  1. Friday, 29 December 2017 07:10 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Milton,

that is just fine.

WS DataWindows are meant to retrieve from WS returning a resultset that can be displayed as a set of rows and columns.

Your WS returns custom structures ("autorizacion", "mensaje", etc...).

In that case you must use PB WS proxy objects (File -> New -> Project -> WS Proxy Wizard).

You can follow this tutorial for an HowTo (Appeon webcast or youtube links):

  • https://www.appeon.com/developers/library/videos/soap-web-service-crash-course.html
  • https://www.youtube.com/watch?v=SFrR_stypx0

Cheers,

Marco

Comment
  1. Milton Jiménez
  2. Sunday, 31 December 2017 17:49 PM UTC
Hi Marco



I use PB WS proxy  



Soapconnection conn

autorizacioncomprobantesofflineservice   lnv_webservice  //proxy object 

respuestacomprobante   lnv_autorizarepcomp  //instance  object returned (respuestacomprobante is a object created since ( https://celcer.sri.gob.ec/comprobantes-electronicos-ws/AutorizacionComprobantesOffline?wsdl)



autorizacion lnv_autoriza



mensaje lnv_mensaje

string ls_estado

long li_rc



 



conn= Create Soapconnection

li_rc=conn.CreateInstance(lnv_webservice,'autorizacioncomprobantesofflineservice')

try

lnv_autorizarepcomp=lnv_webservice.autorizacioncomprobante('2812201707170097910500110030020000000241234567817')

     messagebox("Exito","")

catch (Soapexception e)

 messagebox("Error",e.GetMessage())

finally

destroy(conn) 

end try



//////////////////////////////////



This object returN:



respuestacomprobante  lnv_autorizarepcomp 



​    autorizacion autorizaciones[0]  --->autorizacion is other object created since el web service



   claveaacesoaconsultada="2812201707170097910500110030020000000241234567817"



   numcomprobantes="1"



the problem is that autorizaciones[0] when must  return  some properties of object autorizacion.fecha; autorizacion.numeroautorizacion   .......



the web sevice no return structures if not objects



Is there a process like serialization ?



thanks



regards,



 



 



 



 



 



 



 

  1. Helpful
  1. Milton Jiménez
  2. Wednesday, 10 January 2018 16:47 PM UTC
Hi Marco



I use PB WS proxy  



Soapconnection conn

autorizacioncomprobantesofflineservice   lnv_webservice  //proxy object 

respuestacomprobante   lnv_autorizarepcomp  //instance  object returned (respuestacomprobante is a object created since ( https://celcer.sri.gob.ec/comprobantes-electronicos-ws/AutorizacionComprobantesOffline?wsdl)



autorizacion lnv_autoriza



mensaje lnv_mensaje

string ls_estado

long li_rc



 



conn= Create Soapconnection

li_rc=conn.CreateInstance(lnv_webservice,'autorizacioncomprobantesofflineservice')

try

lnv_autorizarepcomp=lnv_webservice.autorizacioncomprobante('2812201707170097910500110030020000000241234567817')

     messagebox("Exito","")

catch (Soapexception e)

 messagebox("Error",e.GetMessage())

finally

destroy(conn) 

end try



//////////////////////////////////



This object returN:



respuestacomprobante  lnv_autorizarepcomp 



​    autorizacion autorizaciones[0]  --->autorizacion is other object created since el web service



   claveaacesoaconsultada="2812201707170097910500110030020000000241234567817"



   numcomprobantes="1"



the problem is that autorizaciones[0] when must  return  some properties of object autorizacion.fecha; autorizacion.numeroautorizacion   .......



the web sevice no return structures if not objects



Is there a process like serialization ?



thanks



regards,



 



 



 

  1. Helpful
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from 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.