How to export Zendesk macros into a spreadsheet

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.

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. :)

Super helpful, thanks a mil! :) 

Worked perfectly first time. 

Thank you!

Thank you so much Graeme! Worked like a charm. 

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:

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?

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

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?