Hi Pepe;



If the resulting XML is a simple 2D (rows & columns) set of standard data types - then you can load that straight into a DW object's buffer. If the XML result is of a more complex nature, you'll have to use PB's PBDOM feature to parse the data out via PowerScript.



Regards ... Chris

@ Chris: the result type is not plain 2D, Pepe is fetching custom objects ("Proyectos" or "ResultadoTabModule") via proxies

@ Pepe: the return code from CreateInstance and Getreportscategory will give you some clue



Best,

.m

Good Morning guys,



The return code of Create instance is 0 (successful), which is stored on rVal variable, and the return code of getreportscategory is also 0 if i make the conversion to long in the messagebox. I don't understand how it could be useful to see the data or insert it in a DW.



Thank you again for your help (and patience)

Hi Chris,

To test it in SOAPUI, we use the URL https://amcspainfresh.qdecalidad.com/webserviceExternal/ws.apps?ws=1



The GetProject method returns a list of categories, which is one of the variables needed to execute getreportscategory.



We have different categories, and we select it in the "category" in the parametres of getreportscategory, and it returns us a list of reports. These reports are the ones I want to load in my database.

Good Morning Marco,

This way is working ok, I see the response, the IdCategoria and IdNube, which are either string or long.

The problem now is how to see the data(Informes), which is a TabInformesarray type.

I've tried creating a TabInformes variable, and giving it the result of lo_res.tabcategoria.informes

Then, when I see the methods of this variable (la_informes), I can see the "datos" one, which is what I need, but I don't know how to access/see/work with the data...



Here is my code:



SoapConnection conn // Definimos conexión SOAP

webserviceexternalcontrollerservice proxy_obj // Declaramos proxy

long rVal

resultadotabmodule lo_res

Tabinformes la_informes []









conn = create SoapConnection //Creamos instancia de la conexión



// Set trace file to record soap interchange data,

// if string is "", disables the feature



rVal = Conn.CreateInstance(proxy_obj, &

"webserviceexternalcontrollerservice")



try



// Create proxy object

lo_res = proxy_obj.getreportscategory("98e03348f20cf62c735993d0fea96359", "Volcado_AMC_Carcer",dp_1.text,0,50000,dp_1.text)

la_informes = lo_res.tabcategoria.informes





messagebox("Respuesta", lo_res.Resultado)

messagebox("Id Categoria", lo_res.TabCategoria.IdCategoria)

messagebox("Id Nube", lo_res.TabCategoria.IdNube)







catch ( SoapException e )

messagebox ("Error", "WS no accesible")



end try



destroy conn





Thank you again Marco and Chris,



Pepe.

Ciao Pepe,

I hope you understood now the principle behind PB proxies.

You can access *any* structured data types provided by SOAP/XML WS.

Whenever you need to handle non-primitive data types, the corresponding PB NVOs will be created in you library by the proxy project.

Deploy the proxy project and all is needed for the Web Service client gets into your PBL.

If the WS accepts/returns *nested* structured objects, just use dot notation as in my previous example.

Best regards,

.m

Hi Marco, I think it's understood.

The thing is that the "results" of the category are in the very bottom of the result, and I can't (don't know how) access them.

I've created a variable "lt_informe" of the type tabinformes, and I want to save the "usuario" field.

I create a variable ls_usuario of the type string, and code:

ls_usuario = lt_informe.usuario

I messagebox to see the result and compiles ok, but the execution shows a Null Object Reference.

At the beginning I've changed the lo_res variable to

lo_res = proxy_obj.getreportscategory("98e03348f20cf62c735993d0fea96359", "Volcado_AMC_Carcer",dp_1.text,0,50000,dp_1.text).tabcategoria ,

So I've gone a level further in the XML response...