Heyyy all, how can i get data between specifi date...
# randoma
Andrés Romaña
12/30/2021, 5:22 PMHeyyy all, how can i get data between specifi dates with axios ?
for example, i need a get data between 2019-11-01 and 2019-11-05
let startDate = "2019-12-01";
let endDate = "2019-12-05";
let url = `https://tmyaapiiehere.app/compras?date=${startDate}&date=${endDate}`; (editado)
can anyone send me a docs for read about how can do it ?? or send me a message please!!!
m
Maciek K
12/30/2021, 6:08 PM Copy code
prisma.yourmodel.findMany({
where: {
startDate: { gte: "2019-12-01" },
endDate: { lte: "2019-12-05" ),
}
})a
Andrés Romaña
12/30/2021, 6:17 PMHey Maciek, thanks but not; i need do it with axios in node!!
m
Maciek K
12/30/2021, 6:29 PMBut this is Prisma slack 🙂 Axios is just for fetching an endpoint. On that endpoint you would have the prisma call, right?
Maciek K
12/30/2021, 6:30 PM Copy code
axios.get('/apiEndpointWherePrismaCallIs', { params: {
startDate: startDate,
endDate: endDate
}
}) })Maciek K
12/30/2021, 6:30 PMCan you clarify more, so we can help?
Maciek K
12/30/2021, 6:36 PMIt's been a long time since I did REST, but if you're using express then probably something like this:
Copy code
app.get(`/postEndpoint`, async (req, res) => {
const { startDate, endDate } = req.body
const result = await prisma.yourmodel.findMany({
where: {
startDate: { gte: startDate },
endDate: { lte: endDate ),
}
})
res.json(result)
})Maciek K
12/30/2021, 6:37 PMMaybe see example here: https://github.com/prisma/prisma-examples/blob/latest/javascript/rest-express/src/index.js
Maciek K
12/30/2021, 6:41 PMAlso you have two
datea
Andrés Romaña
12/30/2021, 6:54 PMYeah thats that i need, but not with prisma only fetching a API to show the data between two dates