Attached are the presentation for the July 28th BTUG meeting at Knowledgent. I've also attached a workbook that contains the sample live web services connections that I presented at the meeting. These connections pass through a Postgres database integrated with R that I am hosting on Google Cloud. Please email me if you would like the password to connect to this database.
If you would like to change the connections to pull in different web service (JSON) data, open the custom SQL and edit the URL. You will need to be familiar with the JSON parsing functions from Postgres to convert the JSON data into a tabular format. The two examples in the workbook should get you started.