Question 109682 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Why am I not able to loop through my JSON file?

I am not able to loop through the contents of a JSON file because the JSON file starts with a ‘.’ dot.

How do I clean the JSON file so that it removes the ‘.’ dot in the begining of the file?

Find below my code:

  // Fetch API
  fetch(apiUrl, {
    method: "POST",
    headers: headers,
    body: JSON.stringify(requestBody),
  })
  .then(response => response.json())
  .then(data => {
    // Get the generated response from the API
    const generatedResponse = data.choices[0].text;


    // Console log out response
    console.log("smartResponse:: ", generatedResponse);

    for (let section in generatedResponse) {
      // Get the prompt for the current section
      let prompt = generatedResponse[section].prompt;
      
      // Do something with the prompt, like print it to the console
      console.log(`Prompt for ${section}: ${prompt}`);
    }

The code above yields:

smartResponse::  .

{
    "whatIsABox": {
        "prompt": "What is a box?",
        "section": "What is a box?"
    },
    "typesOfBoxes": {
        "prompt": "What are the different types of boxes?",
        "section": "Types of Boxes"
    },
    "usesForBoxes": {
        "prompt": "What are some uses for boxes?",
        "section": "Uses for Boxes"
    }
}

Prompt for 0: undefined
Prompt for 1: undefined
Prompt for 2: undefined
Prompt for 3: undefined
Prompt for 4: undefined

The desired result should be:

smartResponse::

{
    "whatIsABox": {
        "prompt": "What is a box?",
        "section": "What is a box?"
    },
    "typesOfBoxes": {
        "prompt": "What are the different types of boxes?",
        "section": "Types of Boxes"
    },
    "usesForBoxes": {
        "prompt": "What are some uses for boxes?",
        "section": "Uses for Boxes"
    }
}

Prompt for What is a box?: A box is a container with six faces.  The faces are made of six panels.  The panels are attached to each other with hinges or latches.  A box has a lid and a bottom.
Tags:

3

Answers


  1. 0

    generatedResponse is a string, not an object. You need to remove the . at the beginning, then parse it.

    fetch(apiUrl, {
    method: "POST",
    headers: headers,
    body: JSON.stringify(requestBody),
  })
  .then(response => response.json())
  .then(data => {
      // Get the generated response from the API
      const generatedResponse = data.choices[0].text;
      generatedResponse = JSON.parse(generatedResponse.replace(/^./, ''));

      // Console log out response
      console.log("smartResponse:: ", generatedResponse);

      for (let section in generatedResponse) {
        // Get the prompt for the current section
        let prompt = generatedResponse[section].prompt;

        // Do something with the prompt, like print it to the console
        console.log(`Prompt for ${section}: ${prompt}`);
      }
    Login or Signup to reply.
  2. 0

    Have you tried using for loop like this.

    for (var key in generatedResponse) {
// skip loop if the property is from prototype
if (!generatedResponse.hasOwnProperty(key)) continue;

console.log( generatedResponse[key].prompt );
}
    Login or Signup to reply.
  3. 0

    As per the response you mentioned in the OP, Looks like data.choices[0].text is returning a string. So to achieve this you can remove/replace that leading dot by using String.charAt(0).

    Demo :

    let generatedResponse = `.{
    "whatIsABox": {
        "prompt": "What is a box?",
        "section": "What is a box?"
    },
    "typesOfBoxes": {
        "prompt": "What are the different types of boxes?",
        "section": "Types of Boxes"
    },
    "usesForBoxes": {
        "prompt": "What are some uses for boxes?",
        "section": "Uses for Boxes"
    }
}`;

const jsonStr = generatedResponse.replace(generatedResponse.charAt(0), '');

const jsonObj = JSON.parse(jsonStr);

for (let section in jsonObj) {
  // Get the prompt for the current section
  let prompt = jsonObj[section].prompt;
  
  // Do something with the prompt, like print it to the console
  console.log(`Prompt for ${section}: ${prompt}`);
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search