Ko te tino wātea Ka whakarerekētia te CSV ki te JSON
Ka huri i ngā rārangi CSV ki tētahi rārangi JSON mārama o ngā ahanoa - wātea, tāpiri, whakarewa rānei, kāore he mea rokirokitia.
He pēhea te mahi
- Ka whakarato CSV. Whakapā atu ki tōna kupu CSV, ka whakarewa rānei i tētahi pūranga.csv.
- Ka whakaritea ngā kōwhiringa. E kī ana mēnā he pūtārua te rārangi tuatahi, ā, ka kōwhiria te whakawātea (whakapaeatanga, te tāpaeatanga,...).
- Ki te whiwhi JSON. Ko te tārua i te taupānga JSON i whakaritea, ka whakahuatia rānei hei pūkete.json.
Mo tēnei utauta
Ka huri te CSV ki te JSON i te raraunga tatauranga CSV ki tētahi taupānga JSON ka taea e koe te whakamahi i roto i te waehere, i tētahi API rānei. Whakapā te CSV, te whakarewa rānei i tētahi pūkete.csv, ki te kī ki a ia mēnā he pūtāhua te rārangi tuatahi, me te kōwhiri i te whakawātea mēnā kāore he kōaro. Me tētahi rārangi pūtāhua, ka noho ia raina hei ahanoa JSON i whakawaengatia e ngā ingoa tīwae; me te kore, ka noho ia raina hei taupānga. He pai te tāputa, e whakaritea ana ki te tārua, ki te whakahua rānei. Ka tātaritia ngā mea katoa i roto i te tono, ā, kāore e rokiroki i tētahi mea.
He aha te whakamahinga o te tangata mo ia
- Ka whakawātea te raraunga pūrākau ki tētahi API, taupānga rānei
- Ka tahuri tētahi CSV i waho ki te JSON mō te waehere
- Ka huri i tētahi tātai, tētahi rārangi hua rānei ki roto i te JSON hanganga
- Prototype me te raraunga tūturu me te kore tuhi i tētahi whakarārangi
Ka whakawhanakehia te API
Ka whakamātautau tēnei utauta i tōna ake waehere. Whakahaua tētahi tono POST ki te wāhi mutunga i raro iho, ā, ka whiwhi i te hua ōrite te utauta whatunga e whakaputaina ana. He whāiti te mokatere i ia IP, ā, kāore e hiahiatia he whakaingoatanga - Ka tae mai ngā kī API mō ngā tepenga tiketike ake.
https://best.free/api/tools/csv-to-json/
| Parameter | Hei tauira | E hiahiatia ana | Whakatuhi |
|---|---|---|---|
text |
name,age\nAda,36 |
He | CSV text (or upload a file on the web form). |
delimiter |
, |
Kāore | Field delimiter (use "tab" for TSV). |
header |
True |
Kāore | First row is a header. |
curl -X POST https://best.free/api/tools/csv-to-json/ \
-H 'Content-Type: application/json' \
-d '{"text": "name,age\\nAda,36", "delimiter": ",", "header": true}'
import requests
r = requests.post(
"https://best.free/api/tools/csv-to-json/",
json={"text": "name,age\nAda,36", "delimiter": ",", "header": True},
)
print(r.json())
const r = await fetch("https://best.free/api/tools/csv-to-json/", {
method: "POST",
headers: { "Content-Type": "application/json" },
body: JSON.stringify({ text: "name,age\nAda,36", delimiter: ",", header: true }),
});
const data = await r.json();
console.log(data);
Whakautu: JSON with the converted array in "json".
{"ok": true, "json": "[\n {\"name\": \"Ada\", \"age\": \"36\"}\n]"}