Creating your first REST Query

You probably know how to create a Query at this point, so quickly head over to the Queries tab and hit the “Create” button.

After you select “REST Countries” as the Datasource for your Query, you’ll see that there’s a difference to SQL Queries now. Instead of an editor for an SQL Statement, you will now see the base URL of your REST Datasource, and a field for a path that will be appended to it. Just like with SQL, you can use parameters here.

Click “Create Query” to save it, and let’s try it out! Go to a Confluence page and insert the PocketQuery macro again. In the macro editor, specify a value for the regional parameter. Example: Europe

There we go! Our first REST Query presents us a table of data…

But what’s this? Looks like there’s some data in our result that is displayed weirdly. Also, there are a lot of columns that we actually don’t need. So, let’s learn how we can format the result of a Query to fit our needs.

Continue with “Filtering the result of your Query with a Converter“