惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

阮一峰的网络日志
阮一峰的网络日志
Last Week in AI
Last Week in AI
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
U
Unit 42
J
Java Code Geeks
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
罗磊的独立博客
月光博客
月光博客
腾讯CDC
Stack Overflow Blog
Stack Overflow Blog
小众软件
小众软件
B
Blog
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
美团技术团队
Y
Y Combinator Blog
T
Tailwind CSS Blog
宝玉的分享
宝玉的分享
酷 壳 – CoolShell
酷 壳 – CoolShell
博客园_首页
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
爱范儿
爱范儿
B
Blog RSS Feed
V
Visual Studio Blog
MyScale Blog
MyScale Blog

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant
CF7 to Airtable: Tables and Databases Not Loading in the ...
Rahul Sharma · 2026-06-24 · via DEV Community

You installed the CF7 to Airtable plugin, generated a token from your Airtable account, pasted it into the plugin settings, and now you are staring at an empty dropdown where your bases and tables should appear. The plugin says it connected but nothing loads.

This is exactly what one developer experienced and posted on the WordPress support forums. The fix was simple once the plugin author looked at the screenshots: the token was too short. It was either truncated when it was copied or the wrong type of token was used.

But there is more to this problem than just copy-paste errors. This post covers the full picture so you get your CF7 to Airtable integration working correctly the first time.

The Token Type Problem: Legacy API Key vs Personal Access Token

Airtable deprecated their legacy API keys in early 2024. If you have used Airtable for a while and have an old connection somewhere, you might have a legacy API key that looks like this:

keyXXXXXXXXXXXXXX

That format no longer works. Airtable now uses Personal Access Tokens (PATs). A correctly formatted PAT looks like this:

patXXXXXXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

It starts with pat, has a 17-character identifier, a dot, and then a long 64-character string. The full token is much longer than the legacy API key. If the token you pasted into the plugin is short or does not start with pat, that is why your tables are not loading.

The Scope Problem: Token Has No Permission to Read Bases

Even with a correctly formatted PAT, your tables will still not appear if the token does not have the right scopes assigned to it.

When you create a Personal Access Token in Airtable, you choose which permissions it has. The minimum scopes needed for a CF7 plugin to list your bases and tables are:

  • data.records:write so it can create new records from form submissions
  • schema.bases:read so it can read the list of your bases and tables

If schema.bases:read is missing, the plugin authenticates successfully but when it tries to fetch the list of your bases to populate the dropdown, Airtable returns an empty or forbidden response. From the plugin's side it looks like there are no bases. From your side it looks like the integration is broken.

Go back to your Airtable token settings at airtable.com/create/tokens, find the token you are using, and check which scopes are assigned. Add schema.bases:read if it is missing.

The Access Problem: Token Cannot See the Right Bases

The third reason tables do not load is that the token's access is not set to include the base you want to use.

When creating a PAT, you choose which bases it can access. You can set it to "All current and future bases" or restrict it to specific bases. If you restricted it and the base you want to connect to was not included, the plugin will not be able to see it.

Check the access settings on your token and make sure the base you want appears in the list, or change the access to "All bases" if you want the plugin to show everything.

How to Generate a Token That Actually Works

Go to airtable.com/create/tokens and create a new token. Give it a descriptive name like "WordPress CF7 Integration" so you can find it easily later.

Under Scopes, add at minimum:

  • data.records:write
  • schema.bases:read

Under Access, either select "All current and future bases" or choose the specific base your CF7 form should write to.

Click Create Token and copy the full token immediately. Airtable only shows you the complete token once. If you close the screen without copying it, you will need to regenerate it. The token starts with pat and is quite long. Copy all of it.

Paste the complete token into the plugin settings. If the bases and tables now appear in the dropdown, the token is working correctly.

Testing the Token Before Connecting the Plugin

If you want to confirm your token is valid before touching the plugin settings, you can test it with a quick API call. Open your browser's address bar or use any API testing tool and call:

GET https://api.airtable.com/v0/meta/bases
Authorization: Bearer YOUR_PAT_TOKEN

If the token is valid and has the right scopes, you get back a JSON object listing your bases with their IDs and names. If you get a 401 or 403 response, the token has an issue with either its validity or its scopes.

The Alternative: Connect CF7 Directly to Airtable's API

Dedicated CF7 to Airtable plugins require a specific token format and scope setup that varies by plugin version and Airtable API changes. When Airtable updates something, the plugin may stop working until it is updated too.

Contact Form to API connects CF7 directly to Airtable's REST API endpoint. You configure the specific Airtable base URL, add your PAT as a Bearer authorization header, and map your CF7 fields to the Airtable column names. Because you are calling the API directly with the exact endpoint and field names, there is no middleware layer that can break when Airtable changes their token format.

Quick Checklist

If your tables are not loading in the CF7 Airtable plugin:

Check that your token starts with pat and is the full length. A short token or one starting with key will not work.

Check the token scopes include schema.bases:read and data.records:write.

Check the token access includes the base you want to use.

Regenerate the token if you are unsure whether you copied it completely the first time.

Test the token directly against api.airtable.com/v0/meta/bases to confirm it works before blaming the plugin