# Picks and Packs Question **URL:** \ **Category:** GraphQL API\ **Created:** [March 21, 2023, 8:36pm UTC](https://community.shiphero.com/t/picks-and-packs-question/2409 "2023-03-21T20:36:12Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![cschouten](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@cschouten](https://community.shiphero.com/u/cschouten)\ **Post date:** [March 21, 2023, 8:36pm UTC](https://community.shiphero.com/t/picks-and-packs-question/2409/1 "2023-03-21T20:36:12Z")
Hi there! Quick question with respect to packs\_per\_day and picks\_per\_day… How often does the underlying system run to generate the packs\_per\_day and picks\_per\_day data? In other words, for example, is it the case that when a pick is created, the record gets generated almost instantly and is then available in the API (like a live stream), or is there a “refresh process” that runs on a schedule for those endpoints (like a batch process)? All the best, Colin ---
**Author:** ![sh-agent](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@sh-agent](https://community.shiphero.com/u/sh-agent)\ **Post date:** [March 22, 2023, 11:43am UTC](https://community.shiphero.com/t/picks-and-packs-question/2409/2 "2023-03-22T11:43:59Z")
Hey @cschouten, Thanks for reaching out! Going to look into this one and get back to you. Please let me know if you have any questions or concerns. Best, RayanP ---
**Author:** ![sh-agent](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@sh-agent](https://community.shiphero.com/u/sh-agent)\ **Post date:** [March 22, 2023, 4:13pm UTC](https://community.shiphero.com/t/picks-and-packs-question/2409/3 "2023-03-22T16:13:27Z")
Hey @cschouten, Thanks for hanging in there! I believe the record is generated almost instantly. I just tested in my test account using `packs_per_day`, within the same minute as packing my order, I was able to return results using the query. Please let me know if you have any questions or concerns. Best, RayanP ---
**Author:** ![cschouten](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@cschouten](https://community.shiphero.com/u/cschouten)\ **Post date:** [March 22, 2023, 4:36pm UTC](https://community.shiphero.com/t/picks-and-packs-question/2409/4 "2023-03-22T16:36:38Z")
Thanks @sh-agent. Just to clarify, is this also the case for picks\_per\_day? All the best, Colin ---
**Author:** ![cschouten](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@cschouten](https://community.shiphero.com/u/cschouten)\ **Post date:** [March 24, 2023, 3:55pm UTC](https://community.shiphero.com/t/picks-and-packs-question/2409/5 "2023-03-24T15:55:20Z")
@sh-agent Is picks\_per\_day also updated near instantly or does it run on a batch process? ---
**Author:** ![sh-agent](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@sh-agent](https://community.shiphero.com/u/sh-agent)\ **Post date:** [March 24, 2023, 5:57pm UTC](https://community.shiphero.com/t/picks-and-packs-question/2409/6 "2023-03-24T17:57:05Z")
Hey @cschouten, Thanks for hanging in there! I believe there is a slight delay in the `picks_per_day` query, but not the` packs_per_day` query. Please let me know if you have any questions or concerns. Best, RayanP ---
**Author:** ![cschouten](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@cschouten](https://community.shiphero.com/u/cschouten)\ **Post date:** [March 24, 2023, 6:18pm UTC](https://community.shiphero.com/t/picks-and-packs-question/2409/7 "2023-03-24T18:18:54Z")
Thanks @sh-agent! That’s interesting. Do you know the precise delay? I ask because we’re building an incremental data pipeline, and I’d need to know the “start time” (or date\_from) value to ensure I get all the records for a specific window of time. For example, if I run a task to grab all picks\_per\_day between 11 AM and 12 PM—and some records aren’t available from the API until after that 12 PM timestamp, I’ll miss ingesting said records, creating gaps in our data warehouse. All the best, Colin ---
**Author:** ![sh-agent](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@sh-agent](https://community.shiphero.com/u/sh-agent)\ **Post date:** [March 24, 2023, 6:45pm UTC](https://community.shiphero.com/t/picks-and-packs-question/2409/8 "2023-03-24T18:45:37Z")
Hey @cschouten, I’ll need a little bit of time to get an exact number from my tests. I’ll get back to you on this. Please let me know if there’s anything I can do to assist in the meantime. Best, RayanP ---
**Author:** ![cschouten](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@cschouten](https://community.shiphero.com/u/cschouten)\ **Post date:** [March 24, 2023, 6:56pm UTC](https://community.shiphero.com/t/picks-and-packs-question/2409/9 "2023-03-24T18:56:16Z")
Awesome! Thank you @sh-agent! All the best, Colin ---
**Author:** ![cschouten](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@cschouten](https://community.shiphero.com/u/cschouten)\ **Post date:** [April 3, 2023, 6:45pm UTC](https://community.shiphero.com/t/picks-and-packs-question/2409/10 "2023-04-03T18:45:09Z")
Any update on this @sh-agent? All the best, Colin