This is a great question, so thanks for posting @dkamboj!
Remember that pulling data out of Exosite Portals is client initiated, so you will need an application that talks to Exosite over our APIs, and then writes new information into your database. Exosite doesn’t have a preference as to which API you use, but you may prefer web sockets or long-polling in order to have the quickest data resolution.
Documentation on the possible API endpoints to pull data:
Pulling is the most common approach, as data will be made available on client demand.
Closer to true push, you could send data directly to your server via HTTP, provided your application would be configured to accept communication from our platform. Using Portals scripts or dispatches you can send a message to your server including the newest data written to the platform.
They subscribe to a single resource in the system, and can be configured to send a message to a phone/inbox/endpoint based on new writes to another resource. This is the fastest and most light-weight way to actively send information out of Exosite.
Object documentation can be found here: http://docs.exosite.com/rpc/#create-dispatch
Code written in Lua that can execute based on new writes to a resource. You can detect, read, and parse data, then later send it to your server. The documentation on our scripting service can be read here: http://docs.exosite.com/scripting, and an basic example using HTTP can be read below:
A small app note with additional details on polling or pushing data can be read here: https://support.exosite.com/hc/en-us/articles/200463830-Pushing-Data-to-Your-Device.
Let me know if you have additional questions – I am happy to help,