Data Importer: Use Org ID as identifier instead of external_id when updating orgs



投稿日時:2024年3月28日

Feature Request Summary: 

When using Data Importer to bulk update organizations, I want to use the Zendesk Org ID as the record identifier instead of the external_id. Organizations do not always have external_id's, but they always have an organization id. It doesn't make sense to me that I cannot use the organization's primary key (organization id) when updating records via Data Importer.

Description/Use Cases: 

  • The issues I'm running into with Data Importer for my use case are:
    • Some organizations I want to update via Data Importer do not have an external_id.
    • I need to update the external_id to a different value, but that doesn't appear to be an option.
  1. Using Data Importer, how do I update organizations that do not already have an external_id?
  2. Using Data Importer, how do I change the external_id of an organization to a different value?
  3. Can I use the Zendesk Org ID instead of the external_id to identify which organizations are updated via data Importer?

I submitted the issues and questions listed above to Zendesk support, and this was their response:

  1. If organizations are without an external_id, you can set one using the Zendesk API before utilizing the Data Importer tool.
  2. Changing an organization's external_id is not directly supported by the Data Importer tool. You'll need to utilize the Zendesk API for updating the external_id.
  3. The Data Importer tool necessitates the use of external_id for organization identification. The use of Zendesk Org ID for this purpose is not supported.

Business impact of limitation or missing feature:

I have over 40,000 organization records that require updating. This task requires me to update the system and custom organization fields, the external_id, and add an external_id value where one isn't already populated.

 

Because of the Data Importer limitations, I'm now creating a custom application that will read a csv of organization records and send an API call to this endpoint for each organization id listed in the csv.

https://developer.zendesk.com/api-reference/ticketing/organizations/organizations/#update-organization

 

This endpoint uses the organization id to identify which record should be updated. It seems bizarre to me that Data Importer would rely on an optional organization field (external_id) to update organizations instead of the record's primary key (organization id).


9

5

0件のコメント

サインインしてコメントを残してください。

お探しのものが見つかりませんか?

新規投稿