Created on 27 April 2021
icon_unfollowing
Login to follow
csv-to-json

CSV to JSON

Stable version 1.0.1 (Compatible with OutSystems 11)
Uploaded on 30 April 2021 by 
csv-to-json

CSV to JSON

Details
Easy CSV to JSON converter. Based on Cinchoo/ChoETL
Read more

Library that allow to convert CSV text to JSON format.

Based on Cinchoo/ChoETL.

Turn

FirstName,LastName,Street,City,State,Zip
John,Doe,120 jefferson st.,Riverside, NJ, 08075
Jack,McGinnis,220 hobo Av.,Phila, PA,09119
"John ""Da Man""",Repici,120 Jefferson St.,Riverside, NJ,08075
Stephen,Tyler,"7452 Terrace ""At the Plaza"" road",SomeTown,SD, 91234
,Blankman,,SomeTown, SD, 00298
"Joan ""the bone"", Anne",Jet,"9th, at Terrace plc",Desert City,CO,00123

Into

[
  {
    "FirstName": "John",
    "LastName": "Doe",
    "Street": "120 jefferson st.",
    "City": "Riverside",
    "State": "NJ",
    "Zip": "08075"
  },
  {
    "FirstName": "Jack",
    "LastName": "McGinnis",
    "Street": "220 hobo Av.",
    "City": "Phila",
    "State": "PA",
    "Zip": "09119"
  },
  {
    "FirstName": "John \\\"Da Man\\\"",
    "LastName": "Repici",
    "Street": "120 Jefferson St.",
    "City": "Riverside",
    "State": "NJ",
    "Zip": "08075"
  },
  {
    "FirstName": "Stephen",
    "LastName": "Tyler",
    "Street": "7452 Terrace \\\"At the Plaza\\\" road",
    "City": "SomeTown",
    "State": "SD",
    "Zip": "91234"
  },
  {
    "LastName": "Blankman",
    "City": "SomeTown",
    "State": "SD",
    "Zip": "00298"
  },
  {
    "FirstName": "Joan \\\"the bone\\\", Anne",
    "LastName": "Jet",
    "Street": "9th, at Terrace plc",
    "City": "Desert City",
    "State": "CO",
    "Zip": "00123"
  }
]
Release notes (1.0.1)
  • Now ignores empty header columns
Reviews (1)
by 
2023-11-20
in version 1.0.1
This makes working with CSV so much easier!

FYI: My use case: get data from InfluxDB via REST API (which only returns application/csv) and deserialize it into a list of my own structure. Working with JSON is so much easier in OutSystems compared to CSV!
Category
Functional libraries & utilities, Other functions & libraries
Support options
This asset is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from  who created this asset.
Dependencies
CSV to JSON has no dependencies.
Application Objects
CSV to JSON has 0 AOs.
Team
Compatible with
Version 11
Database:
All
Asset consumers
No consumers yet.
Weekly downloads