I recently found out about the struct plugin and am amazed with the possibilities it offers as demonstrated in the very helpful DocSprint demo page. I look at DokuWiki in an entirely different way now and believe it can replace many Excel Sheets and even small databases I was working with up until now and help me concentrate information in one place.
A true concentration would require, however, to include information from outside sources. I wanted to get some ideas here on how to best approach something like this.
To keep thinks (relatively) simple, say I have data that can be queried using a REST API. I wish to return this data in DokuWiki but I don't need the possibility to edit from within DokuWiki, I'm fine going back to the system of origin for that.
Specifically, I wish to include a list of tickets from a ticket system within DokuWiki. So, a simple tabular representation of this data with some text fields and one URL field would be perfectly sufficient.
What approach would you recommend for a requirement like this? Could you describe, just in very general terms, the steps needed to develop a solution for this?
I think one possible way to take that wouldn't be overly complex is to not even take the route of remote automating DokuWiki but instead just write a program that queries the API and writes the data directly into the SQLite db for struct (global schema since it will not be attached to pages). But you may tell me that this is not a good idea, I'll appreciate any advice you can spare!