topic Re: Controller and JSON in Alfresco Archive

Controller and JSON

sihnu — Tue, 17 Mar 2015 07:39:38 GMT

Hi,in our current project we have created a webscript that starts a workflow by definition name. The webscript works fine. Now problem is that there are some bunch of properties that should be multiplied. We thought different scenarios to solve this problem and finally we came up with a solution whe

Re: Controller and JSON

muralidharand — Tue, 17 Mar 2015 08:06:33 GMT

Hi,
The "EmployeeList" is a plain string and it is not a collection and as far I know, you can not convert string to JSON in FTL. Otherwise, you need to write a separate library to convert the string to JSON object.
I would recommend, from the controller side, you should be able to convert the string to JSON (in Both Javascript controller + Java controller) and do the iteration in the FTL.

Please let me know, if you're not clear.

Thanks
Murali

Re: Controller and JSON

sihnu — Tue, 17 Mar 2015 08:35:17 GMT

Hi,

thanks a lot for the response. Okay, I know how to convert json in javascript but how do I iterate the object in freemarker? I would rather do it in freemarker than in javascript.

Here is my script:


<script language="Javascript" type="text/javascript">//<![CDATA[
    var employees = json.parse(${field.value});
//]]></script>‍‍‍‍

I guess this should work for parsing to json object in javascript.

Re: Controller and JSON

muralidharand — Tue, 17 Mar 2015 08:35:59 GMT

Hi,
I created a very simple sample webscript for you.

Use the eval() method to convert jsonString to JSON object in the Javascript controller.
If you're using java controller, in the Java code, convert the json string to JSON object.

employee.get.js


var jsonString = '[{"name": "Fred Bloggs", "email": "fred@test.com", "id": "123456"},{"name": "John Smith", "email": "john@test.com", "id": "456789"},{"name": "Bob Brown", "email": "bob@test.com", "id": "987654"}]';

//use the eval method to convert jsonString to JSON object.

model.employeeLis = eval('(' + jsonString + ')');
‍‍‍‍‍‍‍

employee.get.json.ftl


<#list employeeList as emp>
   ${emp.name}
</#list>
‍‍‍‍‍

employee.get.desc.xml


<webscript>
  <shortname>example-webscript</shortname>
  <description>Simple Webscript</description>
  <url>/com/quanitcate/example</url>
  <format default="json">any</format>  
  <authentication>user</authentication>  
</webscript>
‍‍‍‍‍‍‍‍‍

Hope this helps you !

Re: Controller and JSON

muralidharand — Tue, 17 Mar 2015 08:38:00 GMT

Hi,
Where are you trying to convert json string to JSON object ?
In Share side or Repo side?

Re: Controller and JSON

sihnu — Tue, 17 Mar 2015 08:47:31 GMT

Hey, thanks for the reply again.

I'm trying to do it at share (client) side. The thing is that custom controllers are not so familiar to me. I know I get the json as field.value (one of the fields in the form uses the controller, defined in share-config-custom.xml). I wonder if I can create a javascript file for the controller that could be ran in server side. Do the controllers work the same way as webscripts? How would I run the javascript? How should I tell that to Alfresco (naming of the file etc.)? I know this post is now out of topic. I'm sorry about that.

Re: Controller and JSON

sihnu — Tue, 17 Mar 2015 08:50:09 GMT

So I could create a web script that returns HTML and then I could include that to my template. I guess that could work if I can't do it straight away. Thanks, this is nicer solution than creating the fields with javascript.

Re: Controller and JSON

muralidharand — Tue, 17 Mar 2015 09:31:30 GMT

Hi,
To know more about webscript, please use the below uris.

https://wiki.alfresco.com/wiki/Web_Scripts
https://wiki.alfresco.com/wiki/Web_Scripts_Examples

There are already out of box share webscripts are available with similar approach.

The Share webscript reads the data from repository and do the iteration in the html.ftl file rather than the json.ftl file.
People prefers .html.ftl to bind the data directly to the page.
For ex, dashlets are built by using webscripts. It takes the data from the repository and renders it directly in the dashlets and few dashlets calls the repo webscript directly from the client-side javascript and renders the data into dashlets.

My Tasks Dashlet:
It uses the AJAX request (my-tasks.js) to get the data from the repository and it uses the YUI datatable to render the data.

Site Members Dashlet:
It reads the data from repository by using "colleagues.get.js" to read the data and it uses "colleagues.get.html.ftl" file to render the site members.

Controllers:
Controller is a part of webscript.

Running Javascript.
If it is client side javascript, you need to include the javascript in the .headd.ftl file.
If it is a controller javascript, follow the proper webscript naming convention to execute the server side javascript file.

Please let me know, if you're not clear.

Re: Controller and JSON

rjohnson — Tue, 17 Mar 2015 12:55:15 GMT

Try <#assign jsonVariable = string_variable?eval>

Re: Controller and JSON

sihnu — Tue, 17 Mar 2015 14:18:03 GMT

Hi,

this is exactly what I wanted and now it works! Thanks a lot. I already created webscript for converting json to html where I first "converted" String to JSON and returned HTML However, I got the same error as before. Freemarker didn't treat the value as json object/array (the freemarker template in webscript). I think I don't need the extra webscript for converting anymore. I'm pretty sure this should work in the controller template as well.I just need to test it. Once again thank you.