[BUG] Extractor is not gettting all the products(OpenAPi) with the right APIS

[seilorjunior]

Release version

v4.10.1

Describe the bug

When we run the extractor is needs to get all APIS related to the products.

Expected behavior

As example when we changed a API with a new product(OpenAPi), it needs to remove the API from the latest product.

Actual behavior

When we are using with the current version, it is not removing from the older product and it is letting the API in two products.

Reproduction Steps

• Create two products(product1 and product2)(OpenAPi)
• Add an API to the product1.
  
• Run the extractor
• Run the publisher.
• Use the same API and remove the product1 from this and add the product2 to this API.
  
• Run the extractor(it needs to get all products again to validate which API belongs for each product)
• Run the publisher.
• We are going to get an error {"code":"ValidationError","message":"One or more fields contain incorrect values:","details":[{"code":"ValidationError","target":"aid","message":"API cannot be added to more than one open products."}]}}'.

[github-actions]

  Thank you for opening this issue! Please be patient while we will look into it and get back to you as this is an open source project. In the meantime make sure you take a look at the [closed issues](https://github.com/Azure/apiops/issues?q=is%3Aissue+is%3Aclosed) in case your question has already been answered. Don't forget to provide any additional information if needed (e.g. scrubbed logs, detailed feature requests,etc.).
  Whenever it's feasible, please don't hesitate to send a Pull Request (PR) our way. We'd greatly appreciate it, and we'll gladly assess and incorporate your changes.

[seilorjunior]

@guythetechie @waelkdouh there is any workaround for that?

[seilorjunior]

Hello this bug just happened when we are moving a product without any api.

Example: product1 and product2

1. The api belongs first to product1 in dev
2. We move the api with product1 to prod.
3. We change the api to product2 in dev, the product1 must not have any api.
4. We move he api with product2 to prod.
5. We are going to have the api with the product1 and product2 in prod.

@waelkdouh @guythetechie