Django Rest Framework returning duplicate data when returning a nested json response

I have a pricing table that contains the following fields: id, date, price_non_foil, price_foil, card_id. This table holds pricing data for each card for each day. For Example:

Currently there is pricing data for 5 dates for each card. I am trying to create an endpoint to return the latest 2 prices for each card using Django rest framework. I have managed to get the response to be nest under the card id, but my issue is that it returns multiple card ids, I assume based on the number of pricing data records for each card.

views.py

class individual_set_pricing(ListAPIView):
    serializer_class = SerializerSetsIndividualPricing

    def get_queryset(self):
        code = self.kwargs.get('code', None)
        qs = magic_sets_cards_pricing.objects.filter(card_id__set_id__code=code.upper()).values('card_id')
        return qs

serializers.py

class SerializerSetsIndividualPricing(serializers.ModelSerializer):
    card = serializers.SerializerMethodField('get_card')

    class Meta:
        model = magic_sets_cards_pricing
        fields = ['card_id', 'card']

    def get_card(self, obj):
        date = magic_sets_cards_pricing.objects.filter(card_id=obj['card_id']).values('date', 'price_non_foil', 'price_foil').order_by('-date')[:2]
        return date

Response

[
    {
        "card_id": "3a261180-c1b3-4641-9524-956be55bee7a",
        "card": [
            {
                "date": "2021-12-09",
                "price_non_foil": 1.15,
                "price_foil": 1.54
            },
            {
                "date": "2021-12-08",
                "price_non_foil": 0.43,
                "price_foil": 1.62
            }
        ]
    },
    {
        "card_id": "3a261180-c1b3-4641-9524-956be55bee7a",
        "card": [
            {
                "date": "2021-12-09",
                "price_non_foil": 1.15,
                "price_foil": 1.54
            },
            {
                "date": "2021-12-08",
                "price_non_foil": 0.43,
                "price_foil": 1.62
            }
        ]
    },
    ...

how to I remove the duplicate records in the json response?

Back to Top