topic Re: Parsing XML response of an external web service in webscript in Alfresco Archive

Parsing XML response of an external web service in webscript

a_kholodkov — Mon, 14 Jan 2013 09:44:56 GMT

Hello,I`ve been unsuccesfully trying to do a really general thing in Alfresco two days already :x - to parse XML-response of an external web service and show it in Share.I have made a custom page in Share to show result, set up endpoint for the web service, written a web script etc. Everything w

Re: Parsing XML response of an external web service in webscript

abarisone — Mon, 14 Jan 2013 09:53:28 GMT

Hi,
try to follow this http://freemarker.sourceforge.net/docs/xgui_imperative_learn.html since it may be useful for you needs.

Regards,
Andrea

Re: Parsing XML response of an external web service in webscript

a_kholodkov — Mon, 14 Jan 2013 16:46:22 GMT

Andrea, thank you.

But I had tried. This didn`t work for me. As I use JavaScript control script to request web service, not Java-backed.
In this example is used Java for "Putting the XML into the data-model".

I know I can use Java, but I want to proceed so simple task without Java-coding using embedded tools of Surf.

Re: Parsing XML response of an external web service in webscript

a_kholodkov — Tue, 15 Jan 2013 08:57:54 GMT

I have found the solution!

This is using "stringUtils.parseXMLNodeModel" method in *.js:

var xmlDocModel = stringUtils.parseXMLNodeModel(xmlResp);
model.doc = xmlDocModel;‍‍

Then it is possible to proceed any required operation on XML including using XPath in *.ftl:

<#ftl ns_prefixes={ "soap":"http://schemas.xmlsoap.org/soap/envelope/"}>
           
<#list doc["/soap:Envelope/soap:Body/getCasesResponse/getCasesResult/processes/process"] as p>
<h2>${p.processId}</h2>
</#list> ‍‍‍‍‍

Hope this will be helpfully for anybody.

Regards,
Anton

Re: Parsing XML response of an external web service in webscript

valfontanette — Fri, 23 May 2014 19:06:06 GMT

Hi,

I am having trouble to get this working.
It seems my conversion to string doesn't work.

I need to read a xml file, get some tags and create spaces in my structure.
I am doing some tests. Like this:

var doc = document.content; // my uploaded xml
var doc_str = new String(doc);

var nfeProc = new XML("<nfeProc><teste>35</teste></nfeProc>"); // a xml test

//var nfeProc = new XML(doc_str.substring(0, doc_str.length));

var str_imp = nfeProc.teste ;

var logFile = space.childByNamePath("log.txt");
if (logFile == null)
{
logFile = space.createFile("log.txt");
}
logFile.content = "";

logFile.content =str_imp;
logFile.save();

When I create a XML file in my javascript I can manipulate the tags and it works ok. But when I try to do the same with my imported xml file it doesn't work. I compared types but they are not the same.

Can you help me?

Thanks for your attention

Re: Parsing XML response of an external web service in webscript

kaynezhang — Wed, 28 May 2014 15:59:56 GMT

You don't need to convert it to string ,just write as following .it will work


var fileContent = document.content;
var xml = new XML(fileContent);
‍‍‍‍

And please remeber xml stands for root element,if the content of your document is


<nfeProc><teste>35</teste></nfeProc>
‍‍‍

and you want to get value of teste,you can just write like this


var fileContent = document.content;
var xml = new XML(fileContent);
xml.teste
‍‍‍‍‍

Re: Parsing XML response of an external web service in webscript

valfontanette — Thu, 29 May 2014 15:56:00 GMT

Hi,

Thanks for your help.

I tried this but it returns this (the entire xml content) and not "35".

<nfeProc>
<teste>35</teste>
</nfeProc>

I had this result from these 2 tests:

1)
var fileContent = document.content;
var xml = new XML(fileContent);
xml.teste;

2)
var xml = new XML("<nfeProc><teste>35</teste></nfeProc>");
xml.teste;

I don't know whatelse to do to get the tag content.

Am I doing something wrong?
Should I have to install something?

Thanks

Re: Parsing XML response of an external web service in webscript

kaynezhang — Thu, 29 May 2014 16:04:24 GMT

You don't need to install anything,plese paste your xml content of your document here.

Re: Parsing XML response of an external web service in webscript

valfontanette — Thu, 29 May 2014 20:17:41 GMT

Hi,
My xml file is attached.

My script is like this:

var fileContent = document.content;
var xml = new XML(fileContent);

After this I am not able to navigate throw xml content. So, I had tried with a simple xml file (the one I used before)

Thanks for your help.

Re: Parsing XML response of an external web service in webscript

kaynezhang — Fri, 30 May 2014 00:06:41 GMT

For your xml sample content


<nfeProc>
   <NFe>
      <infNFe>
         <ide>
            <cUF>35</cUF>
         </ide>
      </infNFe>
   </NFe>
</nfeProc>
‍‍‍‍‍‍‍‍‍‍‍

if you want to get value of /nfeProc/NFe/infNFe/ide/cUF （value is 35)，you should write it like this

 var cUF = xml.NFe.infNFe.ide.cUF;‍

Following is sample code ,I also add some log information which will print in console for you to check if it works.
It works fine in my test envirenmont


logger.getSystem().out("####BEGIN  #####  " );
var fileContent = document.content;
var xml = new XML(fileContent);
logger.getSystem().out("#### XML CONTENT  #####  " + xml);
var cUF = xml.NFe.infNFe.ide.cUF;
logger.getSystem().out("#### cUF value is ####  " + cUF);
‍‍‍‍‍‍‍‍

Re: Parsing XML response of an external web service in webscript

valfontanette — Fri, 30 May 2014 15:38:47 GMT

Hi,

Thanks a lot! It works!
After all I realized my script wasn't working because my log test (somehow it didn't work out with this)

var fileContent = document.content;
var xml = new XML(fileContent);
var cUF = xml.NFe.infNFe.ide.cUF;

//LOG TEST (wrong)

var logFile = space.childByNamePath("log.txt");
if (logFile == null)
{
logFile = space.createFile("log.txt");
}
logFile.content = "";
logFile.content = cUF; // it returns a blank log
logFile.save();

Thanks a lot!

Re: Parsing XML response of an external web service in webscript

kaynezhang — Fri, 30 May 2014 18:02:39 GMT

Good luck.
And a little advice,next time when you paste your code ,you can wrap it within <code> </code ,it is easy for others to read.