I have problem. I got an xml file with product data, but I don't want to import all but only those from a certain category to my store. Unfortunately, the products are not arranged under their categories, but outside of them. The category information is only contained in their columns under "categoryId".

I had the idea of ​​writing python code to convert XML to JSON. Then extract the data from the appropriate "categoryId", save it in the variables, and create a new JSON file. Unfortunately, I have no idea how to get all the data from a specific "categoryId" at once.

I am begging you for at least a subtle hint. Unfortunately, I can't do great much, I'm just learning.

A few photos of what the answer looks like from the file.

As you can see in the category table, there are no products, they are outside.

I want to pull out every item that has this category.

Thank you in advance for any willingness to help :)