Parse CSV transform action
Use case
You have received a return with a string in CSV format and you would like to convert this to a list of JSON objects.
Overview

Parse CSV Data into JSON. The first line will be keys, and subsequent lines will be values.
Parameters
Parameter
Description
Required
Delimiter
Character or sequence of characters to used as a delimiter in the CSV (default is ), such as '|';':', etc.
String Contents
Input the CSV formatted string you would like to convert to JSON.
Usage
Results output
Result of Example:
[
{
"EAN": "2091465262179",
"Name": "Compact Printer Air Advanced Digital",
"Size": "Large",
"Brand": "Garner, Boyle and Flynn",
"Color": "ForestGreen",
"Index": "1",
"Price": "265",
"Stock": "774",
"Category": "Books & Stationery",
"Currency": "USD",
"Description": "Situation organization these memory much off.",
"Internal ID": "56",
"Availability": "pre_order"
},
{
"EAN": "5286196620740",
"Name": "Tablet",
"Size": "8x10 in",
"Brand": "Mueller Inc",
"Color": "Black",
"Index": "2",
"Price": "502",
"Stock": "81",
"Category": "Shoes & Footwear",
"Currency": "USD",
"Description": "Discussion loss politics free one thousand.",
"Internal ID": "29",
"Availability": "in_stock"
},
{
"EAN": "1282898648918",
"Name": "Smart Blender Cooker",
"Size": "XS",
"Brand": "Lawson, Keller and Winters",
"Color": "SlateGray",
"Index": "3",
"Price": "227",
"Stock": "726",
"Category": "Kitchen Appliances",
"Currency": "USD",
"Description": "No situation per.",
"Internal ID": "70",
"Availability": "in_stock"
},
{
"EAN": "3879177514583",
"Name": "Advanced Router Rechargeable",
"Size": "L",
"Brand": "Gallagher and Sons",
"Color": "PaleGreen",
"Index": "4",
"Price": "121",
"Stock": "896",
"Category": "Kitchen Appliances",
"Currency": "USD",
"Description": "For force gas energy six laugh.",
"Internal ID": "31",
"Availability": "discontinued"
},
{
"EAN": "9055773261265",
"Name": "Portable Mouse Monitor Phone",
"Size": "100x200 mm",
"Brand": "Irwin LLC",
"Color": "SeaShell",
"Index": "5",
"Price": "1",
"Stock": "925",
"Category": "Kids' Clothing",
"Currency": "USD",
"Description": "Feeling back religious however author room scientist.",
"Internal ID": "10",
"Availability": "discontinued"
},
{
"EAN": "1150028980156",
"Name": "Radio",
"Size": "30x40 cm",
"Brand": "Benjamin, Nelson and Hancock",
"Color": "CornflowerBlue",
"Index": "6",
"Price": "426",
"Stock": "549",
"Category": "Skincare",
"Currency": "USD",
"Description": "Character prove growth contain serious customer.",
"Internal ID": "60",
"Availability": "pre_order"
},
{
"EAN": "5029747624534",
"Name": "Ultra Projector Oven Thermostat Prime Advanced",
"Size": "S",
"Brand": "Mccoy, Waters and Rose",
"Color": "Purple",
"Index": "7",
"Price": "68",
"Stock": "870",
"Category": "Laptops & Computers",
"Currency": "USD",
"Description": "Pattern possible look necessary indicate work nearly.",
"Internal ID": "86",
"Availability": "discontinued"
},
{
"EAN": "9883725074294",
"Name": "Webcam Stove Grill",
"Size": "8x10 in",
"Brand": "Morrow and Sons",
"Color": "MediumOrchid",
"Index": "8",
"Price": "159",
"Stock": "584",
"Category": "Automotive",
"Currency": "USD",
"Description": "Deep area join carry age.",
"Internal ID": "50",
"Availability": "pre_order"
},
{
"EAN": "1773215338624",
"Name": "Eco Radio",
"Size": "Medium",
"Brand": "Edwards, Odonnell and Conley",
"Color": "DimGray",
"Index": "9",
"Price": "454",
"Stock": "499",
"Category": "Skincare",
"Currency": "USD",
"Description": "Know father for act let.",
"Internal ID": "88",
"Availability": "pre_order"
}
]
Last updated
Was this helpful?