Django Rest Framework : Filtering against Table Field value

Question

I'm improving my Django Web App with Django Rest API part and I have a question according to filtering against table field value.

I have my serializer class like this :

class IndividuResearchSerializer(serializers.ModelSerializer) :
    class Meta :
        model = Individu
        fields = [
            'id',
            'NumeroIdentification',
            'Nom',
            'Prenom',
            'VilleNaissance',
        ]

My views.py file with this class :

class IndividuResearchAPIView(ListAPIView) :
    permission_classes = (IsAuthenticated,)
    authentication_classes = (JSONWebTokenAuthentication,)
    serializer_class = IndividuResearchSerializer

    def get_queryset(self):
        queryset = Individu.objects.all()
        NIU = self.request.query_params.get('NumeroIdentification')
        queryset = queryset.filter(NumeroIdentification=NIU)

        return queryset

And my pythonic file which let to simulate connexion from another software based to API Rest :

import requests

mytoken = "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyX2lkIjoxLCJ1c2VybmFtZSI6IkFkbWluIiwiZXhwIjoxNTE5NzMxOTAxLCJlbWFpbCI6InZhbGVudGluQGRhdGFzeXN0ZW1zLmZyIiwib3JpZ19pYXQiOjE1MTk3MjgzMDF9.493NzJ4OUEzTKu5bZsZ9UafMwQZHz9pESMsYgfd0RLc"
url = 'http://localhost:8000/Api/Identification/search/'


NIU = "I-19312-00001-305563-2"

response = requests.get(url, NIU = NIU, headers={'Authorization': 'JWT {}'.format(mytoken)})

print(response.text)

I would like to enter a NIU value into my request in order to filter my table and return the object according to this NIU.

For example, in my database I have this object :

I would like to return this object thanks to my API but I don't know if my function get_queryset is well-writen and How I can write my API request.

Into my urls.py file, I have :

url(r'^search/$', IndividuResearchAPIView.as_view() , name="Research"),

So I am not making a filtering by URL.

I read these posts in order to get more element :

Django REST framework - filtering against query param

django rest framework filter

and obviously DRF doc : http://www.django-rest-framework.org/api-guide/filtering/#filtering-against-the-current-user

If I understood your question correctly, you need to use this url to filter: http://localhost:8000/Api/Identification/search/?NumeroIdentification=NUA_value. With requests library try to pass it with params argument: response = requests.get(url, params={'NumeroIdentification': NIU}, headers={'Authorization': 'JWT {}'.format(mytoken)}) — neverwalkaloner
– neverwalkaloner, Commented Feb 27, 2018 at 11:49
Yes exactly what I expected ! Please can you share your message as an answer in order to validate it ? — Essex
– Essex, Commented Feb 27, 2018 at 13:17

neverwalkaloner · Accepted Answer · 2018-02-27 14:31:06Z

1

You need to use this url to filter: http://localhost:8000/Api/Identification/search/?NumeroIdentification=NUA_value. With requests library try to pass it with params argument: response = requests.get(url, params={'NumeroIdentification': NIU}, headers={'Authorization': 'JWT {}'.format(mytoken)}).

answered Feb 27, 2018 at 14:31

neverwalkaloner

47.6k7 gold badges101 silver badges103 bronze badges

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

Collectives™ on Stack Overflow

Django Rest Framework : Filtering against Table Field value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related