Encountering an Unknown Error while Parsing JSON in Google Apps Script

Question

Encountering an Unknown Error while Parsing JSON in Google Apps Script

Having trouble parsing JSON data retrieved from an API call. The error message "TypeError: Cannot read property "id" from undefined. (line 42, file "")" keeps popping up. I'm fairly new to Apps Script. Any thoughts on what might be causing this issue? I am able to fetch the payload in JSON format, but struggling to parse it.

function fetchInfo() {
    var url = "https://subdomain.chargify.com/subscriptions.json";
    var username = "xxx"
    var password = "x"

    var headers = {
        "Authorization": "Basic " + Utilities.base64Encode(username + ':' + password)
    };

    var options = {
        "method": "GET",
        "contentType": "application/json",
        "headers": headers
    };

    var response = UrlFetchApp.fetch(url, options);
    var data = JSON.parse(response.getContentText());
    Logger.log(data);

    var id = data.subscription; // triggers an error
    // var id = data;    works and returns the entire JSON data

    var ss = SpreadsheetApp.getActiveSheet()
    var targetCell = ss.setActiveSelection("A1");
    targetCell.setValue(id);
}

javascript json parsing google-apps-script

Answer 1

Answer №1

The guide located at

states that the /subscriptions.json endpoint will provide an array of subscriptions. Therefore, it is recommended to handle your data object like this:

for (let i=0; i<data.length; i++) {
let item = data[i]; //subscription object, accessing item.subscription will likely work
Logger.log(JSON.stringify(item));
}

Answer 2

The guide located at

states that the /subscriptions.json endpoint will provide an array of subscriptions. Therefore, it is recommended to handle your data object like this:

for (let i=0; i<data.length; i++) {
let item = data[i]; //subscription object, accessing item.subscription will likely work
Logger.log(JSON.stringify(item));
}

Answer 3

Answer №2

function fetchSubscriptionID() {
    var endpoint = "https://example.com/subscriptions.json";

    var user = "abc"
    var pass = "123"

    var headers = {
        "Authorization": "Basic " + Utilities.base64Encode(user + ':' + pass)
    };

    var request = {
        "method": "GET",
        "contentType": "application/json",
        "headers": headers
    };

    var responseData = UrlFetchApp.fetch(endpoint, request);
    var subscriptionData = JSON.parse(responseData.getContentText());

    for (var j = 0; j < subscriptionData.length; j++) {
        var subItem = subscriptionData[j]; //subscription object, where subItem.subscription probably works
        Logger.log(JSON.stringify(subItem));
        var subID = subItem.subscription.id;
    }

    var sheet = SpreadsheetApp.getActiveSheet()
    var cell = sheet.setActiveSelection("A2");
    cell.setValue(subID);
}

Answer 4

function fetchSubscriptionID() {
    var endpoint = "https://example.com/subscriptions.json";

    var user = "abc"
    var pass = "123"

    var headers = {
        "Authorization": "Basic " + Utilities.base64Encode(user + ':' + pass)
    };

    var request = {
        "method": "GET",
        "contentType": "application/json",
        "headers": headers
    };

    var responseData = UrlFetchApp.fetch(endpoint, request);
    var subscriptionData = JSON.parse(responseData.getContentText());

    for (var j = 0; j < subscriptionData.length; j++) {
        var subItem = subscriptionData[j]; //subscription object, where subItem.subscription probably works
        Logger.log(JSON.stringify(subItem));
        var subID = subItem.subscription.id;
    }

    var sheet = SpreadsheetApp.getActiveSheet()
    var cell = sheet.setActiveSelection("A2");
    cell.setValue(subID);
}

Encountering an Unknown Error while Parsing JSON in Google Apps Script

Answer №1

Answer №2

Similar questions

Fiasco in Parsing JSON Using Objective-C

Python: Exploring JSON Data

Evaluation of Library (VueJS) - Displaying various components in an individual test case

Maintaining Flexbox layout without triggering item re-rendering for a new container

ridiculing callback within parameter

Personalize Your Highcharts Legend with Custom HTML

How can I properly consume the variables 'b0' and 'b1' from the JSON response in my Java POJO class?

Utilize React Redux to send state as properties to a component

There was a problem establishing a WebSocket connection to 'ws://127.0.0.1:2000/'. The attempt failed with the following error: net::ERR_CONNECTION_REFUSED

A step-by-step guide on uploading a CSV file in Angular 13 and troubleshooting the error with the application name "my

Utilize the Google reverse geocoding API to convert latitude and longitude values from JSON into a dynamic variable

Automatically toggle Bootstrap checkbox switch to OFF upon successful completion of AJAX script

Creating a node.js function that can be used with OracleDB

The process of extracting values from an HTML tag using Angular interpolation

What is the best way to retrieve JSON data in ReactJS through ExpressJS?

The map displayed on google.com appears different from the one featured on our website

What is the best way to conceal the button?

Ways to verify AJAX Response String when data format is specified as JSON

What is the reason for jQuery returning an integer instead of an object?

Can Jquery mobile detect drag gestures?