Using Sanity data in Next.js API routes for Snipcart integration

Hello, I am using Nextjs wiht Sanity and I want to have Sanity data available to be inported in pages/api/posts:api.js
export async function fetchSanity() {
const res = sanityClient.fetch(

*[_type == "post"] {
    	title,
   	 }

);
// .then((res) => (res.ok ? res : Promise.reject(res)))
const data = res;
return data;
}
When I call this function fetchSanity() in pages/api/posts, I get:
Promise {<pending>}
[[Prototype]]: Promise
[[PromiseState]]: "fulfilled"
[[PromiseResult]]: Array(1)
0: title: "My first post"
I can see the data as [PromiseResult], but I don't know what to do to get the data?

Hi Pieter, sanityClient.fetch returns a promise, you can unwrap it by calling

await

:

Won't work. With await I get the same behavoir. Maybe I can put the question some other way: I am using Snipcart as Webshop integration. Now Snipcart needs an API in pages/api/products from static defined products.json. But I would like to use the product data from Sanity instead. How can I do that?

Could you share how you are calling the function

fetchSanity

? You’d need to await that function as well

Hello Derek, nice to reply! I was trying to export fetchSanity() and import the result as data in the serverless function at /pages/api/products. This function is consumed by the Snipcart Shop in order to safeguard the payment process. But obviously it didn't work! Is there a different way to import the products in /pages/api/products?
/utils/api.js
import sanityClient from '../client';
export async function fetchSanity() {
const res = await sanityClient.fetch(

*[_type == "post"] {
    title,
   }

);
const data = res;
return data;
}

/pages/api/products/index.ts
import {NextApiRequest, NextApiResponse} from "next";
import {products} from "../../../components/Products"; // hardcoded here!
export default function handler(req: NextApiRequest, res: NextApiResponse) {
res.status(200).json(products);
}

Hey Pieter, your

sanityClient

functions look fine to me — you’d use it in your handler like this:

Note that your handler function has to be async & sanityFetch has to be awaited

Hey Pieter, your

sanityClient

functions look fine to me — you’d use it in your handler like this:

Note that your handler function has to be async & sanityFetch has to be awaited

Thank you so much! I forgot to make the handler async, may bad. Now it works fine! Cheers, Pieter