thisdaveJ

Using jq and curl to Wrangle JSON Arrays from the Terminal

In this tutorial, we use jq and curl to query a web service and retrieve JSON objects containing embedded arrays. We then invoke a command based on each element in the array rather than simply printing the values to the console. A special thanks to one of my readers, B. Anderson, who left a comment on my Consuming Web API JSON Data Using curl and jq post and provided this question for us to explore. Let’s get started!

Share
curl-jq

Consuming Web API JSON Data Using curl and jq

Hey everyone! I decided to put a few extra batteries in the background color of the article image above. 🙂 I’m actually pretty charged up about our topic today, particularly about jq, which is a lightweight and flexible command-line JSON processor with “batteries included”.

Share
thisdaveJ

Three Ways to Build Dynamic Web APIs using PHP

In this article, we learn how to build dynamic Web APIs using PHP. Why PHP? PHP is a very popular programming language used for rendering server-side web pages and is included as a standard option with many web hosting providers including HostGator (my provider). I had a need to generate simulated one-minute IoT data for a recent article I wrote on Fetching, Filtering, and Sorting JSON APIs in Google Sheets: The Missing Functions. Much to my surprise and delight, PHP is both powerful and fun, and I am here to share some of my learnings with you. Let’s get started and highlight three ways to build dynamic Web APIs using PHP.

Share

Do I Need an Umbrella Today? Google Sheets and JavaScript to the Rescue!

OK, Google Sheets! Send me an email if I need an umbrella today. Send an email using Google Sheets? Yes, that’s right! Sheets can do a lot more than add numbers and calculate your mortgage payments. In our last article, we learned how to consume JSON web data using Google Sheets and we built templates to display and sort weather forecast data. Today, we’ll build on what we covered last time and learn how to send email using Google Sheets based on the JSON data we retrieve. Let’s get practical and build something useful while we’re at it. Have you ever found yourself outside somewhere and it starts to rain Read More

Share

Consuming JSON Web Data Using Google Sheets

Note: This article has been superseded with Fetching, Filtering, and Sorting JSON APIs in Google Sheets: The Missing Functions which provides a set of Google Sheets functions with additional capabilities. I’ve said it before, and I’ll say it again.  JSON has become the lingua franca for exchanging data on the web, and we (as developers) need to know how to process JSON data received from RESTful web services so we can be positioned for the present and for the future. My article on Consuming Node.js Microservices Created with stdlib provided a high-level tour covering several methods of parsing and processing JSON data. Last time, we focused on how to consume Read More

Share