like-gold•2y ago

Receive data from database

How can I receive data from mongoDB with refine? user.routes.js: router.route('/invite').post(sendInvitation).get(getAllInvitations);; user.controller.js: const getAllInvitations = async (req, res) => { const { _end, _order, _start, _sort, email_like = "" } = req.query; const query = {}; if (email_like) { query.email = { $regex: email_like, $options: "i" }; } try { const count = await Invitation.countDocuments(query); const invitations = await Invitation .find(query) .populate("parentUserID") .limit(parseInt(_end, 10)) .skip(parseInt(_start, 10)) .sort({[_sort]: _order === "ASC" ? 1 : -1});
res.header("x-total-count", count); res.header("Access-Control-Expose-Headers", "x-total-count"); res.status(200).json(invitations); } catch (error) { res.status(500).json({ message: error.message }); } } invitation schema: import mongoose from 'mongoose'; const invitationSchema = new mongoose.Schema({ _id: mongoose.Schema.Types.ObjectId, // Auto-generated by MongoDB parentUserID: { type: mongoose.Schema.Types.ObjectId, ref: 'User' }, name: { type: String, required: true }, surname: { type: String, required: true }, email: { type: String, required: true }, token: { type: String, required: true }, }); export default mongoose.model('Invitation', invitationSchema); Whatever I'm trying on front-end it is not working, the request keeps loading

11 Replies

kapa.ai•2y ago

Hi @acidias. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave: ---------------------- Hmm, I don't know enough to give you a confident answer yet. However, you can refer to the refine documentation for more information on how to work with data providers and databases: Refine Documentation (https://refine.dev/docs). ---------------------- Note: you can ask me a follow up question by @ mentioning me again :speech_balloon: ----------------------

kapa.ai•2y ago

<@134090892167479296> kapa.ai is still learning and improving, please let us how it did by reacting below

like-goldOP•2y ago

@kapa.ai tableQueryResult: { data, isLoading, isError }, current, setCurrent, setPageSize, pageCount, sorter, setSorter, filters, setFilters, } = useTable({ resource: "users/invite" }); // change resource to invitations const allInvitations = data?.data ?? []; const currentFilterValues = useMemo(() => { const logicalFilters = filters.flatMap((item) => ('field' in item ? item : [])); return { email: logicalFilters.find((item) => item.field === 'email')?.value || '', } }, [filters]); console.log(data);

kapa.ai•2y ago

Let me check the knowledge base for you. One moment! :books: ---------------------- It seems like you're trying to use the useTable hook to fetch data from your MongoDB database. You need to make sure that the resource you're passing to the useTable hook matches the endpoint in your backend. Based on the provided code, you should change the resource to "invitations" instead of "users/invite":

const {
  tableQueryResult: { data, isLoading, isError },
  current,
  setCurrent,
  setPageSize,
  pageCount,
  sorter, setSorter,
  filters, setFilters,
} = useTable({ resource: "invitations" }); // change resource to invitations

const {
  tableQueryResult: { data, isLoading, isError },
  current,
  setCurrent,
  setPageSize,
  pageCount,
  sorter, setSorter,
  filters, setFilters,
} = useTable({ resource: "invitations" }); // change resource to invitations

The useTable hook will handle sorting, filtering, and pagination for you. You can find more information about the useTable hook in the Refine documentation (https://refine.dev/docs/api-reference/antd/hooks/table/useTable/). Make sure your backend is set up correctly to handle the refine requests, and the resource name matches the route in your backend. If you still face issues, you might want to check your network requests and server logs to identify any errors or misconfigurations. ---------------------- Note: you can ask me a follow up question by @ mentioning me again :speech_balloon: ----------------------

kapa.ai•2y ago

<@134090892167479296> kapa.ai is still learning and improving, please let us how it did by reacting below

like-goldOP•2y ago

@kapa.ai But my routes set as next: import userController from '../controllers/user.controller.js'; const { createUser, getAllUsers, getUserInfoById, sendInvitation, getInvitation, getAllInvitations } = userController; const router = express.Router(); router.route('/').get(getAllUsers); router.route('/').post(createUser); router.route('/:id').get(getUserInfoById); router.route('/invite').post(sendInvitation).get(getAllInvitations);; router.route('/invite/:token').get(getInvitation); export default router;

kapa.ai•2y ago

Let me check the knowledge base for you. One moment! :books: ---------------------- Based on your provided routes, you should change the resource in the useTable hook to match the route for getting all invitations in your backend. Since the route for getting all invitations is /invite, you should use the useTable hook as follows:

const {{
  tableQueryResult: {{ data, isLoading, isError }},
  current,
  setCurrent,
  setPageSize,
  pageCount,
  sorter, setSorter,
  filters, setFilters,
}} = useTable({{ resource: "invite" }}); // change resource to invite

const {{
  tableQueryResult: {{ data, isLoading, isError }},
  current,
  setCurrent,
  setPageSize,
  pageCount,
  sorter, setSorter,
  filters, setFilters,
}} = useTable({{ resource: "invite" }}); // change resource to invite

Make sure your backend is set up correctly to handle the refine requests, and the resource name matches the route in your backend. If you still face issues, you might want to check your network requests and server logs to identify any errors or misconfigurations. ---------------------- Note: you can ask me a follow up question by @ mentioning me again :speech_balloon: ----------------------

kapa.ai•2y ago

<@134090892167479296> kapa.ai is still learning and improving, please let us how it did by reacting below

like-goldOP•2y ago

@kapa.ai Whatever I'm trying the getAllInvitations is not hit

kapa.ai•2y ago

Let me check the knowledge base for you. One moment! :books: ---------------------- If the getAllInvitations endpoint is not being hit, there might be an issue with the data provider configuration in your refine app. To ensure that refine is correctly configured to work with your backend, you need to set up a custom data provider. Here's an example of a custom data provider from the Refine blog (https://refine.dev/blog/refine-react-invoice-generator-2):

const dataProvider = {{
  // ... other CRUD methods
  getList: async ({ resource, pagination, sort, filter, meta }) => {
    const { page, perPage } = pagination;
    const { field, order } = sort;
    // ... handle filters and other parameters

    const url = `${apiUrl}/${resource}?${stringify(query, {
      encodeValuesOnly: true,
    })}&${queryFilters}`;

    const { data } = await httpClient.get(url);

    return {
      data: normalizeData(data),
      total: parseInt(response.headers.get("x-total-count"), 10),
    };
  },
  // ... other CRUD methods
}};

const dataProvider = {{
  // ... other CRUD methods
  getList: async ({ resource, pagination, sort, filter, meta }) => {
    const { page, perPage } = pagination;
    const { field, order } = sort;
    // ... handle filters and other parameters

    const url = `${apiUrl}/${resource}?${stringify(query, {
      encodeValuesOnly: true,
    })}&${queryFilters}`;

    const { data } = await httpClient.get(url);

    return {
      data: normalizeData(data),
      total: parseInt(response.headers.get("x-total-count"), 10),
    };
  },
  // ... other CRUD methods
}};

Make sure to replace apiUrl with the base URL of your backend API, and adjust the request handling according to your backend's requirements. After setting up the custom data provider, you need to pass it to the <Refine> component in your app:

import { Refine } from "@pankod/refine";

<Refine dataProvider={dataProvider}>
  {/* Your app components */}
</Refine>

import { Refine } from "@pankod/refine";

<Refine dataProvider={dataProvider}>
  {/* Your app components */}
</Refine>

If you still face issues, check your network requests and server logs to identify any errors or misconfigurations. Additionally, ensure that your backend is running and accessible from your refine app. ---------------------- Note: you can ask me a follow up question by @ mentioning me again :speech_balloon: ----------------------

kapa.ai•2y ago

<@134090892167479296> kapa.ai is still learning and improving, please let us how it did by reacting below

Receive data from database

Did you find this page helpful?