A Lens add-on

Your reporting table,
as a live API.

Lookups publishes any Lens table as a key/value API your website, tag manager or app can call in single-digit milliseconds. One table, one key, one answer. No engineering project.

Requires Lens. 14-day free trial, no credit card.

The data is already there. The site still cannot read it.

Your product catalogue, your store list, your price bands, your loyalty tiers. All of it is sitting in a reporting table nobody can query from a web page. So the site gets a hardcoded copy that goes stale, or a ticket goes into an engineering backlog.

Reporting data is read-only in practice

A warehouse table is built for dashboards. Pointing a live web page at it means either a slow query or a nightly export somebody has to maintain.

Hardcoded copies drift

A JSON blob pasted into a tag or a page ships once and then quietly diverges from the source. Nobody notices until a price or a store address is wrong.

A small API is still a project

Standing up an endpoint means a service, a deployment, keys, monitoring and someone to own it. That is a lot of ceremony for one table.

From table to endpoint in four steps

1

Pick a Lens table

Any table Lens already maintains. It might come from a CSV you upload, a REST feed, BigQuery, your Echo event stream or a join across several sources. If Lens can build it, Lookups can publish it.

2

Declare the lookup keys

Choose the columns that identify a row: a SKU, a store number, a postcode, a customer tier. Those columns become the key you call the API with.

3

Publish and lock it down

Publishing mirrors the table into a low-latency key/value store behind its own endpoint. Each lookup gets its own access key, and you can restrict which sites are allowed to call it with an origin allowlist.

4

Call it from anywhere

A tag in GTM, a script on the page, a mobile app, a server. Pass the key, get the row back. Requests are metered so you can see exactly what is being asked for.

One primitive, a lot of jobs

Anything shaped like "give me this key, tell me about it" fits.

Product catalogues

Look up a SKU and get back name, category, margin band or whatever else the table holds. Useful for enriching a tag payload without asking the site to carry the whole catalogue.

Store locators

Store number in, address and opening hours out. The list stays maintained in Lens where the rest of the business already keeps it.

Pricing matrices

Region, tier or quantity in, price out. One table, one key, and no pricing logic duplicated into front-end code.

Loyalty tiers

Resolve a customer identifier to a tier or segment at page load, so personalization and tagging can act on it straight away.

What you get

Single-digit millisecond responses

The published table is mirrored into a key/value store built for point reads, not scans. It answers fast enough to sit in a page load without anyone noticing it.

Its own access key

Every lookup is published with its own key, separate from your TagPipes login and from every other lookup. Revoking one does not touch anything else.

Origin allowlist

Restrict a lookup to the sites you name. Calls from anywhere else are refused, so a public key does not mean a public free-for-all.

Metered per request

Every call is counted, so you can see which lookups are actually being used and what they cost before you scale them up.

Composite keys

A lookup can be keyed on more than one column. Region plus tier, store plus day, brand plus SKU. The combination is the key.

Fed by everything Lens supports

CSV uploads, REST feeds, BigQuery, Search Console, Adobe, Olo, your own S3 bucket, Echo events, or a join across several of them. The lookup does not care where the rows came from.

Simple Pricing

Metered on lookup API requests per month. Annual billing pays for ten months and covers twelve. One-time setup fee applies.

Essentials

$99/mo
Start Free Trial
Most Popular

Professional

$249/mo
Start Free Trial

Enterprise

$599/mo
Start Free Trial

Lookups requires a Lens subscription. Add-ons available for request overage, hourly mirror refresh and additional mirrored rows. Questions about limits? .

Frequently Asked Questions

Stop copying data into your site.

Publish the table you already maintain and let the site read it live.