Basics of JSON for Power Platform
Jul 3, 2023 6:00 AM

Basics of JSON for Power Platform

External YouTube Channel

This video covers the basic concept of JSON. JSON is known as JavaScript Object Notation. Most of the time we're confused between what is JSON Object

This text highlights the basics of JavaScript Object Notation (JSON). Often, there is confusion between what constitutes a JSON Object and a JSON Array, but this video aims to remedy that. JSON is a lightweight data-interchange format which is easily readable and writable for humans, and smoothly parsed and generated by machines. It serves to transport data from a server to a webpage or between servers.

JSON Basics

JSON (JavaScript Object Notation) is a lightweight data-interchange format that is easy to read and write for humans, and easy to parse and generate for machines. It is often used to send data from a server to a web page or between servers. 

Fundamental Concepts about JSON

  1. Data is in name/value pairs: The data in JSON is structured as name/value pairs. The name/value pairs are separated by a colon, and each pair looks like this: "name":"value".

  2. Data is separated by commas: When there are multiple name/value pairs, they are separated by commas.

  3. Curly braces hold objects: Curly braces {} are used to encapsulate the name/value pairs into an object. An object can be considered as a collection of unordered name/value pairs. An example object in JSON would look like this: {"name":"John", "age":30, "city":"New York"}.

  4. Square brackets hold arrays: If you want to store an ordered list of values in JSON, you would use an array, which is encapsulated in square brackets []. For instance: {"employees":["John", "Anna", "Peter"]}. Here, "employees" is an array containing three elements.

  5. Value types: A value in JSON can be a string (in double quotes), a number, a boolean (true or false), null, an object (in curly braces), or an array (in square brackets).

  6. Syntax: JSON syntax is derived from JavaScript object notation syntax:
    • Data is in name/value pairs
    • Data is separated by commas
    • Curly braces hold objects
    • Square brackets hold arrays

Here's a more complex JSON example:

  "employees": [
    {"firstName": "John", "lastName": "Doe"},
    {"firstName": "Anna", "lastName": "Smith"},
    {"firstName": "Peter", "lastName": "Jones"}

In the example above, employees is an array of three objects. Each object is a record of a person (with a first name and a last name).

  1. JSON Files: The file type for JSON files is ".json". JSON is a text format, and we need a text editor to be able to view and edit JSON files. JSON files are used for storing structures of simple data sets by using a textual format, easily readable by humans.

  2. Parsing JSON: When receiving data from a web server, the data is always a string. So, we must parse the data with JSON.parse(), and the data becomes a JavaScript object.

  3. Stringify a JSON Object: When sending data to a web server, the data has to be a string. Convert a JavaScript object into a string with JSON.stringify().

JSON is widely used due to its simplicity, readability, and easy integration with almost all major languages. It is a key part of the web applications and APIs.

Why is JSON for Power Platform? 
The Microsoft Power Platform is a suite of business applications that includes Power BI, Power Apps, Power Automate (formerly known as Flow), and Power Virtual Agents. Each of these tools provides a way to analyze data, build solutions, automate processes, and create virtual agents. 

JSON (JavaScript Object Notation) plays a crucial role in Microsoft Power Platform for several reasons:

  1. Data Interchange Format: JSON is a widely used data interchange format. It allows easy exchange of data between servers and clients, and between different components of the Microsoft Power Platform itself. This makes it very versatile and vital for data storage and transmission.

  2. Power Automate (Flow): JSON is especially important in Power Automate, Microsoft's workflow automation tool. Power Automate often uses JSON to manage and manipulate data in flows. For example, when a flow retrieves data from a system like SharePoint or Dynamics 365, that data is typically represented as JSON. Flows can also use JSON to construct complex data structures to pass between actions.

  3. Integration with Other Services: Many web services that you might connect to using Power Platform return data in JSON format. Understanding JSON is crucial to interpret this data correctly and use it in your Power Apps or Power Automate flows.

  4. Power Apps: In Power Apps, JSON is used to import and export data. You might use it to move data between screens in an app, or to save and load user data between sessions.

  5. Power BI: In Power BI, JSON can be used to define a data model's schema or to import data. For instance, Power BI's color themes are defined using JSON. 

  6. Power Virtual Agents: JSON can be used in Power Virtual Agents to manage complex objects and pass information between different parts of a chatbot conversation.

  7. Universal Format: JSON is language-independent, which means it can be used with any programming language, not just JavaScript. This makes it universally acceptable and very important for systems that interact with various different technologies, such as the Microsoft Power Platform.

Given these factors, knowledge of JSON can greatly enhance your ability to work effectively with the Microsoft Power Platform.


Further Information About JSON

JSON is considered essential in web development and is widely used for APIs and configurations, owing to its compactness and readability. It's key in storing simple data structures and arrays in textual format. If you work with JavaScript, JSON will likely appear often in your work, perhaps in the manipulation of object literals, arrays, and other data types.

Learn about Basics of JSON


JSON (JavaScript Object Notation) is a lightweight data-interchange format that is easy to read and write for humans, and easy to parse and generate for machines. It is often used to send data from a server to a web page or between servers. JSON consists of data in name/value pairs, separated by commas, and encapsulated by curly braces. Objects in JSON can be considered a collection of unordered name/value pairs. JSON objects can also contain arrays, which are collections of ordered values. Additionally, JSON can include other types of data such as numbers, strings, booleans, and null values.

In order to create valid JSON data, you must follow certain syntax rules. These rules include proper formatting of the data, and use of quotation marks for string values. Additionally, objects and arrays must be properly nested and closed. JSON is a language-independent format, meaning that it can be used in any programming language as long as the language has a parser for it.

When working with JSON, it is important to understand the data structure, and how the data is stored. This will allow you to create, parse, and modify JSON data. It is also important to be aware of the data types that are supported in JSON, as this will help you to create valid JSON objects.

JSON is a useful format for working with data, as it is easy to read and write. It is a popular choice for APIs and other web services, as it is lightweight and can easily be transmitted over the internet. Knowing the basics of JSON will help you to create and work with JSON data in a variety of applications.


More links on about Basics of JSON

JSON Introduction
JSON stands for JavaScript Object Notation · JSON is a lightweight data-interchange format · JSON is plain text written in JavaScript object notation · JSON is ...
Working with JSON - Learn web development | MDN
May 10, 2023 — JavaScript Object Notation (JSON) is a standard text-based format for representing structured data based on JavaScript object syntax. It is ...
JSON Tutorial
JSON or JavaScript Object Notation is a lightweight text-based open standard designed for human-readable data interchange. The JSON format was originally ...
JSON Basics: What You Need to Know
Mar 24, 2011 — JSON is a simple, text-based way to store and transmit structured data. By using a simple syntax, you can easily store anything from a single ...
JSON Tutorial: Introduction and A Complete Guide for ...
Jun 22, 2023 — JSON object is a set of Keys along with its values without any specific order. The key and their values are grouped using curly braces, both ...
JSON Basics For Beginners-With Example Exercises
May 4, 2022 — JSON Format Overview · key/value pairs · Data is separated using commas · Text data is enclosed in double quotes · Numerical data has no quotes.
Learn JSON Tutorial
JSON stands for JavaScript Object Notation. · JSON is lightweight data-interchange format. · JSON is easy to read and write than XML. · JSON is language ...
JSON Tutorial: Learn with Simple File Format EXAMPLE
Apr 29, 2023 — JSON is a file format used to store information in an organized and easy-to-access manner. Its full form is JavaScript Object Notation.
JSON for Beginners – JavaScript Object Notation ...
Nov 29, 2021 — JSON (JavaScript Object Notation) is a text-based data exchange format. It is a collection of key-value pairs where the key must be a string ...


JSON, JavaScript Object Notation, Data Interchange Format, Data Structures, JavaScript, Curly Braces