Expose Google doc content as JSON | Community
Skip to main content
S
SahilDh1
Level 2
May 17, 2024
Solved

Expose Google doc content as JSON

  • May 17, 2024
  • 4 replies
  • 2214 views

Hi,
I'm working on Edge Delivery Services via Document-based authoring (Google Docs). I want to expose my content in Google Docs as JSON. How can I do this? 

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 ShaileshBassi

Hi @sahildh1 For exposing the content which is already in the form of excel, you can directly do it as stated by @ana-ensemble.

For getting the data which is in the form of the google docs here you can create the custom index definition and then use it with the selected fields which could be leveraged outside.

Example - https://github.com/adobe/theblog/blob/master/helix-query.yaml

 

Other way could be use of the content fragment and consume those within your EDS application for creation of the page. This way the query based content optimization delivery can also be targeted.

 

Hope this helps!

Thanks  

4 replies

K
KeerthanaS
Level 2
May 17, 2024

Hi @sahildh1 
      You can use Google Spreadsheet which will return the content in JSON format if you click the preview button in the spreadsheet you can see JSON data.
You can try this way.


Thanks
Keerthana

    A
    Ana-Ensemble
    Level 2
    May 23, 2024

    Hello,

    AEM Geeks has a great tutorial on YouTube about this. As mentioned in the other comment, you can use spreadsheets for your use case.

    Here is the tutorial link.

    All the best,

    Ana

      ShaileshBassi
      Community Advisor
      ShaileshBassiCommunity AdvisorAccepted solution
      Community Advisor
      June 24, 2024

      Hi @sahildh1 For exposing the content which is already in the form of excel, you can directly do it as stated by @ana-ensemble.

      For getting the data which is in the form of the google docs here you can create the custom index definition and then use it with the selected fields which could be leveraged outside.

      Example - https://github.com/adobe/theblog/blob/master/helix-query.yaml

       

      Other way could be use of the content fragment and consume those within your EDS application for creation of the page. This way the query based content optimization delivery can also be targeted.

       

      Hope this helps!

      Thanks  

        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        July 23, 2024

        @sahildh1 Did you find the suggestion helpful? Please let us know if you require more information. Otherwise, please mark the answer as correct for posterity. If you've discovered a solution yourself, we would appreciate it if you could share it with the community. Thank you!

        Kautuk Sahni
        Terms & ConditionsAccessibility statement

        Loading footer...