[progress News] [progress Openedge Abl] Rollbase Low-code Integration With Third Party

[Thierry Ciot]

We saw how easy it is to create a complete responsive application using point and click/drag and drop methodologies in this blog https://www.progress.com/blogs/build-no-code-responsive-apps-with-rollbase, and we saw that we get a lot of built-in services in https://www.progress.com/blogs/how-low-code-app-platforms-bring-value-to-your-business. But you may ask, “what do you do when one service does not exist yet or you need to integrate with a third party?”

In this blog post, we will see how easy this can be achieved using the power of Rollbase Trigger. To make the blog more interesting let’s take the case, where, in our travels app, we want to send an SMS message to alert us when a user enters a star rating below 3 for a destination. And to make it even more useful, we will illustrate this by showing the code for sending SMS from Rollbase using Twilio.

First, obtain the following from your Twilio account:

1. Account SID
2. Auth Token

Second we go into the object definition of the destination object and create a new trigger of type "Object Script". We need to specify the following:

1. Under which condition we want to send the SMS .In our case, we will specify "on any update of the Rating field".
   
2. We code some JavaScript to (the key 3 lines are highlighted in blue below)
   1. Limit sending an SMS for rating less or equal to 2
   2. Call Twilio Rest API

if ( {!Rating} <= 2 ) {

rbv_api.println("rating is low - sending sms");

var url="https://<yourAccoundSID>:<yourAuthToken>@api.twilio.com/2010-04-01/Accounts/<yourAccountSID>/SMS/Messages";

var params= {"Body":"Low rating on {!city}", "To":"+<countryCode><phoneNumber1>","From":"+<countryCode><phoneNumber2>"};

var finalResponse = rbv_api.sendHttpPost(url, params, null);

rbv_api.println(finalResponse);

}

Note how the SMS text will contain the city name of the destination ("Low rating on {!city}"). The key point here is that we have access to all the data of the Destination object and its related objects.

In conclusion, integrating with additional services and a third party is a breeze. It’s programmed using JavaScript making the solution standard and portable; there is no vendor lockin.

Continue reading...