Parsing JSON to string from an array and creating a nested object

Question

I have a nested array, looking like that:

{
  "id": 1,
    "QUALITY": 91.98,
    "TEMPERATURE": 20.5,
    "SENSOR_DATE": "2021-09-24T04:53:06.801Z",
    "SOURCE_ID": 1,
    "SENSOR_NAME": "TD2",
    "NEXT_OFFSET": 11931
},

I wanna change this string

  "QUALITY": 91.98,
  "TEMPERATURE": 20.5,

to this:

{
    "data": [
        {
            "TELEMATICS": {
                "QUALITY": 91.98,
                "TEMPERATURE": 20.5
            },
            "SOURCE_ID": "1",
            "SENSOR_NAME": "TD2",
            "SENSOR__DATETIME": "2021-09-24T04:53:06.801Z"
        },
    ],
    "NEXT_OFFSET": 11931
}

I have made many different attempts, but all I could get as a result of this code is:

var telematics = JSON.parse(JSON.stringify(payload, ['QUALITY', 'TEMPERATURE']));
var data = JSON.parse(JSON.stringify(payload, ['SOURCE_ID', 'SENSOR_NAME', 'SENSO$
payload = JSON.parse(JSON.stringify({TELEMATICS: telematics, data}, null, 2));
payload = JSON.stringify({data: payload}, null, 2);

As a result, I get two different objects. I can't combine them into one, with a nested TELEMATICS array:

{
                "QUALITY": 91.33,
                "TEMPERATURE": 25.7
            }
        ],
        "data": [
            {
                "SOURCE_COMPONENT_ID": 1,
                "SENSOR_NAME": "TD2",
                "SENSOR_READING_DATETIME": "2021-09-24T04:53:06.801Z"
            },

James · Accepted Answer · 2021-10-14 15:27:50Z

1

You said you have an array - the first item shown is an object, perhaps it's an element of that array? Let's assume so, that payload is an array of such objects.

You are trying to create a "data" array inside - with one element. Is that needed? Could it ever have more than one element? Let's assume it only has one element for now.

const payload = [{
  "id": 1,
  "QUALITY": 91.98,
  "TEMPERATURE": 20.5,
  "SENSOR_DATE": "2021-09-24T04:53:06.801Z",
  "SOURCE_ID": 1,
  "SENSOR_NAME": "TD2",
  "NEXT_OFFSET": 11931
}, {
  "id": 2,
  "QUALITY": 91.98,
  "TEMPERATURE": 20.5,
  "SENSOR_DATE": "2021-09-24T04:53:06.801Z",
  "SOURCE_ID": 1,
  "SENSOR_NAME": "TD2",
  "NEXT_OFFSET": 11931
}];

const result = payload.map(({QUALITY, TEMPERATURE, NEXT_OFFSET, ...rest})=> ({
  data: [{
    ...rest,
    TELEMATICS: {
      QUALITY,
      TEMPERATURE
    }
  }],
  NEXT_OFFSET
}));

console.log(result);

answered Oct 14, 2021 at 15:27

James

22.4k5 gold badges29 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user7290573 Over a year ago

I wonder how important the renaming of SENSOR_DATE to SENSOR__DATETIME is...

James Over a year ago

@user7290573 I'm not sure if that was intentional because we also have SENSOR_READING_DATETIME in the last example - I assume we just pass the property through "as is" above.

Nikita Alekseev Over a year ago

@James, Thank you for the answer! ) Very helpfully! But right now i have one more question with this data. NEXT_OFFSET must be not an inside the element, it's must be outside and at the end the array. Like a pagination the list elements.

James Over a year ago

Nikita it's outside of the data array, and immediately after it, just like the I wanna change to this in your question.

Collectives™ on Stack Overflow

Parsing JSON to string from an array and creating a nested object

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related