Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Exporting data stored in CQ scaffolds

jond1978
Level 2
Level 2

Hi,

We are in a situation where we need to export the data stored in CQ's scaffold structure in excel format (Our initial plan is to make use of Excel's power query for the same). Is there a built in way to export the JCR data into json feed, or should we need to create a custom service for the purpose?


Thanks in advance

1 Accepted Solution
kautuk_sahni
Correct answer by
Community Manager
Community Manager

Hi 

You can achieve this by :-

Option 1 

Link:- https://docs.adobe.com/docs/en/aem/6-0/develop/ref/javadoc/org/apache/sling/commons/json/jcr/JsonJcr...

There is a Class, JsonJcrNode, this class makes it easy to create a json object out of a JCR node.

//

public class JsonJcrNode

 

extends JSONObject

This class makes it easy to create a JSON object out of a JCR node. It is a shameless copy of JsonItemWriter, but instead of writing the resulting JSON directly to an output, you get a JSONObject that you can deal with.

 

Option 2

Link:- https://docs.adobe.com/docs/en/aem/6-1/develop/components/pageinfo.html

//Obtaining page information in json Format

 

I hope this would help you.

Thanks and Regards

Kautuk Sahni

View solution in original post

1 Reply
kautuk_sahni
Correct answer by
Community Manager
Community Manager

Hi 

You can achieve this by :-

Option 1 

Link:- https://docs.adobe.com/docs/en/aem/6-0/develop/ref/javadoc/org/apache/sling/commons/json/jcr/JsonJcr...

There is a Class, JsonJcrNode, this class makes it easy to create a json object out of a JCR node.

//

public class JsonJcrNode

 

extends JSONObject

This class makes it easy to create a JSON object out of a JCR node. It is a shameless copy of JsonItemWriter, but instead of writing the resulting JSON directly to an output, you get a JSONObject that you can deal with.

 

Option 2

Link:- https://docs.adobe.com/docs/en/aem/6-1/develop/components/pageinfo.html

//Obtaining page information in json Format

 

I hope this would help you.

Thanks and Regards

Kautuk Sahni

View solution in original post