I use Twilio for the text messaging, and so they can handle up to 1600 characters per outgoing message request, and larger responses could also be broken into multiple response messages. Users can define LiquidJS templates on the system so that you can cut down the size of the response message if you only want to see certain fields.