In this post I am going to explain how to create an “Hello world!” app in RAW. This app is a simple API endpoint which responds to an HTTP GET with the “Hello world!” JSON string: https://api.raw-labs.com/demos/1/public/hello-world/hello-world Before creating the actual “Hello world!” application in RAW there are some prerequisites…

In this previous post I explained how to discover the last updated pages from a website using RAW Labs. In this one, I am showing how to use Power Query in Excel to retrieve this data from virgingalactic.com as an example. First, you need to create a new empty spreadsheet…

In my previous post I described one way to sync Excel data with Salesforce fields, here I will explain how to import and display analytics from an external source into a SaaS application (Salesforce). This process is sometimes called “Reverse ETL” when the data comes from a datawarehouse or a…

There are many possible options to synchronize data with Salesforce. Here, I am going to describe how to do a one-way sync (Excel to SFDC) every hour with RAW Labs Just-Ask and some APEX code. I will first show how to make the Excel data available through a simple REST…

Move data easily from relational to noSQL database Introduction This post illustrates how we can use RQL to move data from a relational database to a noSQL document database. I will use source data taken from a PostgreSQL table loaded with data from the TCP benchmark H and bulk load it…

Using RAW to query sitemap files Introduction Here I will explain how to use RAW Query Language (RQL) to query sitemap files and crawl them in order to fetch the URLs from the pages updated most recently on any website. For these examples below, we will use RAW Labs platform, which…