topic Document's properties via WebScript in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/document-s-properties-via-webscript/m-p/206387#M159517 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>I have a strange problem. I wrote a simple WebScript which should retrieve documents and its properties for defined category. Here is my code:</SPAN><BR /><BR /><SPAN>var categoryNode = search.luceneSearch("PATH:\"" + args.path + "\"");</SPAN><BR /><SPAN>if (categoryNode == undefined)</SPAN><BR /><SPAN>{</SPAN><BR /><SPAN>&nbsp;&nbsp; status.code = 404;</SPAN><BR /><SPAN>&nbsp;&nbsp; status.message = "Kategoria o referencji: " + args['path'] + " nie zostala znaleziona.";</SPAN><BR /><SPAN>&nbsp;&nbsp; status.redirect = true;</SPAN><BR /><SPAN>}</SPAN><BR /><SPAN>else</SPAN><BR /><SPAN>{</SPAN><BR /><SPAN>&nbsp;&nbsp; // perform category search</SPAN><BR /><SPAN>&nbsp;&nbsp; model.categoryFiles = search.luceneSearch("PATH:\"" + args.path + "//member\"");</SPAN><BR /><SPAN>}</SPAN><BR /><BR /><SPAN>This code works quite good. As an args.path I use qnamePath of the Category Node which I retrieve in other WebScript. The code is based on one of the WebScripts in the wiki page WebScripts Examples.</SPAN><BR /><BR /><SPAN>Response Template:</SPAN><BR /><SPAN>{</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; "feed": {</SPAN><BR /><SPAN>&nbsp; &lt;#assign x = 0&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&lt;#list categoryFiles as child&gt;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN> &lt;#if child.isContainer == false&gt; </SPAN><BR /><SPAN>&nbsp; &lt;#assign x = x+1&gt;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "entry${x}": {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "param_title": "${child.name}",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#list child.properties?keys as t&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#– If the property exists –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if child.properties[t]?exists&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#– If it is a date, format it accordingly–&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#if child.properties[t]?is_date&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "param_${t}" : "${child.properties[t]?date}",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#– If it is a boolean, format it accordingly–&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#elseif child.properties[t]?is_boolean&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "param_${t}" : "${child.properties[t]?string("yes", "no")}",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#– Otherwise treat it as a string –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#else&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "param_${t}" : "${child.properties[t]}",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/#if&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/#if&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/#list&gt;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#assign y = 0&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#list child.aspects as asp&gt;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "aspect${y}" : "${asp}",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#assign y = y+1&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/#list&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "param_href": "${absurl(url.serviceContext)}/api/node/content/${child.nodeRef.storeRef.protocol}/${child.nodeRef.storeRef.identifier}/${child.nodeRef.id}/${child.name?url}",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "param_icon" : "${url.context}${child.icon32}",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "param_nodeRef" : "${child.nodeRef}",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "param_nodeType" : "${child.type}",</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "param_size" : "${child.size}" </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; },</SPAN><BR /><SPAN>&nbsp; &lt;/#if&gt;&nbsp; </SPAN><BR /><SPAN>&lt;/#list&gt;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "updated": "${xmldate(date)}"</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; }</SPAN><BR /><SPAN>}</SPAN><BR /><BR /><BR /><SPAN>And here id the problem. When I try to create JSON response I receive an error. It is connected with above Response Template. Everything works fine when I delete lines:</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#– Otherwise treat it as a string –&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;#else&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "param_${t}" : "${child.properties[t]}",</SPAN><BR /><SPAN>but then there are no String properties in the response. I would like to mention that I use the same RESPONSE TEMPLATE for my other WebScripts and everything is fine. </SPAN><BR /><BR /><SPAN>Can anyone help me with this issue?</SPAN><BR /><BR /><SPAN>Thanks in Advance,</SPAN><BR /><SPAN>Kamil Warcaba</SPAN></BODY></HTML> Fri, 14 Nov 2008 15:51:30 GMT k_warcaba 2008-11-14T15:51:30Z Document's properties via WebScript https://connect.hyland.com/t5/alfresco-archive/document-s-properties-via-webscript/m-p/206387#M159517 Hi all,I have a strange problem. I wrote a simple WebScript which should retrieve documents and its properties for defined category. Here is my code:var categoryNode = search.luceneSearch("PATH:\"" + args.path + "\"");if (categoryNode == undefined){&nbsp;&nbsp; status.code = 404;&nbsp;&nbsp; status.message = "Kategoria Fri, 14 Nov 2008 15:51:30 GMT https://connect.hyland.com/t5/alfresco-archive/document-s-properties-via-webscript/m-p/206387#M159517 k_warcaba 2008-11-14T15:51:30Z Re: Document's properties via WebScript https://connect.hyland.com/t5/alfresco-archive/document-s-properties-via-webscript/m-p/206388#M159518 <HTML><HEAD></HEAD><BODY><SPAN>I have solved the problem. I have to replace lines: </SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>&lt;#– Otherwise treat it as a string –&gt;<BR />&lt;#else&gt;<BR />"param_${t}" : "${child.properties[t]}",<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>With:</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;#– Otherwise treat it as a string –&gt;<BR />&lt;#elseif child.properties[t]?is_string&gt;<BR />"param_${t}" : "${child.properties[t]}",<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Mon, 17 Nov 2008 11:19:09 GMT https://connect.hyland.com/t5/alfresco-archive/document-s-properties-via-webscript/m-p/206388#M159518 k_warcaba 2008-11-17T11:19:09Z