How to export Zendesk macros into a spreadsheet

46 Kommentare

  • Brett - Community Manager
    Aktionen für Kommentare Permalink

    Hi CSM Zendesk,

    Could you clarify what sort of data you're looking to export in regards to macros?

    Just want to make sure we're both on the same page here :)

    0
  • Mary Paez
    Aktionen für Kommentare Permalink

    WOW!  This was fast and easy!  Thank you for this post.  It was very helpful.

     

    Do you have something similar for exporting a report from the Zendesk Manage articles UI based on applying a filter?

    0
  • Brett - Community Manager
    Aktionen für Kommentare Permalink

    Hey Mary,

    There are are a couple of options for exporting Help Center content as mentioned here: Help Center data export

    The most common method I've seen is through Kbackup integration that was developed in our App Marketplace: kBackup

    If you have any questions regarding the integration you'll want to reach out to the developer directly.

    Hope this helps!

    0
  • Kelly Scarbrough
    Aktionen für Kommentare Permalink

    Thank you so much for this.  You probably just saved me HOURS of typing!

    0
  • Syd S.
    Aktionen für Kommentare Permalink

    We've been using the https://XYZ.zendesk.com/api/v2/macros.json?group_id=XXXXX option to download macros based on the group, but cannot figure out how to get the next page of macros for that specific group. Does anyone know how to do that?

    0
  • Graeme Carmichael
    Aktionen für Kommentare Permalink

    Syd S

    Try this:

    https://XYZ.zendesk.com/api/v2/macros.json?group_id=XXXXX&page=2

    Or look for the 'next page:' url near the end of your output:

     

    1
  • Syd S.
    Aktionen für Kommentare Permalink

    Thank you so much Graeme! Worked like a charm. 

    0
  • Mugeni Mukanga
    Aktionen für Kommentare Permalink

    Worked perfectly first time. 

     

    Thank you!

    0
  • Rebekah McKinney-Perry
    Aktionen für Kommentare Permalink

    Super helpful, thanks a mil! :) 

    0
  • Vladan Jovic
    Aktionen für Kommentare Permalink

    Thanks for the feedback, Rebekah. Very glad to hear that! 

    I just spotted this post is created precisely 3 years ago :O 
    The days are long and the years are short. :)

    0
  • Matthew Watts
    Aktionen für Kommentare Permalink

    Thanks to OP.

    I am just not clear on point 2a and 2b

     

    "2. open this link XYZ.zendesk.com/api/v2/macros.json?per_page=99 (but change XYZ to your zendesk account name)
    2a. If you have more than 100 macros, you should export one more JSON file cause it's up to 100 macros per export. Second file is on this url https://XYZ.zendesk.com/api/v2/macros.json?per_page=99&page=2  (replace XYZ to your ZD name)

     

    My understanding is that point 2 is for less than 100 macros?

    We have over 200, so I used point 2a, but I did not understand the logic behind "the 2nd file?" What is a 2nd file?

    I used both points, and both times it extracted over 200 macros, so I am not sure what the "more than 100 macros" has to do with anything?

    Thanks to clarify.

    1
  • Vladan Jovic
    Aktionen für Kommentare Permalink

    Hey Matthew, the key is that number of macros per an API call/request is limited to max 99 macros. 

    So, if you have eg 250 macros, you will have to do the call 3x.
    How to do that? Just replacing the last part of the URL "page=2". So you should call it with: page=1, page=2, page=3. Let me know if anything still isn't clear. Best.

    0
  • Pradeep P
    Aktionen für Kommentare Permalink

    These links are not working. I changed the Domain name

    XYZ.zendesk.com/api/v2/macros.json?per_page=99 

    https://XYZ.zendesk.com/api/v2/macros.json?per_page=99&page=2 

     

    0
  • Vladan Jovic
    Aktionen für Kommentare Permalink

    Hey Pradeep, I just checked and they seem to work. Please note you should remove XYZ from the links and put there your ZD subdomain. Sure, you need to be logged in as admin in your ZD. 

    0
  • Juan Espinosa
    Aktionen für Kommentare Permalink

    Hi There, 

    What is the best way to export by usage in the last 30 days; 

    I tried

    https://(MyCompany).zendesk.com/api/v2/macros.json?per_page=99&sort_by=usage=30d


    but was unable to do so

    0
  • Matteo
    Aktionen für Kommentare Permalink

    Hello Juan,

    You can try using sideload instead (if your plan is Enterprise)

    /api/v2/macros.json?include=usage_30d&sort_order=asc

    Or the standard usage for macros:

    /api/v2/macros.json?sort_by=usage_30d&sort_order=asc

    You can change asc to desc.

    Hope this helps!

     

    0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.

Powered by Zendesk