Combining JSON data the easy way

Question

Combining JSON data the easy way

I am faced with the challenge of merging three JSON strings: JSON-A, JSON-B, and JSON-C. My goal is to combine JSON-A and JSON-B to form JSON-C, but also to split JSON-C back into JSON-A and JSON-B.

Below are the details of the JSONs:

JSON-A: - This contains questions along with all possible answers

{
"content": {
    "section": [
        {
            "questions": [
                {
                    "qText": "Have you or your family received medication or treatment for any serious conditions in the last 2 years?",
                    "qKey": 152,
                    "qType": [
                        {
                            "aType": "You",
                            "ans": [
                                {
                                    "aKey": "102",
                                    "aText": "Yes"
                                },
                                {
                                    "aKey": "106",
                                    "aText": "No"
                                }
                            ]
                        },
                        {
                            "aType": "Your family",
                            "ans": [
                                {
                                    "aKey": "108",
                                    "aText": "Yes"
                                },
                                {
                                    "aKey": "109",
                                    "aText": "No"
                                }
                            ]
                        }
                    ]
                }
            ]
        }
    ]
}

JSON-B: - Selected answers

{
"qkey": "152",
"ans": [
    {
        "aType": "You",
        "aKey": "102"
    },
    {
        "aType": "Your family",
        "aKey": "106"
    }
]
}

JSON-C: - Output with selectedAnswer

{
"content": {
    "section": [
        {
            "questions": [
                {
                    "qText": "Have you or your family received medication or treatment for any serious conditions in the last 2 years?",
                    "qKey": 152,
                    "qType": [
                        {
                            "aType": "You",
                            "selectedAnswer": "102",
                            "ans": [
                                {
                                    "aKey": "102",
                                    "aText": "Yes"
                                },
                                {
                                    "aKey": "106",
                                    "aText": "No"
                                }
                            ]
                        },
                        {
                            "aType": "Your family",
                            "selectedAnswer": "109",
                            "ans": [
                                {
                                    "aKey": "108",
                                    "aText": "Yes"
                                },
                                {
                                    "aKey": "109",
                                    "aText": "No"
                                }
                            ]
                        }
                    ]
                }
            ]
        }
    ]
}

To achieve this result from JSON-A and JSON-B, I implemented multiple nested loops which may appear complex. Is there a more efficient way to perform this task without using jQuery? Any suggestions or alternative methods would be greatly appreciated. Thank you!

javascript json

Answer 1

Answer №1

Delving into the depths of four loops, check out this link: http://jsfiddle.net/xh7eLoL0/

qkey = jsonB.qkey;

jsonA.content.section.some(
    function CheckEachSection(section) {
        var found;

        found = section.questions.some(
            function FindMatchingQuestion(quest) {
                if (quest.qKey == qkey) {
                    jsonB.ans.forEach(
                        function ApplyEachAnswer(ans) {
                            quest.qType.some(
                                function FindEachMatch(sub) {
                                    if (sub.aType === ans.aType) {
                                        sub.selectedAnswer = ans.aKey;

                                        return true;
                                    }
                                });
                        });

                    return true;
                }
            });

        return found;
    });

Answer 2

Delving into the depths of four loops, check out this link: http://jsfiddle.net/xh7eLoL0/

qkey = jsonB.qkey;

jsonA.content.section.some(
    function CheckEachSection(section) {
        var found;

        found = section.questions.some(
            function FindMatchingQuestion(quest) {
                if (quest.qKey == qkey) {
                    jsonB.ans.forEach(
                        function ApplyEachAnswer(ans) {
                            quest.qType.some(
                                function FindEachMatch(sub) {
                                    if (sub.aType === ans.aType) {
                                        sub.selectedAnswer = ans.aKey;

                                        return true;
                                    }
                                });
                        });

                    return true;
                }
            });

        return found;
    });

Answer 3

Answer №2

Two suggestions. One idea is to consider restructuring the JSONB format either before receiving it or after to simplify lookups and eliminate unnecessary looping:

{
    "152": {
       "You": "102",
       "Your family": "106"
    }   
}

By transforming JSON-B into this structure post-receipt, you would only need to loop through it once instead of for every question.

Another recommendation is to explore using the forEach method on Array for improved readability.

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/forEach

By incorporating both approaches and ensuring an answer exists for each question, you could potentially implement something like:

JSONA.content.section.forEach(function (section) {
    section.questions.forEach(function (question) {
        question.qType.forEach(function (qtype) {
            qtype.selectedAnswer = JSONB[question.qKey][qtype.aType]
        });
    });
});

Answer 4

Two suggestions. One idea is to consider restructuring the JSONB format either before receiving it or after to simplify lookups and eliminate unnecessary looping:

{
    "152": {
       "You": "102",
       "Your family": "106"
    }   
}

By transforming JSON-B into this structure post-receipt, you would only need to loop through it once instead of for every question.

Another recommendation is to explore using the forEach method on Array for improved readability.

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/forEach

By incorporating both approaches and ensuring an answer exists for each question, you could potentially implement something like:

JSONA.content.section.forEach(function (section) {
    section.questions.forEach(function (question) {
        question.qType.forEach(function (qtype) {
            qtype.selectedAnswer = JSONB[question.qKey][qtype.aType]
        });
    });
});

Answer 5

Answer №3

Is this solution beneficial?

let sectionA = JSONA.content.section;
for(let sA in sectionA){
  let questionsA = sectionA[sA].questions;
  for(let qA in questionsA){
    let questionA = questionsA[qA], questionTypeA = questionA.qType;
    for(let b in JSONB){
      let jb = JSONB[b], jb_ans = jb.ans;
      if(jb.qKey === questionA.qKey){
        for(let bA in jb_ans){
          let jbA = jb_ans[bA];
          for(let aT in questionTypeA){
            let questionB = questionTypeA[aT];
            if(questionB.type === jbA.type){
              questionB.selectedAnswer = jbA.aKey;
            }
          }
        }
      }
    }
  }
}

Answer 6

Is this solution beneficial?

let sectionA = JSONA.content.section;
for(let sA in sectionA){
  let questionsA = sectionA[sA].questions;
  for(let qA in questionsA){
    let questionA = questionsA[qA], questionTypeA = questionA.qType;
    for(let b in JSONB){
      let jb = JSONB[b], jb_ans = jb.ans;
      if(jb.qKey === questionA.qKey){
        for(let bA in jb_ans){
          let jbA = jb_ans[bA];
          for(let aT in questionTypeA){
            let questionB = questionTypeA[aT];
            if(questionB.type === jbA.type){
              questionB.selectedAnswer = jbA.aKey;
            }
          }
        }
      }
    }
  }
}

Combining JSON data the easy way

Answer №1

Answer №2

Answer №3

Similar questions

Extract various .json fields and save them in a .txt file on a single line

Having trouble positioning a div in AngularJS so that it stays pixel-perfect regardless of browser resize or device orientation? Unfortunately, it's

I need help showing the JSON data from the API in my Go application

Is there a way to programmatically activate a tooltip above an input field using JavaScript?

What is the best way to trigger a new api call after the previous one has successfully completed?

Adding an event listener to the built-in arrow buttons on the `<input type=number>` element is a simple way to enhance user interaction

Tips for inserting a variable into an attribute value when creating it using TypeScript

Creating a dynamic Xcode build process that automatically sets the version based on a JSON configuration file

Choose a chart from the dropdown menu and showcase it

Obtain a particular string line from a file using bash

The useCallback hooks persist outdated values when the list is refreshed

Python Client for Smart-on-FHIR Integration with Bundle Support

Can Pug Templating handle iterating through multiple arrays within a JSON data object?

Guide for extracting the button click text using selenium and node js, illustrated in the image

Enable the ability to temporarily stop and then continue the ongoing upload process to Azure block storage

Vue 2 - Error: The function is not defined at HTMLInputElement.invoker (vue.esm.js?65d7:1810)TypeError: cloned[i].apply

Is there a way to modify the response code that has already been dispatched?

Converting a SQL query result into a JSON object can be accomplished by following these steps: extract the value for the "timestamp"

Customize the DOM with tailwind CSS in a Vanilla JavaScript project

The necessity of ExpressJS