Transforming JSON into a specialized text structure

Question

Transforming JSON into a specialized text structure

After receiving JSON data from the server, I am required to convert it into a different format as shown below:

{"1":"82700","2":"26480","3":"31530","4":"22820","5":"15550","6":"205790"}

Although I have attempted to achieve this with the provided code snippet, it is not yielding the desired results. The current code iteration appears below:

       var cities = "{";

        for (var key in data.visits) {
            var val = data.visits[key];
            
            var obj = {};
            obj[val.City] = '' + val.Count;

            var code = '' + val.City;
            var count = '' + val.Count;

            cities += code + ':' + count + ',';
        }

        cities += "}";

The objective is to ensure that the integers are represented as strings and eliminate the trailing comma at the end of the collection. How can I rectify this code in order to accomplish the desired outcome?

javascript json

Answer 1

Answer №1

Give this a try:

let data = {"visits":[{"City":6,"Count":5},{"City":16,"Count":1},{"City":23,"Count":1},{"City":34,"Count":1}]};
let result = {};

for (let i = 0; i < data.visits.length; i++) {
  result[data.visits[i].City] = String(data.visits[i].Count);
}

Check out the example here

Keys in an object always get converted to strings automatically, so you don't need to do it manually. If you need to convert the entire object to a JSON string, you can use JSON.stringify(result);

Answer 2

Give this a try:

let data = {"visits":[{"City":6,"Count":5},{"City":16,"Count":1},{"City":23,"Count":1},{"City":34,"Count":1}]};
let result = {};

for (let i = 0; i < data.visits.length; i++) {
  result[data.visits[i].City] = String(data.visits[i].Count);
}

Check out the example here

Keys in an object always get converted to strings automatically, so you don't need to do it manually. If you need to convert the entire object to a JSON string, you can use JSON.stringify(result);

Answer 3

Answer №2

To generate a new JSON from an existing JSON, you can use parsing techniques and iterate through the data to construct the desired output. If you need more guidance, check out this helpful resource:

Answer 4

To generate a new JSON from an existing JSON, you can use parsing techniques and iterate through the data to construct the desired output. If you need more guidance, check out this helpful resource:

Transforming JSON into a specialized text structure

Answer №1

Answer №2

Similar questions

What is the reason behind having to refresh my ReactJS page despite it being built with ReactJS?

Is it possible to show an image without altering the Box dimensions?

Search the database to retrieve a specific value from a multi-dimensional array

Tips for including a decimal point in an angular reactive form control when the initial value is 1 or higher

Tips for triggering the .click() function upon returning to index.html after visiting a different page

Display the user's username on the navigation bar once they have successfully

Add a fresh category to a JSON document

Maximizing memory efficiency in Javascript through array manipulation strategy

Invoke the mounted lifecycle once more

What could be causing the malfunction in this JavaScript and WebRTC code?

Having difficulty scrolling down in a section with 100% height on iOS devices

Tips for preventing Unknown event codes in POST request responses

Tips for adjusting the height of a fixed-size child element on the screen using only CSS and JavaScript restrictions

Receiving a JsonObject from a JsonArray loop is displaying a syntax error

Once the image is requested in HTML, three.js makes a subsequent request for the same image

Is there a way to retrieve the previous URL using JavaScript?

Use a JSON file to dynamically define the file path for static assets in the index.html file of a React application

What is the process of transforming a Json raw object or property into a particular model?

Transfer a value to the ng2 smart table plugin extension

Validate that a string is a correct file name and path in Angular without using regular expressions