topic Re: Json for updating meta-data in Alfresco Archive

Json for updating meta-data

arpit_gupta — Tue, 18 Oct 2011 11:05:37 GMT

I need to update meta data of my documents using Rest api(web script).I am calling the following service with posting the json file containing the metadata.http://192.168.100.106:8180/alfresco/service/api/metadata/node/workspace/SpacesStore/67f7081b-7236-4174-a070-cfeb44fac8bd?alf_ticket=TICKET_e08c

Re: Json for updating meta-data

mrogers — Tue, 18 Oct 2011 12:17:52 GMT

Your URL seems to have been truncated.

Which script are you using and what are you posting to it?

Re: Json for updating meta-data

arpit_gupta — Tue, 18 Oct 2011 12:29:33 GMT

Thanks for the reply

i am using default meta data storage script. Description can be found here http://wiki.alfresco.com/wiki/Repository_RESTful_API_Reference#Node_Metadata_Storage_Service.

Re: Json for updating meta-data

arpit_gupta — Tue, 18 Oct 2011 12:42:14 GMT

Script used for the service is

File: org/alfresco/repository/metadata/metadata.post.json.js


main();

function main()
{
   if (url.templateArgs.store_type === null)
   {
      status.setCode(status.STATUS_BAD_REQUEST, "NodeRef missing");
      return;
   }

   // nodeRef input
   var storeType = url.templateArgs.store_type;
   var storeId = url.templateArgs.store_id;
   var id = url.templateArgs.id;
   var nodeRef = storeType + "://" + storeId + "/" + id;
   var node = search.findNode(nodeRef);
   if (node === null)
   {
      status.setCode(status.STATUS_NOT_FOUND, "Not a valid nodeRef: '" + nodeRef + "'");
      return null;
   }

   // Set passed-in properties
   if (json.has("properties"))
   {
      var properties = jsonToObject("properties");
      for (property in properties)
      {
         node.properties[property] = properties[property];
      }
   }

   // Set passed-in mimetype
   if (json.has("mimetype"))
   {
      node.mimetype = json.get("mimetype");
   }
   
   // Set passed-in tags
   if (json.has("tags"))
   {
      // Get the tags JSONArray and copy it to a native JavaScript array
      var jsonTags = json.get("tags"),
         tags = [];
      
      for (var t = 0; t < jsonTags.length(); t++)
      {
         tags.push(jsonTags.get(t));
      }

      if (tags.length > 0)
      {
         node.tags = tags;
      }
      else
      {
         node.clearTags();
      }
   }
   node.save();
}

function jsonToObject(p_name)
{
   var object = {};
   var jsonObj = json.get(p_name);
   var names = jsonObj.names();
   var name;
   for (var i = 0, j = names.length(); i < j; i++)
   {
      name = names.get(i);
      object[name] = jsonObj.get(name);
   }
   return object;
}

function jsonToArray(p_name)
{
   var array = [];
   var jsonArray = json.get(p_name);
   for (var i = 0, j = jsonArray.length(); i < j; i++)
   {
      array.push(jsonArray.get(i));
   }
   return array;
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Json for updating meta-data

arpit_gupta — Thu, 20 Oct 2011 13:24:05 GMT

and the json i am posting is

{
    "properties":{
          "{http://www.alfresco.org/model/content/1.0}agreement_id':'1234",
         "{http://www.alfresco.org/model/content/1.0}property_id':'4567"
      }
}
but still it's not working.
am i missing something?
please help me out…

Re: Json for updating meta-data

tremalnaik — Mon, 12 Dec 2011 12:34:20 GMT

Hi,

I have the same problem although I using Java and do not working in spite of this, the return message is always "success"…

Re: Json for updating meta-data

arpit_gupta — Thu, 15 Dec 2011 09:30:18 GMT

Issue is resolved now.

I was not setting the request content type correctly.

StringEntity entity = new StringEntity(getMetaDataAsJson(metadata));
entity.setContentType(new BasicHeader(HTTP.CONTENT_TYPE, "application/json"));

This resolved my problem…

Re: Json for updating meta-data

tremalnaik — Thu, 15 Dec 2011 13:01:36 GMT

Thank you so much!

This has been the clue to resolve my problem.

An example just in case somebody uses Abdera o similar to the operation in Java:


Abdera abdera = new Abdera();
AbderaClient client = new AbderaClient(abdera);

String uri = "http://localhost:8080/alfresco/service/api/metadata/node/workspace/SpaceStore/{id}?alf_ticket=ticket";

String jsonMessage ="{\"properties\":{\"cm:title\":\"Texas\",\"cm:description\":\"Descripción de Texas\"}}";
InputStream is = Utilidades.stringToInputStream(jsonMessage);

RequestOptions options = new RequestOptions();
options.setHeader("Content-Type", "application/json");

ClientResponse resp = client.post(uri, is, options);
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Json for updating meta-data

anujcb — Fri, 24 Apr 2015 10:56:06 GMT

how will you set multi value properties in the above format? Is there another way other than using json? Can the properties be set during upload or is it a separate call?

Re: Json for updating meta-data

anujcb — Fri, 24 Apr 2015 11:25:00 GMT

The upload url:::http://127.0.0.1:8080/alfresco/service/api/metadata/node/workspace/SpaceStore/de17d530-1f13-4eb1-91b5-7049892a5055/?alf_ticket=TICKET_59042c5169df381c8edd2a9b1b55d186f3f98720


HTTP/1.1 404 Not Found
body 
{
    "status" : 
  {
    "code" : 404,
    "name" : "Not Found",
    "description" : "Requested resource is not available."
  },  
  
  "message" : "Not a valid nodeRef: 'workspace:\/\/SpaceStore\/de17d530-1f13-4eb1-91b5-7049892a5055\/'",  
  "exception" : "",
  
  "callstack" : 
  [ 
        
  ],
  
  "server" : "Community v5.0.0 (c r91299-b145) schema 8,009",
  "time" : "Apr 24, 2015 4:21:29 AM"
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Here is the code


         urlString = "http://'+ipaddress+':8080/alfresco/service/api/metadata/node/workspace/SpaceStore/'+nodeId+'/?alf_ticket="
               + authTicket;
         System.out.println("The upload url:::" + urlString);
         client = new HttpClient();

         mPost = new PostMethod(urlString);
         itemNameValue=new ArrayList();
         itemNameValue.addAll(Arrays.asList(new String[] { "Item1","Item2"}));

         String jsonMessage ="{\"properties\":{\"rs:vendor\":\"Texas\",\"rs:itemName\":\"Descripción de Texas\"}}";
         InputStream stream = new ByteArrayInputStream(jsonMessage.getBytes(StandardCharsets.UTF_8));
         
         mPost.addRequestHeader("Content-Type", "application/json");
         mPost.setRequestBody(stream);
         

         statusCode1 = client.executeMethod(mPost);
         System.out.println("statusLine>>>" + statusCode1 + "……"
               + "\n status line \n" + mPost.getStatusLine() + "\nbody \n"
               + mPost.getResponseBodyAsString());
         mPost.releaseConnection();      
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍