# 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
A screenshot of the parse csv transform action, seen in the actions list menu of the workflow builder canvas.
Parse CSV Data into JSON. The first line will be keys, and subsequent lines will be values. ## Parameters
ParameterDescriptionRequired
DelimiterCharacter or sequence of characters to used as a delimiter in the CSV (default is ), such as '|';':', etc.true
String ContentsInput the CSV formatted string you would like to convert to JSON.true
## Usage
Example: Convert CSV to JSON Inputs: **Delimiter:** , **String Contents:** ``` Index,Name,Description,Brand,Category,Price,Currency,Stock,EAN,Color,Size,Availability,Internal ID 1,Compact Printer Air Advanced Digital,Situation organization these memory much off.,"Garner, Boyle and Flynn",Books & Stationery,265,USD,774,2091465262179,ForestGreen,Large,pre_order,56 2,Tablet,Discussion loss politics free one thousand.,Mueller Inc,Shoes & Footwear,502,USD,81,5286196620740,Black,8x10 in,in_stock,29 3,Smart Blender Cooker,No situation per.,"Lawson, Keller and Winters",Kitchen Appliances,227,USD,726,1282898648918,SlateGray,XS,in_stock,70 4,Advanced Router Rechargeable,For force gas energy six laugh.,Gallagher and Sons,Kitchen Appliances,121,USD,896,3879177514583,PaleGreen,L,discontinued,31 5,Portable Mouse Monitor Phone,Feeling back religious however author room scientist.,Irwin LLC,Kids' Clothing,1,USD,925,9055773261265,SeaShell,100x200 mm,discontinued,10 6,Radio,Character prove growth contain serious customer.,"Benjamin, Nelson and Hancock",Skincare,426,USD,549,1150028980156,CornflowerBlue,30x40 cm,pre_order,60 7,Ultra Projector Oven Thermostat Prime Advanced,Pattern possible look necessary indicate work nearly.,"Mccoy, Waters and Rose",Laptops & Computers,68,USD,870,5029747624534,Purple,S,discontinued,86 8,Webcam Stove Grill,Deep area join carry age.,Morrow and Sons,Automotive,159,USD,584,9883725074294,MediumOrchid,8x10 in,pre_order,50 9,Eco Radio,Know father for act let.,"Edwards, Odonnell and Conley",Skincare,454,USD,499,1773215338624,DimGray,Medium,pre_order,88 ```
## Results output Result of Example: ```json [ { "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" } ] ``` --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.rewst.help/documentation/automations/actions-in-rewst/transform-actions/parse-csv-transform-action.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.