Combining various JSON objects by nesting them together

Question

Combining various JSON objects by nesting them together

I'm in the process of creating an endpoint where I need to combine data from four different tables into one nested object. Each table record is retrieved in JSON format using sequelize - they include information on location, service, staff, and tenant. How can I merge these records into a single nested object? For example: The data obtained from sequelize for staff:

{
    "id": 2,
    "profession": "Dentist",
    "note": "Good Man",
    "holidays": "Saturday",
    "specialDays": null,
    "createdAt": "2023-01-27T14:23:52.000Z",
    "updatedAt": "2023-01-27T14:23:52.000Z"
}

All other data follows a similar format but I aim to merge them to create a combined output like this:

 {  
    staff:{
        "id": 2,
        "profession": "Dentist",
        "note": "Good Man",
        "holidays": "Saturday",
        "specialDays": null,
        "createdAt": "2023-01-27T14:23:52.000Z",
        "updatedAt": "2023-01-27T14:23:52.000Z",
    },
    location:{
        "id": 1,
        "name": "Branch 1",
        "address": "37 Automatic Handling",
        "description": "This is our main branch",
        "latitude": "564233",
        "longitude": "4441256",
        "visible": true,
        "createdAt": "2023-01-27T14:05:37.000Z",
        "updatedAt": "2023-01-27T14:05:37.000Z",
    } 
}

javascript json express sequelize.js

Answer 1

Answer №1

If you want to create an object, simply follow these steps:

// (within an async function)

const location = await // code using Sequelize to retrieve information
const service = await // code using Sequelize to retrieve information
const staff = await // code using Sequelize to retrieve information
const tenant = await // code using Sequelize to retrieve information

return res.json({
  location,
  service,
  staff,
  Tenant: tenant, // delete "Tenant:" if it was a mistake or not important
});

Answer 2

If you want to create an object, simply follow these steps:

// (within an async function)

const location = await // code using Sequelize to retrieve information
const service = await // code using Sequelize to retrieve information
const staff = await // code using Sequelize to retrieve information
const tenant = await // code using Sequelize to retrieve information

return res.json({
  location,
  service,
  staff,
  Tenant: tenant, // delete "Tenant:" if it was a mistake or not important
});

Answer 3

Answer №2

Yes, this code snippet seems like it should function properly!

const staff = {
    "id": 2,
    "profession": "Dentist",
    "note": "Good Man",
    "holidays": "Saturday",
    "specialDays": null,
    "createdAt": "2023-01-27T14:23:52.000Z",
    "updatedAt": "2023-01-27T14:23:52.000Z",
};

const location1 = {
    "id": 1,
    "name": "Branch 1",
    "address": "37 Automatic Handling",
    "description": "This is our main branch",
    "latitude": "564233",
    "longtitude": "4441256",
    "visible": true,
    "createdAt": "2023-01-27T14:05:37.000Z",
    "updatedAt": "2023-01-27T14:05:37.000Z",
};

const mergedObject = { staff, location1 };
console.log(mergedObject);

Answer 4

Yes, this code snippet seems like it should function properly!

const staff = {
    "id": 2,
    "profession": "Dentist",
    "note": "Good Man",
    "holidays": "Saturday",
    "specialDays": null,
    "createdAt": "2023-01-27T14:23:52.000Z",
    "updatedAt": "2023-01-27T14:23:52.000Z",
};

const location1 = {
    "id": 1,
    "name": "Branch 1",
    "address": "37 Automatic Handling",
    "description": "This is our main branch",
    "latitude": "564233",
    "longtitude": "4441256",
    "visible": true,
    "createdAt": "2023-01-27T14:05:37.000Z",
    "updatedAt": "2023-01-27T14:05:37.000Z",
};

const mergedObject = { staff, location1 };
console.log(mergedObject);

Combining various JSON objects by nesting them together

Answer №1

Answer №2

Similar questions

Purpose of triggering another function during an ajax request

Querying data with parameters in a client-side rendered application with Next.js

JavaScript method not properly sorting the last nested array

Image not showing up when using drawImage() from canvas rendering context 2D

The ASP.NET MVC controller falling behind due to a delay in conversion process

What separates the various methods of initiating a node+express application?

Track the cursor's movement

Understanding the process of reading an ordereddict from a json file

Tips for determining the height of the entire webpage using jQuery

Is there a way to send multiple actions to Node.js via a dropdown list using POST method?

What is the best way to download a file with a specific name using Angular and TypeScript?

Tips for performing a conditional recursive merge

"Learn the technique of adding a new data attribute before every element in a step-by-step

Using HTML5 Canvas with Firefox 4: How to Retrieve Click Coordinates

How to extract data from Google Sheets using NODEJS?

The validation errors in the form of CodeIgniter are not being displayed by the JavaScript variable

Searching for ways to filter out specific tags using regular expressions

What is the best way to utilize jq to arrange the contents of this JSON file based on the seconds value?

Perform two jQuery AJAX post requests using the identical object

What is the process for refreshing HTML elements that have been generated using information from a CSV document?