We are using the integration fields a lot in our Prismic setup. We use the variant where Prismic pulls the data from our API.
We are currently in the process of migrating part of our service from a MongoDB backed app to a PostgreSQL backed app. Included in this migration is the endpoint that handles one of our integration fields. We unfortunately used the MongoDB
id in the return value from the integration field endpoint at our side. I'm assuming that you use the id for deciding what's a new "item" and what already exists. If not, how do you do it?
The new endpoint has the exact same data, but with different
ids. I'm guessing what will happen is that we would get duplicate items, one with the old MongoDB id and one with the new id. Or will the items on the Prismic side that has ids that's no longer available on our side be removed? If that's the case, what will happen with all the associations we have from our pages to the integration field items?
I really want to
- Not have to import the old MongoDB ids to our new DB
- Not have to go through everywhere we use the items from the integration fields and update them.
Does anyone have any idea how to solve this? Or am I missing something?