Alfresco webscript to get the list of all files and folder with their size

CMIS Query:

select cmis:objectId, cmis:name, cmis:contentStreamLength 
from cmis:document 
where cmis:contentStreamLength>0 
order by cmis:contentStreamLength desc

• HTTP GET:

  http://localhost:8080/alfresco/api/-default-/public/cmis/versions/1.1/browser/
    ?cmisselector=query
    &succinct=true
    &q=select cmis:objectId, cmis:name, cmis:contentStreamLength from cmis:document where cmis:contentStreamLength>0 order by cmis:contentStreamLength desc
  

• JavaScript:

  Use search root object:

  search - org.alfresco.repo.jscript.Search - Root object providing access to the various Alfresco search interfaces such as FTS-Alfresco, Lucene, XPath, and Saved Search results

  var rs=search.query({
      query:"select * from cmis:document where cmis:contentStreamLength>0 order by cmis:contentStreamLength desc",
      language:"cmis-alfresco"         
  });
  
  for (var r in rs){
      logger.log(rs[r].parent.nodeRef.id+"/"+rs[r].nodeRef.id+"\t"+rs[r].parent.name+"/"+rs[r].name+"\t"+rs[r].size);
  }
  

Yes it is possible. you can get the all folders,subfolders,and all the files using repository javascript Please try this code give proper path values

var path="Data Dictionary/***";
var documentLibrary = companyhome.childByNamePath("path");

var children = documentLibrary.children;

traverse(children);

function traverse(nodes){
  for each(var node in nodes) {
    if (node.isContainer){
      logger.log(node.name + " is a folder, traversing down");
      traverse(node.children);
    }else {
      logger.log(node.name ); 
        logger.log(node.size); 
    }
  }
}