I 'd like to programmatically generate new pages for a site - the textual and visual components of the content are stored in a DB, this includes the names for the different locations the pages are for, links to the location specific images and custom description text.
My first attempt would be to code a template for the page the way I want it to look like with the different sections, elements etc and then retrieve the relevant content for each page from the DB (by using the corresponding reference names for the elements as defined in the template)and send it to wordpress (with a post request to the rest api presumably)
(This is a data analyst's attempt to automate a web development process.)
1) Is the above process feasible and meaningful ? (in theory)
2)Are there any plugins or instructions that would facilitate this (in practice) especially without reinventing the wheel ?
Clarification: The use case is the equivalent of having a list of hotels and locations and corresponding images and content in a DB (I haven't created that yet and it could be anything from an online spreadsheet to some storage service on the cloud - anything that can let me programmatically access the data.) The goal is that then if I want to add say a 100 new locations and create the corresponding pages I can do it instantly