Way to generate a spreadsheet/html table from all Guide JSON data export of our help articles?

4 コメント

  • Jim Davenport

    Hey blake,

    What you're describing sounds like a use case for one of our apps in the Zendesk App Marketplace. It allows you to import content from any Zendesk Help Center into the app and edit it using the app's interface (which is essentially an editable table). There's an export to CSV option if you prefer to make changes outside the app.

    Once you're done you can import the data back into Zendesk Guide (and even supports importing from CSV, if required).

    It is a paid app, so perhaps not what you're looking for, but would avoid the need for you to write custom code yourself.  In terms of alternatives, I think you're on the right track. If I were building something from scratch I'd write a NodeJS script to fetch the data from the Zendesk REST API and produce the required output.




  • Blake A

    Fantastic thanks Jim! I will check out the Help Center Import app, and thanks for the development advice too! Really appreciate the comment!

  • Danila Slezko

    hi Blake A

    you could create JS script with Get request code something like this:

     $.getJSON(`/api/v2/help_center/articles?per_page=100`, function (data) { 
     - all data about all articles from your help center. Use ForEach and get necessary data from articles -  URL, title and labels. 
    all information about API and articles data you could find: https://developer.zendesk.com/rest_api/docs/help_center/articles  
  • Blake A

    Danila Slezko Thank you! I will work on that next. Below I found a convoluted way around using scripting in Google Sheets! I will reply to you if I am able to code up what you have shown. 


    Good news! I thought outside the box! Below is a cheap way to yank out the raw data from Zendesk and into Google Spreadsheets! 

    1. Figure out your JSON URL! I used our Zendesk help article url: https://name.zendesk.com
    2. You can export JSON data from the KB articles by figuring out your own Zendesk Guide URL here: https://developer.zendesk.com/rest_api/docs/help_center/articles
    3. So add step one and two together to get a full API URL, for example: https://name.zendesk.com/api/v2/help_center/en-us/articles.json?page=1
    4. You can chage the page=1 to something like page=2 for page 2 etc. We have like 15 pages of help articles. 
    5. I then stumbled upon this blog post and it turns out that you can import directly into Google Spreadsheet all the JSON data! See: https://blog.datawrapper.de/live-json-in-google-sheets/
    6. Look at the blog post and set up Google Sheets with the code from the above blog into the Script Editor in your Google Sheets spreadsheet.
    7. Once the Script is in, you can look at the blog's covid example in Colum A, Row 1 and use your own Zendesk API URL. See the example below of our URL in the spreadsheet: 
    8. Now you can copy the data into different Sheets or delete columns to make the spreadsheet easier to view. Enjoy!


Powered by Zendesk