HTML表格提取器 API

API ID 13075

从任何网页提取每个HTML表格为干净的结构化JSON - 自动检测标题和行。只需传递一个URL;无需抓取代码。快速、无状态,并且为AI代理准备好MCP。

API 文档

端点

请求

获取一个公共网页并将其上的每个HTML表格作为结构化JSON返回,表头行自动检测,数据以数组形式返回。将页面URL作为'url'查询参数传递

Endpoint ID: 26455
GET https://zylalabs.com/api/13075/html+table+extractor+api/26455/extract+tables+from+url
输入参数

从网址提取表格 — 端点功能

对象 描述
url 必需 Public URL of the web page to extract tables from
url 必需

剩余免费测试请求:3 / 3。


输入参数

url
API 示例响应
JSON
{"ok":true,"tableCount":5,"tables":[{"headers":["Ranks","Name","Industry","Revenue","Profit","Employees","Headquarters[note 1]","State-owned","Ref."],"rowCount":51,"rows":[["USD (in billions)"],["1","Amazon","Retail Information technology","716","79.9","1,576,000","United States","","[5]"],["2","Walmart","Retail","713","21.8","2,100,000","","[6]"],["3","State Grid Corporation of China","Electricity","545","9.2","1,361,423","China","","[7]"],["4","Saudi Aramco","Oil and gas","480","106","73,311","Saudi Arabia","","[8]"],["5","China National Petroleum Corporation","476","25.2","1,026,301","China","","[9]"],["6","China Petrochemical Corporation","429","9.3","513,434","","[10]"],["7","Apple","Information technology","416","112","166,000","United States","","[11]"],["8","Alphabet","Information technology","402","132","190,820","","[12]"],["9","UnitedHealth Group","Healthcare","400","14.4","400,000","","[13]"],["10","Berkshire Hathaway","Financials","371","88.9","392,400","","[14]"],["11","CVS Health","Healthcare","357","8.3","259,500","","[15]"],["12","Volkswagen Group","Automotive","348","17.9","684,025","Germany","","[16]"],["13","ExxonMobil","Oil and gas","344","36.0","61,500","United States","","[17]"],["14","Vitol","Commodities","331","13.0","1,560","Switzerland","","[18][19]"],["15","Shell","Oil and gas","323","19.3","103,000","United Kingdom","","[20]"],["16","China State Construction Engineering","Construction","320","4.2","382,894","China","","[21]"],["17","Toyota","Automotive","312","34.2","380,793","Japan","","[22]"],["18","McKesson","Healthcare","308","3.0","48,000","United States","","[23]"],["19","Microsoft","Information technology","281","101","228,000","","[24]"],["20","Cencora","Healthcare","262","1.7","44,000","","[25]"],["21","Trafigura","Commodities","244","7.3","12,479","Singapore","","[26]"],["22","Costco","Retail","242","6.2","316,000","United States","","[27]"],["23","JPMorgan Chase","Financials","239","49.5","309,926","","[28]"],["24","Industrial and Commercial Bank of China","222","51.4","419,252","China","","[29]"],["25","Schwarz Gruppe","Retail","220","n/a","604,000","Germany","","[30]"],["26","TotalEnergies","Oil and gas","218","21.3","102,579","France","","[31]"],["27","Glencore","Commodities","217","4.2","83,426","Switzerland","","[32]"],["28","Nvidia","Semiconductors","215","120","36,000","United States","","[33]"],["29","BP","Oil and gas","213","15.2","79,400","United Kingdom","","[34]"],["30","Cardinal Health","Healthcare","205","0.26","47,520","United States","","[35]"],["31","Stellantis","Automotive","204","20.1","258,275","Netherlands","","[36]"],["32","Chevron","Oil and gas","200","21.3","45,600","United States","","[37]"],["33","China Construction Bank","Financials","199","46.9","376,871","China","","[38]"],["34","Samsung Electronics","Electronics","198","11.0","267,860","South Korea","","[39]"],["35","Foxconn","197","4.5","621,393","Taiwan","","[40]"],["36","Cigna","Healthcare","195","5.1","71,413","United States","","[41]"],["37","Agricultural Bank of China","Financials","192","38.0","451,003","China","","[42]"],["38","China Railway Engineering Corporation","Construction","178","2.1","314,149","China","","[43]"],["39","Cargill","Conglomerate","177","17.6","160,000","United States","","[44]"],["40","Ford Motor Company","Automotive","176","4.3","177,000","","[45]"],["41","Bank of China","Financials","172","32.7","306,931","China","","[46]"],["42","Bank of America","171","26.5","212,985","United States","","[47]"],["43","General Motors","Automotive","171","10.1","163,000","","[48]"],["44","Elevance Health","Healthcare","171","5.9","104,900","","[49]"],["45","BMW Group","Automotive","168","12.2","154,950","Germany","","[50]"],["46","Mercedes-Benz Group","Automotive","165","15.4","166,056","Germany","","[51]"],["47","Meta Platforms","Social media","164","62.3","78,450","United States","","[52]"],["48","China Railway Construction Corporation","Construction","160","1.7","336,433","China","","[53]"],["49","Baowu","Steel","157","2.4","258,697","","[54]"],["50","Citigroup","Financials","156","9.2","237,925","United States","","[55]"]]},{"headers":null,"rowCount":14,"rows":[[],["Rank","Country","Companies"],["1","United States","24"],["2","China","11"],["3","Germany","4"],["4","United Kingdom","2"],["4","Switzerland","2"],["5","Japan","1"],["5","France","1"],["5","Netherlands","1"],["5","South Korea","1"],["5","Saudi Arabia","1"],["5","Singapore","1"],["5","Taiwan","1"]]},{"headers":null,"rowCount":3,"rows":[["Capital accumulation Overaccumulation Economic inequality Wealth distribution Income distribution Yard-sale model Consumption distribution History of economic inequality Brazil China Denmark Germany India Latin America Philippines South Africa South Korea Sweden United States income inequality wealth inequality International inequality Elite Oligarchy Overclass Plutocracy Plutonomy Broligarchy Primitive accumulation of capital Upper class Nouveau riche (new money) Vieux riche (old money) Luxury goods Veblen goods Conspicuous consumption Conspicuous leisure Luxury beliefs"],["PeoplePeople","Trillionaire Billionaire Centibillionaire Millionaire Captain of industry High-net-worth individual Magnate Business Oligarch Business Russian Ukrainian Robber baron"],["WealthWealth","Concentration Distribution Effect Geography Inheritance Dynastic Estate planning Management National Paper Religion Tax"]]},{"headers":["PeoplePeople","Forbes list of billionaires List of centibillionaires Female billionaires Richest royals Wealthiest Americans Wealthiest families"],"rowCount":2,"rows":[["OrganizationsOrganizations","Largest companies by revenue Largest corporate profits and losses Largest corporations by market capitalization Largest financial services companies by revenue Largest manufacturing companies by revenue European Largest software companies by revenue Largest technology companies by revenue Religious organizations Charities Philanthropists Universities Endowment size Number of billionaire alumni"],["OtherOther","Cities by number of billionaires Countries by number of billionaires Countries by total wealth Countries by wealth inequality Most expensive items by category"]]},{"headers":null,"rowCount":4,"rows":[["Diseases of affluence Affluenza Acquired situational narcissism Argumentum ad crumenam Prosperity theology"],["PhilanthropyPhilanthropy","Gospel of Wealth The Giving Pledge Philanthrocapitalism Venture philanthropy"],["SayingsSayings","The rich get richer and the poor get poorer Socialism for the rich and capitalism for the poor Too big to fail"],["MediaMedia","Das Kapital Plutus Greek god of wealth Superclass List The Theory of the Leisure Class Wealth The Wealth of Nations"]]}]}
从网址提取表格 — 代码片段

curl --location --request GET 'https://zylalabs.com/api/13075/html+table+extractor+api/26455/extract+tables+from+url?url=https://en.wikipedia.org/wiki/List_of_largest_companies_by_revenue&url=Required' --header 'Authorization: Bearer YOUR_API_KEY' 


    

API 访问密钥和身份验证

注册后,每个开发者都会被分配一个个人 API 访问密钥,这是一个唯一的字母和数字组合,用于访问我们的 API 端点。要使用 HTML表格提取器 API 进行身份验证,只需在 Authorization 标头中包含您的 bearer token。

标头
标头 描述
授权 必需 应为 Bearer access_key. 订阅后,请查看上方的"您的 API 访问密钥"。

简单透明的定价

无长期承诺。随时升级、降级或取消。 免费试用包括最多 50 个请求。

(年度计费可节省 2 个月 🎉)

🚀 企业版套餐
自定义数量

  • 自定义速率限制
  • 团队与权限管理
  • SLA 保障的稳定性
  • 专业客户支持
  • 实时 API 监控
  • 企业级安全与合规
最低年度合同:10,000 美元

领先企业的信赖之选

概览

HTML表格提取器API将任何公共网页上的表格转换为可直接使用的JSON格式。它提取页面上的每个表格,自动检测标题行,并将每个表格作为标题和行数组的数组返回 - 干净、可预测,适合您的数据管道。处理复杂的现实世界HTML、嵌套标记和每页多个表格。快速、无状态,适合AI代理使用。非常适合抓取金融表格、体育统计、定价表格和维基百科数据,无需编写或维护解析器

HTML表格提取器 API FAQs

API返回包含指定网页上找到的每个HTML表格的结构化JSON数据。每个表格包括自动检测的标题和一个行数组,使得访问和利用数据变得简单

响应中的关键字段包括"ok"(状态)"tableCount"(提取的表格数量)和"tables"(一个表对象数组,每个对象包含"headers"、"rowCount"和"rows")

响应数据组织为一个JSON对象 包含状态指示符 提取的表格数量 以及一个表格对象数组 每个对象详细列出了标题和行的结构化格式

该API从HTML表格中提取各种类型的信息,包括财务数据、体育统计、定价表以及来自维基百科等来源的普通数据,具体取决于网页的内容

用户可以通过在GET请求中使用'url'查询参数指定他们想要提取表格的网页URL来自定义他们的请求

典型的使用案例包括提取财务表格以进行分析 收集体育统计数据以进行报告 汇编价格信息以进行比较 和从维基百科检索结构化数据以进行研究

该API直接从公共网页提取数据,依赖于源内容的固有准确性。然而,用户应该在关键应用中根据原始网页验证数据

用户可以期待返回数据的一致结构,每个表格包含标题以及后面的数据行 格式是可预测的,便于轻松集成到数据处理管道中

一般常见问题

Zyla API Hub 就像一个大型 API 商店,您可以在一个地方找到数千个 API。我们还为所有 API 提供专门支持和实时监控。注册后,您可以选择要使用的 API。请记住,每个 API 都需要自己的订阅。但如果您订阅多个 API,您将为所有这些 API 使用相同的密钥,使事情变得更简单。
价格以 USD(美元)、EUR(欧元)、CAD(加元)、AUD(澳元)和 GBP(英镑)列出。我们接受所有主要的借记卡和信用卡。我们的支付系统使用最新的安全技术,由 Stripe 提供支持,Stripe 是世界上最可靠的支付公司之一。如果您在使用卡片付款时遇到任何问题,请通过 [email protected]

此外,如果您已经以这些货币中的任何一种(USD、EUR、CAD、AUD、GBP)拥有有效订阅,该货币将保留用于后续订阅。只要您没有任何有效订阅,您可以随时更改货币。
定价页面上显示的本地货币基于您 IP 地址的国家/地区,仅供参考。实际价格以 USD(美元)为单位。当您付款时,即使您在我们的网站上看到以本地货币显示的等值金额,您的卡片对账单上也会以美元显示费用。这意味着您不能直接使用本地货币付款。
有时,银行可能会因其欺诈保护设置而拒绝收费。我们建议您首先联系您的银行,检查他们是否阻止了我们的收费。此外,您可以访问账单门户并更改关联的卡片以进行付款。如果这些方法不起作用并且您需要进一步帮助,请通过 [email protected]
价格由月度或年度订阅决定,具体取决于所选计划。
API 调用根据成功请求从您的计划中扣除。每个计划都包含您每月可以进行的特定数量的调用。只有成功的调用(由状态 200 响应指示)才会计入您的总数。这确保失败或不完整的请求不会影响您的月度配额。
Zyla API Hub 采用月度订阅系统。您的计费周期将从您购买付费计划的那一天开始,并在下个月的同一日期续订。因此,如果您想避免未来的费用,请提前取消订阅。
要升级您当前的订阅计划,只需转到 API 的定价页面并选择您要升级到的计划。升级将立即生效,让您立即享受新计划的功能。请注意,您之前计划中的任何剩余调用都不会转移到新计划,因此在升级时请注意这一点。您将被收取新计划的全部金额。
要检查您本月剩余多少 API 调用,请参考响应标头中的 "X-Zyla-API-Calls-Monthly-Remaining" 字段。例如,如果您的计划允许每月 1,000 个请求,而您已使用 100 个,则响应标头中的此字段将显示 900 个剩余调用。
要查看您的计划允许的最大 API 请求数,请检查 "X-Zyla-RateLimit-Limit" 响应标头。例如,如果您的计划包括每月 1,000 个请求,此标头将显示 1,000。
"X-Zyla-RateLimit-Reset" 标头显示您的速率限制重置之前的秒数。这告诉您何时您的请求计数将重新开始。例如,如果它显示 3,600,则意味着还有 3,600 秒直到限制重置。
是的,您可以随时通过访问您的账户并在账单页面上选择取消选项来取消您的计划。请注意,升级、降级和取消会立即生效。此外,取消后,您将不再有权访问该服务,即使您的配额中还有剩余调用。
为了让您有机会在没有任何承诺的情况下体验我们的 API,我们提供 7 天免费试用,允许您免费进行最多 50 次 API 调用。此试用只能使用一次,因此我们建议将其应用于您最感兴趣的 API。虽然我们的大多数 API 都提供免费试用,但有些可能不提供。试用在 7 天后或您进行了 50 次请求后结束,以先发生者为准。如果您在试用期间达到 50 次请求限制,您需要"开始您的付费计划"以继续发出请求。您可以在个人资料中的订阅 -> 选择您订阅的 API -> 定价标签下找到"开始您的付费计划"按钮。或者,如果您在第 7 天之前不取消订阅,您的免费试用将结束,您的计划将自动计费,授予您访问计划中指定的所有 API 调用的权限。请记住这一点以避免不必要的费用。
7 天后,您将被收取试用期间订阅的计划的全额费用。因此,在试用期结束前取消很重要。因忘记及时取消而提出的退款请求不被接受。
当您订阅 API 免费试用时,您可以进行最多 50 次 API 调用。如果您希望超出此限制进行额外的 API 调用,API 将提示您执行"开始您的付费计划"。您可以在个人资料中的订阅 -> 选择您订阅的 API -> 定价标签下找到"开始您的付费计划"按钮。
付款订单在每月 20 日至 30 日之间处理。如果您在 20 日之前提交请求,您的付款将在此时间范围内处理。
您可以通过我们的聊天渠道联系我们以获得即时帮助。我们始终在线,时间为上午 8 点至下午 5 点(EST)。如果您在该时间之后联系我们,我们将尽快回复您。此外,您可以通过 [email protected]

相关 API