Try converting to a blob and then to string with EncodingAnsi! as the format. If that doesn't give you the XML string, save the blob to a file and view it in a hex editor. You should be able to identify the position where the XML string starts.

Hi Kevin,

Yes, probably should be easy with REST API, but sadly this Webservice depends on a third company.

Regards.

Hi Roland, I tried the solution you suggested, converting to string, but I get an empty string.

The result it is a XML file, but its enveloped in a complex type (TypeResultQuery):

If Roland's suggestion of converting to String (then you can at least look at it hopefully), see if there is a REST api for that webservice.  It might be easier to use REST instead of SOAP.

There is a possibility that the DataTable is just XML. Try converting it to a string:

ls_text = String(las_result.dt)

Hi Kevin, thanks for the reply.

typefuncgen it's a structure with the return codes, but the data is on dt variable:

I tried yesterday the createFrom function like you comment, but when I assign the data to the resultset (lrs_data = las_result.dt) you get the error:

The problem is that for PowerBuilder a .NET DataTable datatype is any datatype on Powerbuilder:

And I can't do nothing with that.

Regards,

If you are going to transfer large amounts of data, I would recommend compressed XML or tabbed text.

You can use ZLib to compress it on one end and decompress at the other end. Then use ImportString to import the string.

http://www.topwizprogramming.com/freecode_zlibwapi.html

Haven't seen anyone answer this so I'm gonna take a stab at it.  Never had to work with DataTable type but here's what I think you might need to do.  If you can get the returned data into either a Resultset type or ADOResultset, you can use the datastore.CreateFrom method to load the data.  There's some good documentation in the PB Help on the CreateFrom function.  The challenge obviously is getting to a resultset or adoresultset.  Based on your picture, the answer might lie in the typefuncgen attribute of the typeresultquery.  What shows when you expand that?  Maybe you can assign that to a resultset or adoresultset?  Something like:

resultset     lrs_data

datastore    lds_data

lds_data = create datastore

lrs_data = las_result.result

lds.data.CreateFrom(lrs_data)

Just a guess, but maybe it will be of some help.