I am receiving data from a third party company through XML. I want to add this to my website as drupal nodes, having some information like title, body, summary, image,...
I am able to make a cron job that reads all the data from the XML & write it to a database.
Now I was wondering:
Can I write this to the database directly without creating any inconsistenties?
What tables do I have to write this to? only the node table and the field_data tables? Or do I also have to add it to field_revision tables etc? Am I forgetting any others?
Is there a module that's doing this? I tried the Feeds & the Migrate modules, but I can't seem to find anything to set up XML or SQL Data import on those. Either of the 2 is fine, whether it goes directly from the XML, or if I have to import it from SQL, cause then I can just add them to a temp table first.
Thank you very much