added support for paginated results
added support to use reuse connection