1. Milton Jiménez
  2. PowerBuilder
  3. Thursday, 28 December 2017

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
0
Votes
Undo

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
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. Milton Jiménez
  2. Sunday, 31 December 2017
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. Milton Jiménez
  2. Wednesday, 10 January 2018
There are no comments made yet.
  1. Friday, 29 December 2017
  2. PowerBuilder
  3. # Permalink


There are replies in this question but you are not allowed to view the replies from this question.