Can you use AEM Query Builder to pull Metadata values as JSON? | Community
Skip to main content
J
jwendling
Level 2
April 1, 2022
Solved

Can you use AEM Query Builder to pull Metadata values as JSON?

  • April 1, 2022
  • 3 replies
  • 2015 views

We are wanting to create a string of metadata values that will return only those wanted values as JSON. Can AEM Query builder be used to build this query or test it? If so, are there are documents around what metadata values are available?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by DEBAL_DAS

Let's assume I am targeting list of properties like dc:format , dam:size, dc:modified of each asset under specific DAM path /content/dam/we-retail/en/people/mens

So here is my query -

 

type=dam:Asset
path=/content/dam/we-retail/en/people/mens
p.hits=selective
p.properties=jcr:content/metadata/dc:format jcr:content/metadata/dam:size jcr:content/metadata/dc:modified

 

using p.properties , I have specified the properties I want to get in as shown below -

Now if I copy and JSON QueryBuilder link as shown below -

 

http://localhost:7070/bin/querybuilder.json?p.hits=selective&p.properties=jcr%3acontent%2fmetadata%2fdc%3aformat%20jcr%3acontent%2fmetadata%2fdam%3asize%20jcr%3acontent%2fmetadata%2fdc%3amodified&path=%2fcontent%2fdam%2fwe-retail%2fen%2fpeople%2fmens&type=dam%3aAsset

 

Then I am getting  below JSON response -

 

Are you expecting this? Please correct me.

 

Please refer this: https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/querybuilder-api.html?lang=en

 

 

 

 

3 replies

Nitin_laad
Community Advisor
Nitin_laadCommunity Advisor
Community Advisor
April 1, 2022

@jwendling You can write a java servlet to query metadata in jcr and return queried data as JSON object. 

Ex:- https://aem4beginner.blogspot.com/a-servlet-to-query-pages-containing

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/query-to-fetch-assets-where-jcr-content-metadata-jcr/td-p/207529

    DEBAL_DAS
    DEBAL_DASAccepted solution
    April 2, 2022

    Let's assume I am targeting list of properties like dc:format , dam:size, dc:modified of each asset under specific DAM path /content/dam/we-retail/en/people/mens

    So here is my query -

     

    type=dam:Asset
    path=/content/dam/we-retail/en/people/mens
    p.hits=selective
    p.properties=jcr:content/metadata/dc:format jcr:content/metadata/dam:size jcr:content/metadata/dc:modified

     

    using p.properties , I have specified the properties I want to get in as shown below -

    Now if I copy and JSON QueryBuilder link as shown below -

     

    http://localhost:7070/bin/querybuilder.json?p.hits=selective&p.properties=jcr%3acontent%2fmetadata%2fdc%3aformat%20jcr%3acontent%2fmetadata%2fdam%3asize%20jcr%3acontent%2fmetadata%2fdc%3amodified&path=%2fcontent%2fdam%2fwe-retail%2fen%2fpeople%2fmens&type=dam%3aAsset

     

    Then I am getting  below JSON response -

     

    Are you expecting this? Please correct me.

     

    Please refer this: https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/querybuilder-api.html?lang=en

     

     

     

     

      srnya
      srnya
      Level 2
      April 2, 2022

      @jwendling 
      AEM Query builder can be used to query the repository and get a list of nodes (javax.jcr.node) or hits (com.day.cq.search.result.Hit)

      To get specific properties or metadata from each node, we will have to have custom implementations, via a sling model/OSGi servlet/OSGi service.
      Hope this helps.

       

       

       

       

       

       

        Terms & ConditionsAccessibility statement

        Loading footer...