Update - JSON Object and Lotusscript

Update to a post I had on 17.Jul.14

So after a couple months learning some xPages REST services, xAgents, etc… I was able streamline my current process to produce my JSON object without any LotusScript!

About time.

What i do now is on web open call an xPage … “https://domdevostx01.ten-net.net/SASE/SASENomination.nsf/GetJSON.xsp”… essentially an xAgent like Howard explained and in the afterRenderResponse event call a Java Class that actually produces the JSON object and sends it back to me.

Oddly enough I load my data into Datatables and not xPages. I am was not happy about the out of the box xPages view and Dojo grid and our organization will not fund the Dojo grid EXTJS so I stick with Datatables which is very nice. I now can load 20,000 documents in 5 seconds with all the nice filtering, paging etc that Datatables provides.