For a client we wanted to implement an automation to trigger their billing system (Xifin) for patient billing. When a report was marked as final report we used apex to trigger the integration. This triggered a process that queried various data points, mapped the data into a JSON structure and send the data to Xifin. Xifin then requests to get the documents (ie insurance cards). After the initial post to Xifin we send a Salesforce ID to a node.js app on Heroku. This Heroku app accepts a JSON payload containing the ID so that we can query the files from Salesforce using ContentDocumentLink and send the documents to Xifin.

I wrote custom middleware in Heroku using node.js to grab order information from SFTP To Go and parse the XML full of orders and order lines. Upon parsing the data we would look for existing people in Salesforce, create or update Person Account records, create Orders, query Products/Pricebook Enteries, and create Order Lines.