Solved

Bulk Updating and adding a Tag in Macros

Forum|Forum|3 years ago
January 25, 2023
4 replies
109 views

Gabriel15

Hello Zendesk Devs!

I am looking to update all 17K of the macros we have in our instance and am looking for a good way to do this.

I've seen documentation on updating the description but what I'm looking for is:

a way to add the actions of "add a tag" and whatever tag I need associated with the particular Macro

Can anyone help me out with this?

Best answer by Christopher15

Hey @gabriel15. You'll likely need to leverage the Ticketing API to do this. I suggest a three step approach:

Use the API to export all your macros to a csv file, remembering to include the 'id' field.
Update the csv file with a new column that will contain the tag you want to add for each macro.
Use the API to update your macros (using the csv file), setting the 'add_tags' action for each macro to be the tag value in the csv file.

There's a list of API clients here that you could look at to get started, or you can write your own code.

Christopher15
Answer
Forum|Forum|3 years ago
January 26, 2023

Hey @gabriel15. You'll likely need to leverage the Ticketing API to do this. I suggest a three step approach:

Use the API to export all your macros to a csv file, remembering to include the 'id' field.
Update the csv file with a new column that will contain the tag you want to add for each macro.
Use the API to update your macros (using the csv file), setting the 'add_tags' action for each macro to be the tag value in the csv file.

There's a list of API clients here that you could look at to get started, or you can write your own code.

Like

Axel14
Forum|Forum|1 year ago
March 13, 2025

I used the following in Postman to upload tags along with my macros and was not able to successfully add the values from my document when running my collection.

{
  "macro": {
    "title": "{{macro_title}}",
    "active": true,
    "default": false,
    "actions": [
      {
        "field": "comment_mode_is_public",
        "value": {{comment_mode_is_public}}
      },
      {
        "field": "comment_value_html",
        "value": "{{comment_value_html}}"
      },
      {
        "field": "add_tags",
        "value": "{{tag}}"
      },
      {
        "field": "status",
        "value": "{{status}}"
      }
    ],

What should the proper “field" be in order to add the tags while bulk importing macros?

I was able to successfully bulk import using the following

{
    "macro": {
        "title": "{{macro_title}}",
        "active": true,
        "default": false,
        "description": "{{description}}",
        "actions": [
            {
                "field": "comment_mode_is_public",
                "value": {{comment_mode_is_public}}
            },
            {
                "field": "comment_value_html",
                "value": "{{processed_comment_value_html}}"
            },
            {
                "field": "status",
                "value": "{{status}}"
            }
        ]
    }
}

But could never make it work when trying to include tags in the import.