This workbook is designed to accompany section 302 - API and JSON - The Fundamentals.


Pre-Requisites

For this workbook, you should have your own environment with login credentials.

If you are using a Production environment, please take care with any existing processes.

You may also elect to use 30-day free Trial Org by visiting: https://azuqua.com/sign-up

Because this is an Integration product, we will encourage you to use freely-available applications within this material. Tools such as Twitter, Slack, and others are great products and typically allow you to sign-up for free!


Exercise 302-1 - Creating a JSON Object

A good example is a Food object. Each Food Object should be related to a fruit or vegetable.

Download and review this CSV File

As you can see it is a pretty simple file containing various fruit and vegetables and information about each … including the serving size (grams and ounces), calories, and some nutritional data.

Let’s use the following dataset to convert to a JSON object remembering these simple rules:

  • Curly braces start and end a JSON Object
  • The key/value pairs are separated by colons
  • Multiple key/value pairs WITHIN AN OBJECT are separated by commas

Click Here for the Solution.

Exercise 302-2 - Using a JSON Object in a FLO

Now, let’s “do something” with the object that we have available …

An “Object: Get” card may be enough. Should not be overwhelming.

Before we close this section, let’s do something more interesting …

  • Take the CSV File
  • Load into GSheets
  • Create a new FLO to read this file
  • Bring in ALL Rows
  • Observe the result - which is in JSON