Understand JSON in scenarios

JSON (JavaScript Object Notation) is a popular syntax for storing and exchanging data, and can be used in Workfront Fusion.

In this video, you will learn:

  • What JSON is and how it’s structured
  • How to read JSON and how it will be translated into data to be used within your scenarios
  • How to use the JSON modules when creating, changing, and working with JSON
JSON is a syntax for storing and exchanging data. JSON is text written with JavaScript object notation, hence the abbreviated name. Although it has JavaScript in the name JSON is now independent of JavaScript and is considered a standardized format commonly used to transfer data. Imagine a world where we were all on the metric system and shared that same language. JSON is similar in that it’s a common and frequently used data format across databases and APIs. There are certain APIs and apps that will return JSON as an output. You might also want to convert certain data into a new structure. So it’s important to understand how you can change, manipulate or use JSON within your scenarios. The JSON app provides modules to process data in JSON format so that fusion can further work with the data content, or create new JSON content. When viewing a sample of JSON, you can tell where an array starts and finishes by the square or box brackets surrounding the lines of keys and values. A collection is designated by the curly brackets. In the mapping panel, when looking at mapped items from a previous module you can tell which items are arrays by the square brackets in the name. Collections will have an expansion carrot, but no brackets in the name. Keys and values will simply be listed as individual items. -