{"uid":"cap_gWrJIoSPMrYSeyOaBx9-w","slug":"hubvibe-open-data-file-to-json-rows-7361bbc0","name":"HubVibe Open Data File to JSON Rows","description":"Dataset file to JSON rows: a CSV, TSV, XLSX or JSON link from any portal, an e-Stat (Japan) download or a data.go.kr (Korea) dataset page. Encoding detected (Korean, Japanese, Chinese, UTF and Western code pages), header row found, numbers typed, XLSX sheets selectable, large files capped and disclosed. Use it after opendata.search or on any data file URL. Input: url; optional max_rows, sheet, encoding, delimiter.","url":"https://hubvibe-io.com/work/opendata/table?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"url":{"type":"string"},"sheet":{"type":["string","integer"]},"encoding":{"type":"string","maxLength":30},"language":{"type":"string","pattern":"^[A-Za-z]{2,3}(-[A-Za-z0-9]{2,8})*$","maxLength":35},"max_rows":{"type":"integer","maximum":2000,"minimum":1},"delimiter":{"type":"string","maxLength":1,"minLength":1}}},"responseSchema":{"type":"json","example":{"result":{"rows":[{"성별":"남자","내국인":564888,"행정구역명":"울산광역시","행정구역코드":31}],"bytes":12331,"notes":[],"sheet":"Sheet1","format":"csv","sheets":[],"columns":["행정구역코드","행정구역명","성별","내국인"],"encoding":"cp949","file_url":"https://www.data.go.kr/cmm/cmm/fileDownload.do?atchFileId=FILE_000000003522968&fileDetailSn=1&insertDataPrcus=N","filename":"울산광역시_인구 현황(20251112).csv","final_url":"https://www.data.go.kr/cmm/cmm/fileDownload.do?atchFileId=FILE_000000003522968&fileDetailSn=1&insertDataPrcus=N","row_count":5,"truncated":true,"checked_at":"2026-09-26T18:00:00Z","source_url":"https://www.data.go.kr/data/15005995/fileData.do","total_rows":45,"column_count":14,"content_type":"application/octet-stream","resolved_from":"https://www.data.go.kr/data/15005995/fileData.do"},"status":"ok","worker":"opendata.table","price_usd":0.1,"provenance":{"steps":[{"ms":312,"ok":true,"step":"quote","reason":"provider_timeout","provider":"coinbase-advanced-trade-public"}],"attempts":1,"elapsed_ms":340,"providers_used":["coinbase-advanced-trade-public"]},"receipt_id":"rcpt_9f1c2b3a4d5e6f70","attribution":[{"url":"https://translate.google.com","text":"Translated by Google"}],"receipt_url":"/work/receipts/rcpt_9f1c2b3a4d5e6f70"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.1","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.1/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.1","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.1","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_zS_Jfidgf_GoZG7wRO3ql","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.1","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Fetches a CSV, TSV, XLSX, or JSON data file from any open data portal URL (including e-Stat Japan and data.go.kr Korea) and returns parsed, typed JSON rows with encoding detection and header discovery.","exampleAgentPrompt":"Fetch the CSV file at https://www.data.go.kr/data/15005995/fileData.do and convert it to JSON rows — detect the encoding automatically and return up to 500 rows.","exampleUseCases":[{"title":"Parse Korean population CSV from data.go.kr","prompt":"I have this data.go.kr dataset page URL: https://www.data.go.kr/data/15005995/fileData.do — can you download the CSV file, auto-detect the Korean encoding, and give me the first 200 rows as JSON?"},{"title":"Read a specific sheet from a Japanese e-Stat Excel file","prompt":"There's an XLSX file from e-Stat Japan at this URL — please parse the second sheet called '都道府県' and return up to 1000 rows as typed JSON rows."},{"title":"Convert TSV open data file with custom delimiter","prompt":"Can you fetch the tab-separated file at https://example.gov/data/exports/stats.tsv and parse it into JSON rows, using tab as the delimiter and capping at 300 rows?"}],"resultDescription":"Returns a JSON object containing: an array of typed row objects keyed by column name, the list of column names, detected file format (csv/tsv/xlsx/json), detected encoding (e.g. cp949, utf-8), row count, total row count, truncation flag, sheet name used, available sheets in XLSX files, the resolved download URL, filename, and metadata like bytes and checked_at timestamp.","failureModes":["URL is not accessible or returns a non-data content type — endpoint may return an error or empty result","File is too large and rows are capped — truncated flag is set to true and total_rows is disclosed","Encoding cannot be detected — may fall back to a best-guess or return garbled text","XLSX sheet name or index not found — error or default sheet used","URL points to an HTML page rather than a direct file — may attempt to resolve download link or fail","Payment not received — 402 response before processing begins"],"whenToPreferThis":"Choose this endpoint when you have a direct URL (or a data.go.kr / e-Stat portal page URL) to a structured data file (CSV, TSV, XLSX, JSON) and need it parsed into typed JSON rows with automatic encoding detection — especially for Asian-language government datasets that use non-UTF encodings like CP949 or Shift-JIS. Prefer this over general-purpose scrapers when you need column headers discovered, numbers typed, and sheet selection for Excel files.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-02T12:30:07.548Z","isFirstParty":false,"canonicalSlug":"hubvibe-open-data-file-to-json-rows-7361bbc0"}