Skip to main content
Best answer

Long term storage of large list

  • March 17, 2022
  • 2 replies
  • 99 views

Forum|alt.badge.img+1

So I’ve just discovered Storage (thanks Troy) and I’m wondering if it is a good fit for another project that I’m working on.

After reading the docs, I wasn’t clear on a couple of things but first I’ll present my use case.

  • I’m trying to manage a list of ID numbers (10 digits each)
  • At any given point there can be about 2,000 different IDs
  • My zap is just going to check if an ID exists before moving on

Questions:

  1. Key limit is 500 keys. I’ll only have key (ID), though, right?
  2. Inactive keys deleted after 3 months. Does this mean if a key is not acted upon (value added, deleted, searched, etc.) that they entire list goes away or just specific values in the list? I assume the first but I read something somewhere that suggested the later.
  3. Storage values up to 25kb. Does this mean each value can be up to 25kb or the key has a 25kb limit across all values? Want to make sure I don’t run into any limits.

I was also thinking that, instead of an action to add/remove IDs one at a time, that I would instead replace all values in one go. Like a sync. Is that possible?

Best answer by Troy Tessalone

Hi @ericg 

Good question.

You’d be better served using an Airtable Base as the Lookup Table.

 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • March 17, 2022

Hi @ericg 

Good question.

You’d be better served using an Airtable Base as the Lookup Table.

 

 


Forum|alt.badge.img+1
  • Author
  • Tinkerer
  • March 17, 2022

Thanks, @Troy Tessalone. Appreciate you!