search

OpenFn / lwala

1 stars 3 forks source link

Date range return 0 payload #120

Closed mtuchi closed 5 months ago

mtuchi commented 5 months ago

Summary

The WF-1-1 Bulk get HH cases job keeps getting 0 records when it runs despite the start and end date. We know there are records because it got a large file at first, and if you run the same range on postman.

The problem statement is that it returns 0 records given the same date range when it first run and got a large file: t => ?type=${t}&indexed_on_start=2023-01-11T18:00:00&limit=${limit}&indexed_on_end=2023-01-15T16:59:59

mtuchi commented 5 months ago

I have tested the query on postman and got zero

https://github.com/OpenFn/lwala/assets/6592749/f4025995-fc76-4360-bd67-1270d40929d2

mtuchi commented 5 months ago

It turns out the date range was wrong (the year was 2023 instead of 2024) that's why we were seeing zero results. @hngondoki has made the changes to the job code accordingly, See commit https://github.com/OpenFn/lwala/commit/bf9e7d003cc014696bf6dec8ce78f4da9c507282