Our account managers create items in SF(sObjects, if that matters), which soon afterwards need to be used in our web app(Ruby on Rails with PostgreSQL).
The data sync should happen as soon as possible, ideally, while switching to a different browser tab the data should already be in the app database. But while the reaction time needs to be low, these cases are not frequent, randomly a few times a day. So I wonder what an appropriate export mechanism would be?
These are the options I was able to figure out with google:
- There's Streaming API, but this requires maintaining a permanent connection, which stays unused most of the time.
- Polling the REST API, this is slow and counts towards the API call limits, and again useless most of the time.
- Outbound Messaging, which sounds good but is not available in our subscription plan.
- Apex Triggers, not sure if they allow to make HTTP requests and if this wouldn't be a misuse of the feature. Also, requires knowledge/maintenance of Apex code.
Any other? Is my understanding correct?