Using JavaScript to search JSON objects based on key value pairs

Question

Using JavaScript to search JSON objects based on key value pairs

Consider a scenario where you have an array of objects in users.json:

{"key":"userSubscriptions","value":
[{"channel":"Netflix","user":"Bobby","region":"NA"},
[{"channel":"Netflix","user":"Bobby","region":"EU"},
[{"channel":"Netflix","user":"Jamie","region":"SEA"},
[{"channel":"Prime Video","user":"Bobby","region":"NA"}]}

If we want to filter this data such that the final result will be

console.log(result); // Bobby, your region subscriptions are: Netflix: (NA, EU), Prime Video: (NA)

Your help on achieving this outcome would be greatly appreciated!

UPDATE: I attempted using methods like .filter() and .map(), but unfortunately haven't had success yet.

javascript arrays json filter

Answer 1

Answer №1

To effectively organize and display data, utilize lodash for grouping and mapping.

var details = {
                "key":"userSubscriptions",
                "value":
                [{"channel":"Netflix","user":"Bobby","region":"NA"},
                {"channel":"Netflix","user":"Bobby","region":"EU"},
                {"channel":"Netflix","user":"Jamie","region":"SEA"},
                {"channel":"Prime Video","user":"Bobby","region":"NA"}]
            }

            var usersData = _.chain(details.value)
                .groupBy("user").map((data, role) => ({ user: role, info: data })).value();

                usersData.forEach(item => {
                    console.log(item)

                    console.log(`${item.user}, your current region subscriptions include: Netflix: ${item.info.map(i=>i.channel).join(',')}, Prime Video: ${item.info.map(i=>i.region).join(',')}`)
                });

Answer 2

To effectively organize and display data, utilize lodash for grouping and mapping.

var details = {
                "key":"userSubscriptions",
                "value":
                [{"channel":"Netflix","user":"Bobby","region":"NA"},
                {"channel":"Netflix","user":"Bobby","region":"EU"},
                {"channel":"Netflix","user":"Jamie","region":"SEA"},
                {"channel":"Prime Video","user":"Bobby","region":"NA"}]
            }

            var usersData = _.chain(details.value)
                .groupBy("user").map((data, role) => ({ user: role, info: data })).value();

                usersData.forEach(item => {
                    console.log(item)

                    console.log(`${item.user}, your current region subscriptions include: Netflix: ${item.info.map(i=>i.channel).join(',')}, Prime Video: ${item.info.map(i=>i.region).join(',')}`)
                });

Answer 3

Answer №2

There seems to be an issue with your JSON data. However, I have made adjustments to align it with your intended structure.

This new structure organizes the data by user and includes a function that can display the Subscriptions and Regions for any specified user.

const jsonString = `{"key":"userSubscriptions","value":[{"channel":"Netflix","user":"Bobby","region":"NA"},{"channel":"Netflix","user":"Bobby","region":"EU"},{"channel":"Netflix","user":"Jamie","region":"SEA"},{"channel":"Prime Video","user":"Bobby","region":"NA"}]}`;

const obj = JSON.parse(jsonString);                                  // Parsing the string into an object

const byUser = obj.value.reduce((acc, o) => {                        // Reducing the array values into one object
  if (!acc[o.user]) acc[o.user] = {};                                // Creating user property in accumulator if not already present
  if (acc[o.user][o.channel]) acc[o.user][o.channel].push(o.region); // Adding region to existing channel array
  else acc[o.user][o.channel] = [o.region];                          // Creating new channel array with region
  return acc;                                                        // Returning modified object for next iteration
}, {});

function printForUser(userName) {                                    // Function to print subscriptions and regions for a given user
  const user = byUser[userName];                                     // Getting the user object from byUser
  return Object.keys(user).reduce((acc, k) => {                      // Reducing keys of user object to form a string
    return acc + ` ${k}: (${user[k].join(", ")}),`;                  // Combining subscription and regions information
  }, `${userName}, your region subscriptions are:`).slice(0, -1);    // Initializing string and removing last comma
}

console.log( printForUser("Bobby") );

Answer 4

There seems to be an issue with your JSON data. However, I have made adjustments to align it with your intended structure.

This new structure organizes the data by user and includes a function that can display the Subscriptions and Regions for any specified user.

const jsonString = `{"key":"userSubscriptions","value":[{"channel":"Netflix","user":"Bobby","region":"NA"},{"channel":"Netflix","user":"Bobby","region":"EU"},{"channel":"Netflix","user":"Jamie","region":"SEA"},{"channel":"Prime Video","user":"Bobby","region":"NA"}]}`;

const obj = JSON.parse(jsonString);                                  // Parsing the string into an object

const byUser = obj.value.reduce((acc, o) => {                        // Reducing the array values into one object
  if (!acc[o.user]) acc[o.user] = {};                                // Creating user property in accumulator if not already present
  if (acc[o.user][o.channel]) acc[o.user][o.channel].push(o.region); // Adding region to existing channel array
  else acc[o.user][o.channel] = [o.region];                          // Creating new channel array with region
  return acc;                                                        // Returning modified object for next iteration
}, {});

function printForUser(userName) {                                    // Function to print subscriptions and regions for a given user
  const user = byUser[userName];                                     // Getting the user object from byUser
  return Object.keys(user).reduce((acc, k) => {                      // Reducing keys of user object to form a string
    return acc + ` ${k}: (${user[k].join(", ")}),`;                  // Combining subscription and regions information
  }, `${userName}, your region subscriptions are:`).slice(0, -1);    // Initializing string and removing last comma
}

console.log( printForUser("Bobby") );

Using JavaScript to search JSON objects based on key value pairs

Answer №1

Answer №2

Similar questions

Can VueJS 1 and 2 be integrated within the same package.json configuration?

Unable to access Vue.js cookies: they are not defined

What is the minimum number of lines that can be used for javascript code?

Working with attributes in AngularJS directives

Updating a component (`AddBudgetModal`) while rendering a different component (`App`) is not possible. To identify the incorrect setState() call within the `AddBudgetModal` component

Troubleshooting the issue of data retrieval failure in asp.net mvc controller using jquery.post()

Emphasize a specific line of text within a <div> with a highlighting effect

Providing UI field attributes within server JSON data

The plugin 'vue' specified in the 'package.json' file could not be loaded successfully

Issues arise with the functionality of Datatables when attempting to implement a

Another option instead of using $index for displaying serial numbers in ng-repeat

Exploring the dynamics of parent and child components in Angular

Struggling to transfer information between POST and GET requests in Node/Express

Execute two tasks simultaneously in two separate workers utilizing the cluster module in node.js

Keep the multiselect dropdown list of the select component open

I want to search through an array of tuples to find a specific value in the first index, and if there is a match, I need to return the value in the second index of the matching tuple

Update object properties in Angular controller dynamically

Mastering the art of transferring render :json => data to d3.js

Divide an HTML file into separate documents upon submitting a form

Tips for resolving conflicts with jQuery on an ASP.NET webpage