I am new to Joomla and facing a situation - I need to have a page with custom URL (/dashboard) which would return some data in JSON that external application will read. I have a Slideshow CK module, where I need the slides (image url, link) and main menu items (title, url). All returned in one JSON response. Which is the best approach? Create a custom page with it's own template and create a module, which would get data from database (raw sql) and then prepare the desired JSON? Or is there a way how to create a JSON view from Slideshow CK module and menu module?
Thank you all for your tips