External resources search and serve on custom route?

[aseupa]

Hi! I'm scratching my head over this since a while ago and wanted to know if it's even possible or if there is a standar way of doing it.

Currently my shop has over +5000 (literaly) pages with a specific information (car models and its history/info) with a searching script that takes a search term and redirects to the correct shopify page url. This gives the ability to search for cars models to my users. I also have all that information in an external DB wich I can fetch trough an API (car model,brand, images, year, etc) this DB is used by another service too. Right now I have to update the cars models in both shopify pages and the external DB each time some information changes or new car model is added.

My end goal here is to have a search on my theme that looks for a car name and (in case it exist) redirects to a specific url (e.g /cars/ford-focus) and that the information inside that page is fetched from the external API. I'am asking too much for shopify templating? Would using an hydrogen storefront be the only way?

I think that the part in wich API data is fetched and served on a search result page can be done with a private app and using theme extension app to present it on the theme. But not sure how to handle the custom unique route for each result.

Thanks for reading!