how to solve the problem Promise { }

Question

I'm new in next JS, when I am trying to display my data in a particular route , its not showing , can anyone tell me why its not showing, if you have any query regarding my question please free fell to ask.

import { getDataFromSheets } from "../../libs/sheets";

export default function handler(req, res) {

    const sheet =  getDataFromSheets();

    console.log(sheet)

    res.status(200).json(sheet);

}

Your `getDataFromSheets` function is likely asynchronous. Does the part about async/await and promises in this question answer your question? [How to return the response from an asynchronous call](https://stackoverflow.com/questions/14220321/how-to-return-the-response-from-an-asynchronous-call) — Wing, Oct 10 '21 at 11:52
Hello @Monu Patil, can you try next time to avoid to post images containing code, instead you can copy directly the output as `code` text. It can improve the quality of the question. Thanks — axel, Oct 10 '21 at 11:54

score 1 · Answer 1 · edited Oct 11 '21 at 02:14

1

import { getDataFromSheets } from "../../libs/sheets";

export default async function handler(req, res) {
  const sheet = await getDataFromSheets();
  console.log(sheet);
  res.status(200).json(sheet);
}

edited Oct 11 '21 at 02:14

Jacob

1,577
8
24

answered Oct 10 '21 at 11:52

matthew2564

41
3

score 1 · Accepted Answer · answered Oct 10 '21 at 11:58

Use can solve this in a couple of ways,

Using async/await

import { getDataFromSheets } from "../../libs/sheets";

export default async function handler(req, res) {
    const sheet =  await getDataFromSheets();
    console.log(sheet)
    res.status(200).json(sheet);
}

Using .then(), .catch()

import { getDataFromSheets } from "../../libs/sheets";

export default function handler(req, res) {
    getDataFromSheets()
      .then(sheet=> res.status(200).json(sheet))
      .catch(err=> console.log(err))
}

how to solve the problem Promise { }

2 Answers2