英国
SW1A 1AA
预加载荷兰真实城市邮编映射与 ACM & PostNL 合规号段(+31 6 0000 xxxx),支持在下方分屏控制台一键切换边界压测并导出 Playwright / Stripe / SQL / CSV。
{
"meta": {
"service": "AddressQA",
"seed": "qa-nl-01",
"country": "NL",
"countrySlug": "nl",
"state": "ALL",
"taxFree": false,
"phoneMode": "safe",
"boundary": "normal",
"count": 1
},
"fixtures": [
{
"id": "qa-nl-01-1-NL-ZH",
"index": 1,
"seed": "qa-nl-01",
"boundary": "normal",
"recipient": {
"fullName": "Manon Bergstrom",
"nativeName": "Manon Bergstrom",
"displayName": "Manon Bergstrom",
"firstName": "Manon",
"lastName": "Bergstrom",
"email": "[email protected]"
},
"address": {
"line1": "Coolsingel 144",
"line1Native": "Coolsingel 144",
"line2": null,
"city": "Rotterdam",
"cityNative": "Rotterdam",
"state": "ZH",
"stateName": "South Holland",
"postalCode": "3011 AD",
"zipPlus4": "3011 AD",
"country": "NL",
"countryName": "Netherlands",
"formatted": "Coolsingel 144, Rotterdam, ZH 3011 AD, NL"
},
"phone": {
"countryCode": "NL",
"dialCode": "+31",
"areaCode": "10",
"regionCode": "ZH",
"regionName": "South Holland",
"city": "Rotterdam",
"mode": "safe",
"regulatorSafe": false,
"regulatorAuthority": "ACM & PostNL",
"e164": "+31600000926",
"international": "+31 600 000 926",
"national": "0600 000 926",
"rfc3966": "tel:+31600000926",
"digitsOnly": "0600000926"
},
"qaFlags": {
"taxFreeUsState": false,
"leadingZeroPostal": false,
"streetLength": 14,
"hasUnicode": false,
"hasLine2": false,
"regulatorSafePhone": false,
"postalRequired": true
}
}
]
} // Generated by AddressQA (seed: qa-nl-01, country: NL, boundary: normal)
import { test, expect, type Page } from '@playwright/test';
const checkoutFixture = {
"fullName": "Manon Bergstrom",
"email": "[email protected]",
"phoneE164": "+31600000926",
"line1": "Coolsingel 144",
"line2": "",
"city": "Rotterdam",
"state": "ZH",
"postalCode": "3011 AD",
"country": "NL"
};
async function fillCheckoutForm(page: Page, data: typeof checkoutFixture) {
await page.getByLabel(/full name/i).fill(data.fullName);
await page.getByLabel(/email/i).fill(data.email);
await page.getByLabel(/phone/i).fill(data.phoneE164);
await page.getByLabel(/address line 1|street/i).fill(data.line1);
if (data.line2) await page.getByLabel(/address line 2|apt|suite/i).fill(data.line2);
await page.getByLabel(/city/i).fill(data.city);
await page.getByLabel(/state|region|province/i).fill(data.state);
if (data.postalCode) await page.getByLabel(/zip|postal/i).fill(data.postalCode);
}
test('checkout validation (NL / normal)', async ({ page }) => {
const target = checkoutFixture;
await page.goto('/checkout');
await fillCheckoutForm(page, target);
await page.getByRole('button', { name: /continue|pay/i }).click();
await expect(page.getByTestId('order-summary-postal')).toHaveText(target.postalCode || 'N/A');
}); {
"shipping": {
"name": "Manon Bergstrom",
"phone": "+31600000926",
"address": {
"line1": "Coolsingel 144",
"line2": null,
"city": "Rotterdam",
"state": "ZH",
"postal_code": "3011 AD",
"country": "NL"
}
},
"billing_details": {
"name": "Manon Bergstrom",
"email": "[email protected]",
"phone": "+31600000926",
"address": {
"line1": "Coolsingel 144",
"line2": null,
"city": "Rotterdam",
"state": "ZH",
"postal_code": "3011 AD",
"country": "NL"
}
},
"metadata": {
"qa_seed": "qa-nl-01",
"qa_boundary": "normal",
"us_tax_free_state": "false",
"regulator_safe_phone": "false"
}
} -- AddressQA deterministic SQL seed (qa-nl-01)
INSERT INTO qa_address_fixtures (fixture_id, seed, full_name, email, phone_e164, phone_national, street_line1, street_line2, city, region_code, postal_code, country_code, tax_free_us_state) VALUES ('qa-nl-01-1-NL-ZH', 'qa-nl-01', 'Manon Bergstrom', '[email protected]', '+31600000926', '0600 000 926', 'Coolsingel 144', NULL, 'Rotterdam', 'ZH', '3011 AD', 'NL', FALSE); # Deterministic AddressQA Edge API request
curl -sS "https://addressqa.com/api/v1/fixtures?country=NL&seed=qa-nl-01" | jq .
# Export directly as Excel-safe CSV or Stripe Checkout JSON:
curl -sS "https://addressqa.com/api/v1/fixtures?country=NL&seed=qa-nl-01&format=stripe"
curl -sS "https://addressqa.com/api/v1/fixtures?country=NL&seed=qa-nl-01&format=csv" -o fixtures-qa-nl-01.csv fixture_id,seed,full_name,email,phone_e164,phone_national,street_line1,street_line2,city,state,postal_code,country,tax_free_us_state,boundary
qa-nl-01-1-NL-ZH,qa-nl-01,Manon Bergstrom,[email protected],+31600000926,0600 000 926,Coolsingel 144,,Rotterdam,ZH,3011 AD,NL,false,normal | 校验维度 | 规范与边界说明 |
|---|---|
| 邮编正则与长度 | 示例 1012 JS(最大长度 7,正则 /^\d{4}\s?[A-Z]{2}$/) |
| 前导零截断风险 | 标准非零或字母开头格式,仍建议使用 VARCHAR 存储 |
| E.164 电话与区号同步 | 国家码 +31,标准有效长度 9 位,安全段 +31 6 0000 xxxx |
| 典型测试城市样本 | Amsterdam (NH) · 邮编 1012 JS · 区号 20 |
| 权威标准来源 | 荷兰 4 位数字 + 2 位大写字母邮编(1012 JS),支持门牌号后置格式与 9 位有效数字电话校验。 (ACM & PostNL) |
| 行政区 | 代码 | 城市 | 邮编 | 区号 |
|---|---|---|---|---|
| Noord-Holland (North Holland) | NH | Amsterdam | 1012 JS | +31 (20) |
| Zuid-Holland (South Holland) | ZH | Rotterdam | 3011 AD | +31 (10) |
SW1A 1AA
10117
75001
28013