Dynamic target urls using Sitemap.xml Links selector?

I'm trying to define the to be scraped pages using sitemap.xml which contains a subset of the product pages available on a website. There are few hundred products and the list is dynamic so I think using start urls is not possible/feasible.

I do not have access to the target website so I must store the modified sitemap.xml on my own site. The problem is that I get "No Data Extracted" when I point the sitemap.xml location to my own website. If I point it to the original websites sitemap.xml, I get the data but of course containing all the thousands of products/urls.

I have tried also with the exactly same sitemap.xml just copied to my own site so I know it is not the sitemap.xml file itself causing the issue. I have also tried this with my own website with a sitemap.xml containing links to my own website and it works fine.

It seems like the Sitemap.xml Links selector prevents loading a custom sitemap.xml from another website than the scraped one. This seems unnecessary and could perhaps be changed?

Any help is well appreciated.

Well, few minutes after hitting Send, I realised that I can accomplish exactly the same but by just using a normal webpage hosted on my website containing the links to the target product pages on the other site. No need to use the Sitemap.xml Links selector.

Since I will generate the file containing all the product urls, the format (xml vs html) does not matter at all.

Now I have a sitemap with a single start url pointing to my generated webpage containing the few hundred products urls to be scraped. A Link selector with the actual scraper selectors as it's children works perfectly.

Hope this helps someone else with similar need.