We’re using the external_id feature for Topic auto-creation in our integration . I note however that if we delete a Topic, we can not create a new one with the same external_id and instead receive the error: {'action': 'create_post', 'errors': ['External has already been taken']} Is it at all possi…

That’s because deleted topics are marked as deleted not removed from the database. Wanting to reassociate an ID with another topic seems like a bad idea (but you didn’t ask). You can force the topic to actually be deleted ( Introducing permanently delete post functionality might be how).

Hi @pfaffman Thanks very much for the suggestion and for the nudge in giving more thought to external_id reuse in general.

Unless those integers are really expensive? :thinking: (Glad that I seemed helpful rather than sarcastic!) Hope you find a good solution.

The challenge is that the value we’re using for the Topic’s external_id is difficult to change (manual operation) due to a limitation in the app we’re integrating with (CatalogIt - exposes a read only API). We often manually delete and auto-recreate Topics as we develop (this is all the integration …

Re-use of `external_id` after a Topic is deleted

Product Support

pfaffman (Jay Pfaffman) August 30, 2022, 12:26pm 4

Unless those integers are really expensive?

(Glad that I seemed helpful rather than sarcastic!) Hope you find a good solution.

Topic		Replies	Views
API topic's external_ID can't be reused after deleting a topic and creating a new one Feature rest-api	1	430	June 9, 2024
Problem with creating Topic with external_id Development rest-api	20	1608	October 13, 2022
What is the new `external_id` feature for topics used for? Development rest-api	6	1894	October 3, 2023
How to assign a `external_id` to a topic? Development rest-api	2	398	October 17, 2023
Unhandled PG::UniqueViolation for topic external_id field Bug pr-welcome	2	218	June 11, 2024

Re-use of `external_id` after a Topic is deleted

Related topics