Determine the number of distinct property values within a JSON API response

Question

Determine the number of distinct property values within a JSON API response

Running on a Ruby on Rails backend, I have a JSON API that serves an array of objects with the following structure:

{
  "title_slug": "16-gaijin-games-bittrip-beat-linux-tar-gz",
  "platform": "Linux",
  "format": ".tar.gz",
  "title": "BIT.TRIP BEAT",
  "bundle": "Humble Bundle for Android 3",
  "unique_games": 9
},
{
  "title_slug": "17-gaijin-games-bittrip-beat-linux-deb",
  "platform": "Linux",
  "format": ".deb",
  "title": "BIT.TRIP BEAT",
  "bundle": "Humble Bundle for Android 3",
  "unique_games": 9
},

The challenge lies in counting only unique titles, as there are different types of downloads for each title within the object array. My initial idea of implementing this in the Ruby on Rails model failed because it required processing the entire array.

Considering I use AngularJS on the frontend and have to update the number of unique titles displayed on a table, I believe filtering should be done in the controller.

To provide more context, here's a screenshot of the page where these functionalities will be integrated: https://i.sstatic.net/DFx3L.png

Thank you,

Thomas Le

P.S. This project is not meant for public access; it's a database site housing information from bundles purchased from IndieGala and HumbleBundle. The functional enhancements are geared towards making the open-source project on GitHub more accessible for personal use.

If you're wondering about the presence of Humble Bundle data in the image shared, now you know why!

javascript ruby-on-rails ruby json angularjs

Answer 1

Answer №1

http://jsfiddle.net/hy7rasp4/

To efficiently organize your data into an array based on a unique identifier, you can easily track duplicates and their count.

let index,
    category,
    uniqueInfo= {};

for (index in info) {
   category = info[index].category;
   if (!uniqueInfo[category]) {
      uniqueInfo[category] = [];
   }

   uniqueInfo[category].push(info[index]);
}

Answer 2

http://jsfiddle.net/hy7rasp4/

To efficiently organize your data into an array based on a unique identifier, you can easily track duplicates and their count.

let index,
    category,
    uniqueInfo= {};

for (index in info) {
   category = info[index].category;
   if (!uniqueInfo[category]) {
      uniqueInfo[category] = [];
   }

   uniqueInfo[category].push(info[index]);
}

Answer 3

Answer №2

Perhaps consider restructuring your data simultaneously to facilitate easy access to items later and quickly determine the number of titles, for example in JavaScript

// assuming arrayOfObjects

var objectOfTitles = {},
    i;
for (i = 0; i < arrayOfObjects.length; ++i) {
    if (!objectOfTitles.hasOwnProperty(arrayOfObjects[i].title)) {
        objectOfTitles[arrayOfObjects[i].title] = [];
    }
    objectOfTitles[arrayOfObjects[i].title].push(arrayOfObjects[i]);
}

var numberOfTitles = Object.keys(objectOfTitles).length;
// then say you choose a title you want, and you can do
// objectOfTitles[chosenTitle] to get entries with just that title

Answer 4

Perhaps consider restructuring your data simultaneously to facilitate easy access to items later and quickly determine the number of titles, for example in JavaScript

// assuming arrayOfObjects

var objectOfTitles = {},
    i;
for (i = 0; i < arrayOfObjects.length; ++i) {
    if (!objectOfTitles.hasOwnProperty(arrayOfObjects[i].title)) {
        objectOfTitles[arrayOfObjects[i].title] = [];
    }
    objectOfTitles[arrayOfObjects[i].title].push(arrayOfObjects[i]);
}

var numberOfTitles = Object.keys(objectOfTitles).length;
// then say you choose a title you want, and you can do
// objectOfTitles[chosenTitle] to get entries with just that title

Determine the number of distinct property values within a JSON API response

Answer №1

Answer №2

Similar questions

I am looking to showcase images beside individuals' names or photos on my website in a vertical arrangement, similar to how it is done on Facebook

Managing Nested Elements in State in ReactJS

Alter the button's color seamlessly while staying on the same page

Are DOM Events compatible with ajax-loaded content that cannot be unloaded?

Error: Unable to call dispatch method on this.$store object

A guide on utilizing Retrofit and GSON to effectively parse data from the WordPress REST API

Clicking React useState causes it to update before the intended click is registered

Encountered an issue while attempting to write to SQLite, error code 6 is

Tips on restricting users to choose dates that are later than the current date

Can all anchor tags properties on a website be simultaneously changed?

What is the process of invoking the POST method in express js?

What is the method to invoke a function within a factory in angularjs by using a string parameter?

"Learn how to clear an input field using jQuery with this simple guide

Add a hovering effect to images by applying the absolute positioning property

Create shorter nicknames for lengthy reference names within the ng-repeat loop

Tips for refreshing the Vuex store to accommodate a new message within a messageSet

Arrange a JavaScript map based on its values and ensure that a specific field index remains at the top position

"HTML glitches in Onsen 2: A Dynamic Dilemma

What is the best way to ensure jQuery loads before CSS code on a website

Variety of part ingredients