XML decode stream

I have a marketplace where vendors provide xml rss feeds that update products every day. These feeds are very big, millions of rows, around 40k products, about 60mb size. I can't receive these feeds in smaller sizes and have the need to add the products in a table. I tried making an xml decode solution (worked when upgrading to scale) to get the json, but adding to a table doesn't work. According to support I need to upgrade to x2 or x4 to get this to work but that would be too expensive. This is the only thing I use Xano for right now. They suggested that I request this as a feature. I can't find any way to do this and really need these products to update daily or else the customers run into serious problems. If you have any solution to this that would be highly appreciated.
3