Articles in this section

Lookup caches – FAQs

Anitha Abraham
Updated

Note

Lookup caches are not supported in Mapper 1.0 and Rules 1.0.

FAQs are categorized under the following sections:

Access lookup caches

Why can't I see the Lookup caches feature listed under Resources?

The Lookup caches feature is only available to Professional and Enterprise plan users. You can request an upgrade by reaching out to your Celigo account manager.

What are the data limitations?

See "Size limits for lookup caches" in the Lookup caches overview article.

What are the usage restrictions on lookup caches?

Note

The Lookup caches feature is available only in Enterprise and Professional plans.

Based on your subscription plan, you can use:

  • 100 million read + write units per month: For Enterprise account

  • 25 million read + write units per month: For Professional account

Whether you are reading from or writing to the lookup cache, the request will be counted in terms of units.

  • 1 read unit is a retrieved “key-value” that is equal to or less than 4 KB. (1 read unit ≤ 4 KB)

  • 1 write unit is a written “key-value” that is equal to or less than 1 KB. (1 write unit ≤ 1 KB)

If you are within the monthly limits, you can have any ratio of read to write requests.

Create lookup caches

What kinds of data can be stored in lookup caches?

Any data that has a scope to be referenced many times or reused can be stored in multiple caches. The lookup cache data should be structured in key-value pairs, where value can be a string, number, boolean, object/nested object, and the key can be string.

Disclaimer

Based on your requirement, you can use the lookup cache capability to store data for quick access and reuse across integration flows in the account. Celigo prioritizes security, and we take reasonable measures to safeguard the data. However, Celigo makes no warranties for any sensitive information stored in the lookup cache on the Celigo platform, and you are fully responsible for ensuring compliance with your corporate policies and applicable regulatory guidelines surrounding such data.

Are there restrictions on "key/value" properties?

“key” and “value” as property names in lookup caches are not supported because they are reserved keywords.

Do we support any file formats besides the CSV format?

Not directly. You can convert other file formats (for example, JSON, XLSX) to the CSV format or use the data loader.

Upload or download lookup caches

How can I upload a large CSV file?

You can split the data into several 5 MB files or use the data loader.

Can I re-upload the CSV file?

Yes. But, ensure to use the “key” column as lookup cache key again so that all the data matches after re-upload.

Why is it that my downloaded lookup cache does not contain any data?

You must check that the Include data when lookup cache is cloned or downloaded box in the Create/Lookup cache form is selected before you download the lookup cache. Also, ensure that data is less than 5 MB.

Clone lookup caches

What is difference between the Clone and Use existing options when I am trying to clone a flow/integration?

The difference between the Clone and Use existing options is as follows:

  • Clone: Use to create a copy and make changes for planning or testing new use cases for lookup caches. This option is available when cloning a flow/integration within the same environment.

  • Use existing: Use to maintain consistency across flows or integrations. (no new lookup caches will be created)

What is the size limit for cloning lookup caches?

The size of all cloned lookup caches is limited to 5 MB. Remember that lookup cache data will be included only if Include data when lookup cache is cloned or downloaded box is checked in the Create/Edit lookup cache form of the original lookup cache.

Delete or purge lookup caches

What is the difference between deleting and purging a lookup cache?

The difference between deleting and purging a lookup cache is as follows:

  • Purge: Permanently removes only all the entries from the lookup cache. The lookup cache itself is not removed and retains its linkages to associated flow steps.

  • Delete: Removes the lookup cache with all its entries to the Recycle bin for 30 days, after which it will be permanently removed.

Can I restore a deleted lookup cache?

You can restore your lookup cache from the Recycle bin within 30 days of deletion. After this period, the lookup cache will be permanently deleted.

Can I reverse purging lookup cache data?

No. The purged data is permanently removed from the Celigo platform.