Rather than trying to pull the time from an outside source, I thing you would be better off calculating it yourself. Have a look at this thread. Rather than calculating GMT time, you can set the correct timezone to calculate to Columbian time. Then you will have a value in your table that can be used for conditions in the app.