Fetch user data from postgres database?

Questions and Answers
1

Hi everyone,

Im currently developing a booking API for our platform. In this case i need to fetch some data about the user by his/hers ID from the strapi database (im doing this with other collections as well).

My questiong now it, where are the user information stored? I have looked in all tables, and no data other than the administrator info exists. Im not going through strapi at all, but directly fetching the info form the database using NPSQL nuget package for ASP.NET Core 3.1.

I am looking for the users email address as i need it to create an invoice.

Kindly Steffen Nielsen

2

image

All the user’s info is stored in users-permissions_user table and it contains the following default fields:
image

3

Thank you so much. Can’t believe i missed it. Thanks

1 Like