Hello,
I have a requirement to create new posts automatically based on data I have stored in a MSSQL database. I am interested in suggestions on the best way to do this.
Ideally I would push data directly out my database to Simple:Press. I have a linked server setup from MSSQL to the SimplePress database and can generally figure out your data structure, however, I assume it’s not safe to perform inserts into the SP database directly. I could not find any docs on sph_post_create or sph_pre_post_create which I assume might help me with the inserts.
Any suggestions for a path forward would be greatly appreciated.
Thanks,
Mike