
CSV ãã JSON ã³ã³ããŒã¿ãŒ â ãªã³ã©ã€ã³ã§ããŒãã«ã JSON ã«å€æããŸã
ãã©ãŠã¶ã§ CSVãTSVããã€ãåºåãããŒãã«ããŸã㯠Markdown ããŒãã«ã JSONãJSONLããŸã㯠SQL INSERT ã¹ããŒãã¡ã³ãã«å€æããŸãã
ããŒãã«ã貌ãä»ããããCSV ãããããããŸã - å察åŽãã JSONãJSONLããŸã㯠SQL ãååŸããŸã
ãŸã㯠.csv / .tsv ãã¡ã€ã«ããããã
ããŒãã«ãã JSON ãž ã§ã§ããããš
å§ããåã«ãäž»ãªæ©èœã確èªããŠãã ããã
- CSV ãŸã㯠TSV ããŒãã«ã JSON ã«å€æãã
- ã¹ãã¬ããã·ãŒã ããŒã¿ã SQL INSERT ã¹ããŒãã¡ã³ãã«å€æãã
- ããŒã¿ ãã€ãã©ã€ã³çšã«è¡ã JSONL ãšããŠãšã¯ã¹ããŒããã
- Markdown ããŒãã«ãŸãã¯ãã€ã ããŒãã«ã貌ãä»ããŠå€æãã
- æåã®è¡ããã£ãŒã«ãåãšããŠäœ¿çšãã
- ã«ã³ããã»ãã³ãã³ããŸãã¯ãã€ãåºåãæåãåŠçããŸã
èšå®ãªãã¡ã¬ã³ã¹
4 èšå®
ããŒãã«ãã JSON ãž ã§äœ¿çšå¯èœãªã³ã³ãããŒã«ã
èšå®
- åºåãæåããããããŠã³
- 貌ãä»ãã衚ã®åã®åºåãæ¹ãéžã³ãŸã â ã«ã³ããã¿ããã»ãã³ãã³ããã€ããMarkdown ã®ãã€ãèšæ³ããéžã¹ãã»ãããèªåæ€åºãã®ãŸãŸã«ããã°æåã®è¡ããåºåãæåãèªåã§å€å¥ããŸãããªãã·ã§ã³: èªåæ€åºCSVïŒã«ã³ãåºåãïŒTSVïŒã¿ãåºåãïŒã»ãã³ãã³ãã€ãMarkdownã®è¡š
- åºåããããããŠã³
- 倿åŸã®åœ¢åŒãéžã³ãŸããååãããŒã«ããJSONãªããžã§ã¯ããäœçœ®ã§äžŠã¹ãJSONé åã1è¡1ã¬ã³ãŒãã®JSONLããã®ãŸãŸå®è¡ã§ããSQLã®INSERTæããéžã¹ãŸãããªãã·ã§ã³: JSONïŒãªããžã§ã¯ãïŒJSON (é å)JSONLSQL INSERT
- æåã®è¡ãããããŒã«ãããªã³/ãªã
- ãªã³ã«ãããšã1è¡ç®ãJSONã®ããŒãSQLã®ååãšããŠäœ¿ãããŸãããªãã«ãããšãSQLã®ååã¯col_1ãcol_2ã®ããã«èªåã§ä»ããããJSONã¯å€ãé çªã«äžŠã¹ãé åãšããŠåºåãããŸãã
- ããŒãã«ããã¹ãå ¥å
- çæãããSQL INSERTæã§äœ¿ãããŒãã«åãèšå®ããŸãïŒåæå€ã¯my_tableïŒãåºå圢åŒãSQL INSERTã®ãšãã ã衚瀺ããã䜿çšã§ããªãæåã¯èªåçã«ã¢ã³ããŒã¹ã³ã¢ã«çœ®ãæããããŸãã
ããŒãã«ãã JSON ãž ã®é¢é£ããŒã«
ããŒãã«ãã JSON ãž ã®åŸã®äžè¬çãªæ¬¡ã®ã¹ãããã®ããã®ããŒã«ã
éçºè ããŒã«
JSONæŽåœ¢
JSON ãæ€èšŒãã2ã4ããŸã㯠8 åã®ã¹ããŒã¹ã§ãã©ãŒããããããããã©ãŠã¶ã§çž®å°ããŸãã
ä»ãã詊ãOCR ãšããŒã¿æœåº
ç»åããCSV
ã¹ã¯ãªãŒã³ã·ã§ãããŸãã¯åçããããŒãã«ãæœåºããèªèãããè¡ãšåã CSV ãšããŠããŠã³ããŒãããŸãã
ä»ãã詊ãOCR ãšããŒã¿æœåº
ç»åããExcel
åçãŸãã¯ã¹ã¯ãªãŒã³ã·ã§ããããããŒãã«ãæœåºããè¡ãšåãä¿æãããç·šéå¯èœãª .xlsx ãããŠã³ããŒãããŸãã
ä»ãã詊ããããã質å
ããŒãã«ãã JSON ãžã§ã§ããããš
ããžãã¹ãã¯ãªãšã€ã¿ãŒãæ¥åžžæ¥åãªã©ãå®éã®åé¡ãæ¯æ¥è§£æ±ºããŸããèªåã«åã£ããŠãŒã¹ã±ãŒã¹ãèŠã€ããŠå§ããŸãããã
CSVããAPIãžã®ç§»è¡
ããŒãããŒããã®ã¬ã¬ã·ãŒ CSV ãšã¯ã¹ããŒãããããããã JSON ãæåŸ ããææ°ã® REST API ã« POST ããå¿ èŠããããŸãã倿ããŠãã§ããããã£ã«ã³ããŒãã圢ç¶ãæ€èšŒããŸããã°ã«ãŒã¹ã¯ãªããã¯å¿ èŠãããŸããã
ããŒã¿ããŒã¹ã®ã·ãŒãã£ã³ã°
ãã¹ãããŒã¿ã®CSVããããã®ãŸãŸå®è¡ã§ããSQLã®INSERTæãçæããŸãããã€ã°ã¬ãŒã·ã§ã³ãã¡ã€ã«ãpsqlã·ã§ã«ã«ãã®ãŸãŸè²Œãä»ããããŸããåºåã¯æååãæ°å€ãnullãçåœå€ãæ£ããåŠçããŸãã
BigQuery / Snowflake ãžã®ããŒã¿åã蟌ã¿
ã¯ã©ãŠãããŒã¿ãŠã§ã¢ããŠã¹ã¯ãCSVãããJSONLã®æ¹ãé«éã«åã蟌ããŸããã¹ãã¬ããã·ãŒããJSONLã«å€æããŠãBigQueryãSnowflakeãRedshiftã®ã¹ããŒãžã³ã°ã«çŽæ¥ã¢ããããŒãããŸãããã
Markdownããã¥ã¡ã³ãã®è¡š
Markdownããã¥ã¡ã³ããã貌ãä»ããå 容ããããã°ã©ã ã§åŠçã§ããJSONã«å€æããŸãã人ãèªããMarkdownã®è¡šãããFAQé ç®ãããã²ãŒã·ã§ã³ã®ãšã³ããªãæéãã©ã³ã®ããŒã¿ãçæã§ããŸãã
ãã©ãŒã éä¿¡ã®åæ
Google FormsãTypeformã®åçãCSVã§æžãåºããŠJSONã«å€æããåæã«æŽ»çšãããAPIçµç±ã§CRMã«åã蟌ãã ãã§ããŸããããããŒè¡ããã®ãŸãŸãã£ãŒã«ãåã«ãªããŸãã
éçãµã€ãã®ããŒã¿çæ
衚ããŒã¿ãNext.jsã®getStaticPropsãAstroã®ã³ã³ãã³ãã³ã¬ã¯ã·ã§ã³ãHugoã®ããŒã¿ãã¡ã€ã«ã«åã蟌ããŸããJSONLã¯ã1è¡ã1ããŒãžã«å¯Ÿå¿ãããã³ã³ãã³ãã³ã¬ã¯ã·ã§ã³ã«ãšãã«äŸ¿å©ã§ãã
QAãã¹ããã£ã¯ã¹ãã£ã®çæ
ãã¹ãã·ããªãªã®ã¹ãã¬ããã·ãŒãã貌ãä»ããJSONãã£ã¯ã¹ãã£ãJSONLãšããŠJestã»Pytestã»Playwrightã®ãã¹ãã¹ã€ãŒããžçŽæ¥æžãåºãã°ãææžãã®ã¢ãã¯ããŒã¿ãã¡ã€ã«ãäžåæžããã«æžã¿ãŸãã
ãµãã©ã€ã€ãŒã«ã¿ãã°ã®äžæ¬ã€ã³ããŒã
ãµãã©ã€ã€ãŒã®äŸ¡æ Œè¡š CSV ããååããŒãã«çšã® SQL INSERT æããShopify/WooCommerce ã®äžæ¬ã€ã³ããŒãã¢ããªçšã® JSON ã«å€æããŸããããŒãã«åãã£ãŒã«ãã䜿ã£ãŠãã¹ãã¢ãæ³å®ããæ£ç¢ºãªããŒãã«ãæå®ã§ããŸãã
ããŒã³ãŒãã®Zapierã»Airtableåæ
ãšã¯ã¹ããŒãããã¹ãã¬ããã·ãŒããã倿ã¹ã¯ãªãããæžãããšãªããZapierã®ãŠã§ãããã¯ãAirtableã®èªååãMake.comã®ã·ããªãªãæ±ããJSONé åãŸãã¯ãªããžã§ã¯ãã®åœ¢åŒã«å€ããŸãã
éè¡ååŒæçŽ°ã®ç §å
ãšã¯ã¹ããŒãããéè¡ãã«ãŒãã®æçŽ° CSV ããå人åãå®¶èšããã·ã¥ããŒãçšã® JSON ã«ããããã¯ååŒãå åž³ããŒã¿ããŒã¹ã«çŽæ¥èªã¿èŸŒãããã® SQL INSERT æã«å€æããŸãã
éçãµã€ãã®ããŒã¿ãã¡ã€ã«çæ
ããŒã ã®ãããã£ãŒã«ãæéãã©ã³ãååäžèЧã®ã¹ãã¬ããã·ãŒãããHugoãJekyllãAstroãEleventy ã®ãã³ãã¬ãŒããçŽæ¥ã«ãŒãåŠçã§ãã JSON ããŒã¿ãã¡ã€ã«ã«å€æããŸããJAMstack ã®ãã«ãã§éåžžå¿ èŠãšãªãææžãã® data/*.json ãã¡ã€ã«ãçããŸãã
ãã®ããŒã«ã®ã¬ã€ã
å€æçµæãäžã€ãã€ç¢ºèª
ãã¹ãŠã®åçã¯ã¹ã©ãã·ã¥ããã®ãŸãŸééããå察åŽã宿ããŠåºãŠããŸãã


























