How to use the Full Calendar Schedule?

Hi All,

Firstly, I need to premise this with the fact that this is the first time i’m needing to do anything with JSON files so my lingo is probably wrong.

I am trying to integrate a 3rd party JS library (FullCalendar Scheduler) and it needs vales as a JSON url.

I have a simple server connect query that returns the necessary result but i can’t figure out how to get this into a usable JSON file/url to use with FullCalendar Scheduler.

From reading this form, my understanding is that all the server connect actions output as a JSON in order to send the data back to the server, and looking at the output of my query does in fact look ALMOST like a usable JSON URL. This is what the output in the browser returns:

{“select”:[{“id”:1,“title”:“John Jones”},{“id”:2,“title”:“Peter Green”},{“id”:3,“title”:“Alan Jones”},{“id”:4,“title”:“Mike Tyson”},{“id”:6,“title”:“Alice Struve”}]}

When i use this URL in the JS file though, it doesn’t work. If i use the above values minus the {“select”:} it does work.

Am I missing something obvious here?

Is there an easy way to ‘convert’ this PHP url into a JSON url?

I have tried to play around with the API action in server connect but can’t get it to make sense.

Help please

Cheers,
Phil