Report generated by rest API
I am the business owner here, but before I send my developer out on a mission, I wanted to check and see if what I want is possible..
We have a lot of requests for a report of unanswered threads. I know this is obtainable in the rest API, but wanted to know if we could output something similiar to the search export where it's title, URL, board and date of thread that has no responses in a way that is exportable to excel rather than XML output. In this most ideal scenerio this could be ran daily and emailed to interested parties. Has anyone built something similiar or know if it's possible?
Hi Allison,
The closest I could find is the "Discussions with no replies" search results sorted by date:
This can then be combined with the manual export as CSV or you ask the interested party to subscribe to that search via RSS. Most browser have builtin RSS support:
If you want to go for the daily report option you could create a custom component that would run a search on the message resource by querying only for top level messages without replies, just like in the documentation example:
SELECT * FROM messages WHERE replies.count(*)=0 AND depth=0
You can specify the output format yourself then. If you want to use this report to pull internal staff onto the community it might make sense to have that component actually send a community PM with the report to everyone with a certain role. That way they'd consume the report already on community :manwink:
