Parses a JSON string into a JavaScript object.
class Utilities method .jsonParse()
Utilities is the Apps Script service.
.jsonParse() is the method name you will see after a dot in your code.
What it does
Why it's used
- Convert API JSON strings into objects you can read in script.
- Standard step after UrlFetchApp.getContentText.
Common errors
- Forgetting parentheses on jsonParse. Write Utilities.jsonParse(), not Utilities.jsonParse or jsonParse by itself.
- Skipping dots between chained calls. Each step needs a dot, like Utilities.jsonParse().
- Adding spaces where they do not belong. Write Utilities.jsonParse(), not Utilities .jsonParse(), Utilities.jsonParse (), or Utilities . jsonParse().
- Wrong capitalization. Use Utilities and jsonParse, not utilities or jsonparse.
Explore
Related methods
-
.jsonStringify()
Converts a JavaScript object into a JSON string.
-
.parseCsv()
Parses CSV text into a 2D array of values.
-
.base64Decode()
Decodes a Base64 string back into raw data.
-
.base64Encode()
Encodes a string or bytes as Base64.
-
.formatDate()
Formats a date using a pattern and time zone.
More Apps Script
Better Sheets tutorials
No tagged tutorials yet. Fetch Apps Script from the harvest table and this page fills automatically.
Related blog posts
Written guides about Utilities.jsonParse().
What's Better Than Google Sheets?
Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.
Read post →How to Send Google Forms Entries Automatically with Apps Script
Google Forms provides basic email notifications for form submissions, but enhancing these notifications with detailed summaries can significantly improve productivity and response management.
Read post →Explore Coding in Google Sheets
Did you know you can actually code in Google Sheets?
Read post →