CSV到JSON转换器 API

API ID 13073

通过URL或原始文本将CSV转换为干净、类型化的JSON 自动检测数字、布尔值和空值 处理带引号的字段、嵌入逗号和自定义分隔符(RFC-4180) 快速、无状态,并为AI代理准备MCP

128 ms 平均响应

API 文档

端点

请求

从公共网址获取CSV文件并将其作为干净的、类型化的JSON返回。自动检测数字、布尔值和空值。正确处理带引号的字段、嵌入的逗号和自定义定界符(RFC-4180)。通过“url”查询参数传递CSV位置

Endpoint ID: 26448
GET https://www.zylalabs.com/api/13073/csv+to+json+converter+api/26448/convert+csv+to+json
输入参数

将CSV转换为JSON — 端点功能

对象 描述
url 必需 Public URL of the CSV file to convert (e.g. https://example.com/data.csv)
url 必需

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


输入参数

url
API 示例响应
JSON
{"ok":true,"rowCount":50,"fields":["code","state","category","total exports","beef","pork","poultry","dairy","fruits fresh","fruits proc","total fruits","veggies fresh","veggies proc","total veggies","corn","wheat","cotton"],"data":[{"code":"AL","state":"Alabama","category":"state","total exports":1390.63,"beef":34.4,"pork":10.6,"poultry":481,"dairy":4.06,"fruits fresh":8,"fruits proc":17.1,"total fruits":25.11,"veggies fresh":5.5,"veggies proc":8.9,"total veggies":14.33,"corn":34.9,"wheat":70,"cotton":317.61},{"code":"AK","state":"Alaska","category":"state","total exports":13.31,"beef":0.2,"pork":0.1,"poultry":0,"dairy":0.19,"fruits fresh":0,"fruits proc":0,"total fruits":0,"veggies fresh":0.6,"veggies proc":1,"total veggies":1.56,"corn":0,"wheat":0,"cotton":0},{"code":"AZ","state":"Arizona","category":"state","total exports":1463.17,"beef":71.3,"pork":17.9,"poultry":0,"dairy":105.48,"fruits fresh":19.3,"fruits proc":41,"total fruits":60.27,"veggies fresh":147.5,"veggies proc":239.4,"total veggies":386.91,"corn":7.3,"wheat":48.7,"cotton":423.95},{"code":"AR","state":"Arkansas","category":"state","total exports":3586.02,"beef":53.2,"pork":29.4,"poultry":562.9,"dairy":3.53,"fruits fresh":2.2,"fruits proc":4.7,"total fruits":6.88,"veggies fresh":4.4,"veggies proc":7.1,"total veggies":11.45,"corn":69.5,"wheat":114.5,"cotton":665.44},{"code":"CA","state":"California","category":"state","total exports":16472.88,"beef":228.7,"pork":11.1,"poultry":225.4,"dairy":929.95,"fruits fresh":2791.8,"fruits proc":5944.6,"total fruits":8736.4,"veggies fresh":803.2,"veggies proc":1303.5,"total veggies":2106.79,"corn":34.6,"wheat":249.3,"cotton":1064.95},{"code":"CO","state":"Colorado","category":"state","total exports":1851.33,"beef":261.4,"pork":66,"poultry":14,"dairy":71.94,"fruits fresh":5.7,"fruits proc":12.2,"total fruits":17.99,"veggies fresh":45.1,"veggies proc":73.2,"total veggies":118.27,"corn":183.2,"wheat":400.5,"cotton":0},{"code":"CT","state":"Connecticut","category":"state","total exports":259.62,"beef":1.1,"pork":0.1,"poultry":6.9,"dairy":9.49,"fruits fresh":4.2,"fruits proc":8.9,"total fruits":13.1,"veggies fresh":4.3,"veggies proc":6.9,"total veggies":11.16,"corn":0,"wheat":0,"cotton":0},{"code":"DE","state":"Delaware","category":"state","total exports":282.19,"beef":0.4,"pork":0.6,"poultry":114.7,"dairy":2.3,"fruits fresh":0.5,"fruits proc":1,"total fruits":1.53,"veggies fresh":7.6,"veggies proc":12.4,"total veggies":20.03,"corn":26.9,"wheat":22.9,"cotton":0},{"code":"FL","state":"Florida","category":"state","total exports":3764.09,"beef":42.6,"pork":0.9,"poultry":56.9,"dairy":66.31,"fruits fresh":438.2,"fruits proc":933.1,"total fruits":1371.36,"veggies fresh":171.9,"veggies proc":279,"total veggies":450.86,"corn":3.5,"wheat":1.8,"cotton":78.24},{"code":"GA","state":"Georgia","category":"state","total exports":2860.84,"beef":31,"pork":18.9,"poultry":630.4,"dairy":38.38,"fruits fresh":74.6,"fruits proc":158.9,"total fruits":233.51,"veggies fresh":59,"veggies proc":95.8,"total veggies":154.77,"corn":57.8,"wheat":65.4,"cotton":1154.07},{"code":"HI","state":"Hawaii","category":"state","total exports":401.84,"beef":4,"pork":0.7,"poultry":1.3,"dairy":1.16,"fruits fresh":17.7,"fruits proc":37.8,"total fruits":55.51,"veggies fresh":9.5,"veggies proc":15.4,"total veggies":24.83,"corn":0,"wheat":0,"cotton":0},{"code":"ID","state":"Idaho","category":"state","total exports":2078.89,"beef":119.8,"pork":0,"poultry":2.4,"dairy":294.6,"fruits fresh":6.9,"fruits proc":14.7,"total fruits":21.64,"veggies fresh":121.7,"veggies proc":197.5,"total veggies":319.19,"corn":24,"wheat":568.2,"cotton":0},{"code":"IL","state":"Illinois","category":"state","total exports":8709.48,"beef":53.7,"pork":394,"poultry":14,"dairy":45.82,"fruits fresh":4,"fruits proc":8.5,"total fruits":12.53,"veggies fresh":15.2,"veggies proc":24.7,"total veggies":39.95,"corn":2228.5,"wheat":223.8,"cotton":0},{"code":"IN","state":"Indiana","category":"state","total exports":5050.23,"beef":21.9,"pork":341.9,"poultry":165.6,"dairy":89.7,"fruits fresh":4.1,"fruits proc":8.8,"total fruits":12.98,"veggies fresh":14.4,"veggies proc":23.4,"total veggies":37.89,"corn":1123.2,"wheat":114,"cotton":0},{"code":"IA","state":"Iowa","category":"state","total exports":11273.76,"beef":289.8,"pork":1895.6,"poultry":155.6,"dairy":107,"fruits fresh":1,"fruits proc":2.2,"total fruits":3.24,"veggies fresh":2.7,"veggies proc":4.4,"total veggies":7.1,"corn":2529.8,"wheat":3.1,"cotton":0},{"code":"KS","state":"Kansas","category":"state","total exports":4589.01,"beef":659.3,"pork":179.4,"poultry":6.4,"dairy":65.45,"fruits fresh":1,"fruits proc":2.1,"total fruits":3.11,"veggies fresh":3.6,"veggies proc":5.8,"total veggies":9.32,"corn":457.3,"wheat":1426.5,"cotton":43.98},{"code":"KY","state":"Kentucky","category":"state","total exports":1889.15,"beef":54.8,"pork":34.2,"poultry":151.3,"dairy":28.27,"fruits fresh":2.1,"fruits proc":4.5,"total fruits":6.6,"veggies fresh":0,"veggies proc":0,"total veggies":0,"corn":179.1,"wheat":149.3,"cotton":0},{"code":"LA","state":"Louisiana","category":"state","total exports":1914.23,"beef":19.8,"pork":0.8,"poultry":77.2,"dairy":6.02,"fruits fresh":5.7,"fruits proc":12.1,"total fruits":17.83,"veggies fresh":6.6,"veggies proc":10.7,"total veggies":17.25,"corn":91.4,"wheat":78.7,"cotton":280.42},{"code":"ME","state":"Maine","category":"state","total exports":278.37,"beef":1.4,"pork":0.5,"poultry":10.4,"dairy":16.18,"fruits fresh":16.6,"fruits proc":35.4,"total fruits":52.01,"veggies fresh":24,"veggies proc":38.9,"total veggies":62.9,"corn":0,"wheat":0,"cotton":0},{"code":"MD","state":"Maryland","category":"state","total exports":692.75,"beef":5.6,"pork":3.1,"poultry":127,"dairy":24.81,"fruits fresh":4.1,"fruits proc":8.8,"total fruits":12.9,"veggies fresh":7.8,"veggies proc":12.6,"total veggies":20.43,"corn":54.1,"wheat":55.8,"cotton":0},{"code":"MA","state":"Massachusetts","category":"state","total exports":248.65,"beef":0.6,"pork":0.5,"poultry":0.6,"dairy":5.81,"fruits fresh":25.8,"fruits proc":55,"total fruits":80.83,"veggies fresh":8.1,"veggies proc":13.1,"total veggies":21.13,"corn":0,"wheat":0,"cotton":0},{"code":"MI","state":"Michigan","category":"state","total exports":3164.16,"beef":37.7,"pork":118.1,"poultry":32.6,"dairy":214.82,"fruits fresh":82.3,"fruits proc":175.3,"total fruits":257.69,"veggies fresh":72.4,"veggies proc":117.5,"total veggies":189.96,"corn":381.5,"wheat":247,"cotton":0},{"code":"MN","state":"Minnesota","category":"state","total exports":7192.33,"beef":112.3,"pork":740.4,"poultry":189.2,"dairy":218.05,"fruits fresh":2.5,"fruits proc":5.4,"total fruits":7.91,"veggies fresh":45.9,"veggies proc":74.5,"total veggies":120.37,"corn":1264.3,"wheat":538.1,"cotton":0},{"code":"MS","state":"Mississippi","category":"state","total exports":2170.8,"beef":12.8,"pork":30.4,"poultry":370.8,"dairy":5.45,"fruits fresh":5.4,"fruits proc":11.6,"total fruits":17.04,"veggies fresh":10.6,"veggies proc":17.2,"total veggies":27.87,"corn":110,"wheat":102.2,"cotton":494.75},{"code":"MO","state":"Missouri","category":"state","total exports":3933.42,"beef":137.2,"pork":277.3,"poultry":196.1,"dairy":34.26,"fruits fresh":4.2,"fruits proc":9,"total fruits":13.18,"veggies fresh":6.8,"veggies proc":11.1,"total veggies":17.9,"corn":428.8,"wheat":161.7,"cotton":345.29},{"code":"MT","state":"Montana","category":"state","total exports":1718,"beef":105,"pork":16.7,"poultry":1.7,"dairy":6.82,"fruits fresh":1.1,"fruits proc":2.2,"total fruits":3.3,"veggies fresh":17.3,"veggies proc":28,"total veggies":45.27,"corn":5.4,"wheat":1198.1,"cotton":0},{"code":"NE","state":"Nebraska","category":"state","total exports":7114.13,"beef":762.2,"pork":262.5,"poultry":31.4,"dairy":30.07,"fruits fresh":0.7,"fruits proc":1.5,"total fruits":2.16,"veggies fresh":20.4,"veggies proc":33.1,"total veggies":53.5,"corn":1735.9,"wheat":292.3,"cotton":0},{"code":"NV","state":"Nevada","category":"state","total exports":139.89,"beef":21.8,"pork":0.2,"poultry":0,"dairy":16.57,"fruits fresh":0.4,"fruits proc":0.8,"total fruits":1.19,"veggies fresh":10.6,"veggies proc":17.3,"total veggies":27.93,"corn":0,"wheat":5.4,"cotton":0},{"code":"NH","state":"New Hampshire","category":"state","total exports":73.06,"beef":0.6,"pork":0.2,"poultry":0.8,"dairy":7.46,"fruits fresh":2.6,"fruits proc":5.4,"total fruits":7.98,"veggies fresh":1.7,"veggies proc":2.8,"total veggies":4.5,"corn":0,"wheat":0,"cotton":0},{"code":"NJ","state":"New Jersey","category":"state","total exports":500.4,"beef":0.8,"pork":0.4,"poultry":4.6,"dairy":3.37,"fruits fresh":35,"fruits proc":74.5,"total fruits":109.45,"veggies fresh":21.6,"veggies proc":35,"total veggies":56.54,"corn":10.1,"wheat":6.7,"cotton":0},{"code":"NM","state":"New Mexico","category":"state","total exports":751.58,"beef":117.2,"pork":0.1,"poultry":0.3,"dairy":191.01,"fruits fresh":32.6,"fruits proc":69.3,"total fruits":101.9,"veggies fresh":16.7,"veggies proc":27.1,"total veggies":43.88,"corn":11.2,"wheat":13.9,"cotton":72.62},{"code":"NY","state":"New York","category":"state","total exports":1488.9,"beef":22.2,"pork":5.8,"poultry":17.7,"dairy":331.8,"fruits fresh":64.7,"fruits proc":137.8,"total fruits":202.56,"veggies fresh":54.7,"veggies proc":88.7,"total veggies":143.37,"corn":106.1,"wheat":29.9,"cotton":0},{"code":"NC","state":"North Carolina","category":"state","total exports":3806.05,"beef":24.8,"pork":702.8,"poultry":598.4,"dairy":24.9,"fruits fresh":23.8,"fruits proc":50.7,"total fruits":74.47,"veggies fresh":57.4,"veggies proc":93.1,"total veggies":150.45,"corn":92.2,"wheat":200.3,"cotton":470.86},{"code":"ND","state":"North Dakota","category":"state","total exports":3761.96,"beef":78.5,"pork":16.1,"poultry":0.5,"dairy":8.14,"fruits fresh":0.1,"fruits proc":0.2,"total fruits":0.25,"veggies fresh":49.9,"veggies proc":80.9,"total veggies":130.79,"corn":236.1,"wheat":1664.5,"cotton":0},{"code":"OH","state":"Ohio","category":"state","total exports":3979.79}],"_note":"Response truncated for documentation purposes"}
将CSV转换为JSON — 代码片段

curl --location --request GET 'https://zylalabs.com/api/13073/csv+to+json+converter+api/26448/convert+csv+to+json?url=https://raw.githubusercontent.com/plotly/datasets/master/2011_us_ag_exports.csv&url=Required' --header 'Authorization: Bearer YOUR_API_KEY' 


    

API 访问密钥和身份验证

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

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

简单透明的定价

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

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

🚀 企业版套餐
自定义数量

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

领先企业的信赖之选

概览

CSV到JSON转换器将任何CSV - 作为URL或原始文本传递 - 转换为干净、结构化的JSON,您的应用程序或AI代理可以立即使用。

 

主要特点:

  • 类型输出:数字、布尔值和空值自动检测,因此您获得的是实际的JSON类型,而不是字符串。
  • - 强大的解析:正确处理带引号的字段、嵌入的逗号和换行符,以及转义的引号(RFC-4180)。支持自定义分隔符。
  • - 两种输入:从任何公共URL获取CSV,或直接POST原始CSV文本。
  • - 标头模式:第一行成为对象键,或返回禁用标头的原始行。
  • - 快速且无状态:无需存储,无状态,低延迟响应 - 非常适合管道和AI/LLM工作流程。

非常适合数据管道、电子表格导入、ETL步骤以及需要从CSV文件中获取结构化数据的AI代理。

CSV到JSON转换器 API FAQs

API 返回结构化的 JSON 数据,自动检测数字、布尔值和 null 等类型。这确保了输出干净且可供应用程序或 AI 代理使用

响应包括“ok”、“rowCount”、“fields”和“data”等字段 “fields”数组列出了列名,而“data”包含实际记录作为带键值对的对象

响应结构为JSON对象。它包含一个成功指示器(“ok”)、处理的总行数(“rowCount”)、字段名称数组(“fields”)和作为对象数组的实际数据记录(“data”)

API提供来自CSV文件的信息,包括各种数据类型,如数值、字符串和布尔值。它可以处理多样的数据集,例如州出口或农业统计数据

用户可以通过指定“url”参数从公共网址获取CSV文件或直接发布原始CSV文本来定制请求。此外,他们可以选择启用或禁用对象键的标题模式

数据来源于公开可访问的CSV文件 用户必须提供有效的URL以确保API能够准确地获取和转换数据

典型用例包括数据管道、电子表格导入、ETL过程,以及需要从CSV文件中获取结构化数据进行分析或处理的人工智能应用

用户可以解析 JSON 响应以访问特定字段和值 结构化格式使其能够轻松集成到应用程序中,从而实现数据操作、分析和可视化

一般常见问题

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