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 Flow

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 Flow to read this file
Bring in ALL Rows
Observe the result - which is in JSON