Ko te tino wātea Ka whakarerekētia te kaimahi ki te kaimahi
Ka whakawātea tētahi rārangi JSON o ngā ahanoa ki tētahi CSV-mātau-whakahaere - wātea, whakatū, whakarewa rānei, kāore he mea rokirokitia.
He pēhea te mahi
- Ka whakarato JSON. Whakapoho i tētahi rārangi JSON o ngā ahanoa (he ahanoa kotahi rānei), ka whakarewa rānei i tētahi pūranga.json.
- Ka tahuri. Pāpāho Pārere - Ka hangaia ngā tīwae mai i ngā kī i runga i ngā ahanoa katoa.
- Ki te whiwhi CSV. Ko te tārua o te CSV, ka whakataki rānei ki te whakatūtū i roto i tētahi tātai.
Mo tēnei utauta
Ka whakawātea a JSON ki te CSV i tētahi rārangi JSON o ngā ahanoa ki tētahi CSV māia-whakahaere. Ka whakatū te JSON, ka whakarewa rānei i tētahi.json, ā, ka hanga te utauta i ngā taitapa tīwae mai i te whakakotahitanga o ngā pātū o ia ahanoa, kia āhua tonu ai ngā rārangi me ngā āpure rerekē. Ka tuhituhi ngā ahanoa me ngā rārangi i roto i te JSON whāiti i roto i tō rātou pūtau, kaua e whakawātea. Ka whakatuwheratia te hua i Excel, Sheets, Numbers rānei. Ka tātaritia ngā mea katoa i roto i te tono, ā, kāore he mea i rokirokitia.
He aha te whakamahinga o te tangata mo ia
- Ka whakatuwheratia te urupare JSON API i roto i tētahi tātai
- Ka huri i te JSON i kawea mai ki te CSV mō te Excel, ngā Ripanga rānei
- Whakawehe i ngā raraunga hanganga ki ngā hoa mahi kāore i te hangarau
- Ka whakarārangi-whakamātautau ngā pūkete JSON hei rārangi me ngā tīwae
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/json-to-csv/
| Parameter | Hei tauira | E hiahiatia ana | Whakatuhi |
|---|---|---|---|
text |
[{"name":"Ada","age":36}] |
He | A JSON array of objects. |
curl -X POST https://best.free/api/tools/json-to-csv/ \
-H 'Content-Type: application/json' \
-d '{"text": "[{\"name\":\"Ada\",\"age\":36}]"}'
import requests
r = requests.post(
"https://best.free/api/tools/json-to-csv/",
json={"text": "[{\"name\":\"Ada\",\"age\":36}]"},
)
print(r.json())
const r = await fetch("https://best.free/api/tools/json-to-csv/", {
method: "POST",
headers: { "Content-Type": "application/json" },
body: JSON.stringify({ text: "[{\"name\":\"Ada\",\"age\":36}]" }),
});
const data = await r.json();
console.log(data);
Whakautu: JSON with the CSV text in "csv".
{"ok": true, "csv": "name,age\r\nAda,36\r\n"}