I want to generate username and password myself and give it to my users to log in to my app....so that only those people can log in to my app whose

You can use airtable api query

Pls check it here.

No need to call whole data. I have used filterbyformula in api query by using web component