How to filter password field

System Information
  • Strapi Version: 4.14.3
  • Operating System:windows
  • Database: sqlite
  • Node Version:
  • NPM Version:
  • Yarn Version:

I just want to try to filter query as well as following

https://localhost:1337/api/applications?filters[domain]=demo.com&filters[client][email][$eq]=demo@gmail.com&filters[client][password][$eq]=GT3D3D

I have a collection type list, its name is “application” and it has password type field.
it is working very well in any filters but when i try to add ‘password’ filter then it’s giving this error.
{
“data”: null,
“error”: {
“status”: 400,
“name”: “ValidationError”,
“message”: “Invalid parameter password”,
“details”: {}
}
}

Note: Yes, password field is encripted field, so maybe it’s out of filters but what i can i do for this case?
Is good idea that create normal text field but use for passwords.

Any idea?

Thanks in advance

Hi @muammer_keles , It’s queit something nearly, you can create your own api, and make logic to revert the requests for the filters and for password since is encrypted you can parse the things using a function for exemple mine:

const applications = await strapi.query('application').find({
  filters: {
    domain: 'demo.com',
    'client.email': 'demo@gmail.com',
  },
});

const filteredApplications = applications.filter((app) => {
  // Decrypt the password and perform your custom comparison logic
  return decryptAndCompare(app.client.password, 'GT3D3D');
});

Thanks @iietmoon
I will try that way.

Is there any Strapi nuget package for .net ?
this solution which you recommended is for JS .
I tried to use strapi API from a ASP.Net project.

any idea?
Thanks

You could use the web api from strapi in ASP.net

Hi @muammer_keles, Hope you doing well today, is not any patch for it but you can use it to integrate the api from strapi to your ASP.net logic but you can create web api’s in asp.net with retrieving data from strapi, so is more to write a logic software to handle that, is kind of like making a api geteway from front to asp api to strapi api, can read more about here: ASP.NET Web APIs | Rest APIs with .NET and C#

Hi guys,
Thanks for your replies…

I have already created service in my .Net project to fetch datas from strapi.
I thought maybe there is a special library to use it easy and the best way.

Anyway i found a repo on github origiinal one is this;

this is the forked one from me;

I like this but actualy it’s not solving my problem.
But it’s very good example for me.
I will fork it and keep developing and improving to use Strapi in .Net (net core) project for whoever will be needed.