Convert From CSV

converts comma separated values into a list of json objects it is mandatory to have the first line of the csv as the header the field names are cleaned by replacing everything except text and number to " " api definition { "tab" "examples", "url" "https //orca pathfix com/functions/list/fromcsv", "name" "from csv to list api", "method" "post", "request" { "pathparameters" \[], "queryparameters" \[], "headerparameters" \[], "bodydataparameters" \[], "formdataparameters" \[] }, "results" { "languages" \[ { "id" "28usdqyeh3qrdmtvamsqt", "code" "{\n \\"output\\" \[\n {\n \\"index\\" \\"1\\",\n \\"description\\" \\"eldon base for stackable storage shelf, platinum\\",\n \\"mfg by\\" \\"muhammed macintyre\\",\n \\"stock\\" \\"3\\",\n \\"price1\\" \\" 213 25\\",\n \\"price2\\" \\"38 94\\",\n \\"price3\\" \\"35\\",\n \\"other\\" \\"nunavut\\",\n \\"category\\" \\"storage & organization\\",\n \\"rating\\" \\"0 8\\"\n },\n {\n \\"index\\" \\"2\\",\n \\"description\\" \\"1 7 cubic foot compact \\\\\\"cube\\\\\\" office refrigerators\\",\n \\"mfg by\\" \\"barry french\\",\n \\"stock\\" \\"293\\",\n \\"price1\\" \\"457 81\\",\n \\"price2\\" \\"208 16\\",\n \\"price3\\" \\"68 02\\",\n \\"other\\" \\"nunavut\\",\n \\"category\\" \\"appliances\\",\n \\"rating\\" \\"0 58\\"\n },\n {\n \\"index\\" \\"3\\",\n \\"description\\" \\"cardinal slant d® ring binder, heavy gauge vinyl\\",\n \\"mfg by\\" \\"barry french\\",\n \\"stock\\" \\"293\\",\n \\"price1\\" \\"46 71\\",\n \\"price2\\" \\"8 69\\",\n \\"price3\\" \\"2 99\\",\n \\"other\\" \\"nunavut\\",\n \\"category\\" \\"binders and binder accessories\\",\n \\"rating\\" \\"0 39\\"\n },\n {\n \\"index\\" \\"4\\",\n \\"description\\" \\"r380\\",\n \\"mfg by\\" \\"clay rozendal\\",\n \\"stock\\" \\"483\\",\n \\"price1\\" \\"1198 97\\",\n \\"price2\\" \\"195 99\\",\n \\"price3\\" \\"3 99\\",\n \\"other\\" \\"nunavut\\",\n \\"category\\" \\"telephones and communication\\",\n \\"rating\\" \\"0 58\\"\n },\n {\n \\"index\\" \\"5\\",\n \\"description\\" \\"holmes hepa air purifier\\",\n \\"mfg by\\" \\"carlos soltero\\",\n \\"stock\\" \\"515\\",\n \\"price1\\" \\"30 94\\",\n \\"price2\\" \\"21 78\\",\n \\"price3\\" \\"5 94\\",\n \\"other\\" \\"nunavut\\",\n \\"category\\" \\"appliances\\",\n \\"rating\\" \\"0 5\\"\n },\n {\n \\"index\\" \\"6\\",\n \\"description\\" \\"g e longer life indoor recessed floodlight bulbs\\",\n \\"mfg by\\" \\"carlos soltero\\",\n \\"stock\\" \\"515\\",\n \\"price1\\" \\"4 43\\",\n \\"price2\\" \\"6 64\\",\n \\"price3\\" \\"4 95\\",\n \\"other\\" \\"nunavut\\",\n \\"category\\" \\"office furnishings\\",\n \\"rating\\" \\"0 37\\"\n },\n {\n \\"index\\" \\"7\\",\n \\"description\\" \\"angle d binders with locking rings, label holders\\",\n \\"mfg by\\" \\"carl jackson\\",\n \\"stock\\" \\"613\\",\n \\"price1\\" \\" 54 04\\",\n \\"price2\\" \\"7 3\\",\n \\"price3\\" \\"7 72\\",\n \\"other\\" \\"nunavut\\",\n \\"category\\" \\"binders and binder accessories\\",\n \\"rating\\" \\"0 38\\"\n },\n {\n \\"index\\" \\"8\\",\n \\"description\\" \\"safco mobile desk side file, wire frame\\",\n \\"mfg by\\" \\"carl jackson\\",\n \\"stock\\" \\"613\\",\n \\"price1\\" \\"127 70\\",\n \\"price2\\" \\"42 76\\",\n \\"price3\\" \\"6 22\\",\n \\"other\\" \\"nunavut\\",\n \\"category\\" \\"storage & organization\\",\n \\"rating\\" \\"\\"\n },\n {\n \\"index\\" \\"9\\",\n \\"description\\" \\"safco commercial wire shelving, black\\",\n \\"mfg by\\" \\"monica federle\\",\n \\"stock\\" \\"643\\",\n \\"price1\\" \\" 695 26\\",\n \\"price2\\" \\"138 14\\",\n \\"price3\\" \\"35\\",\n \\"other\\" \\"nunavut\\",\n \\"category\\" \\"storage & organization\\",\n \\"rating\\" \\"\\"\n },\n {\n \\"index\\" \\"10\\",\n \\"description\\" \\"xerox 198\\",\n \\"mfg by\\" \\"dorothy badders\\",\n \\"stock\\" \\"678\\",\n \\"price1\\" \\" 226 36\\",\n \\"price2\\" \\"4 98\\",\n \\"price3\\" \\"8 33\\",\n \\"other\\" \\"nunavut\\",\n \\"category\\" \\"paper\\",\n \\"rating\\" \\"0 38\\"\n }\n ]\n}", "language" "200" }, { "id" "yix64dyiudpjgbrfsfawb", "code" "{\n \\"message\\" \\"error\\"\n}", "language" "404" } ], "selectedlanguageid" "28usdqyeh3qrdmtvamsqt" }, "examples" { "languages" \[ { "id" "encjz9tstg38f0x taa4x", "code" "{\r\n \\"input\\" \\"index,description,mfg by,stock,price1,price2,price3,other,category,rating\\\n1,\\\\\\"eldon base for stackable storage shelf, platinum\\\\\\",muhammed macintyre,3, 213 25,38 94,35,nunavut,storage & organization,0 8\\\n2,\\\\\\"1 7 cubic foot compact \\\\\\"\\\\\\"cube\\\\\\"\\\\\\" office refrigerators\\\\\\",barry french,293,457 81,208 16,68 02,nunavut,appliances,0 58\\\n3,\\\\\\"cardinal slant d® ring binder, heavy gauge vinyl\\\\\\",barry french,293,46 71,8 69,2 99,nunavut,binders and binder accessories,0 39\\\n4,r380,clay rozendal,483,1198 97,195 99,3 99,nunavut,telephones and communication,0 58\\\n5,holmes hepa air purifier,carlos soltero,515,30 94,21 78,5 94,nunavut,appliances,0 5\\\n6,g e longer life indoor recessed floodlight bulbs,carlos soltero,515,4 43,6 64,4 95,nunavut,office furnishings,0 37\\\n7,\\\\\\"angle d binders with locking rings, label holders\\\\\\",carl jackson,613, 54 04,7 3,7 72,nunavut,binders and binder accessories,0 38\\\n8,\\\\\\"safco mobile desk side file, wire frame\\\\\\",carl jackson,613,127 70,42 76,6 22,nunavut,storage & organization,\\\n9,\\\\\\"safco commercial wire shelving, black\\\\\\",monica federle,643, 695 26,138 14,35,nunavut,storage & organization,\\\n10,xerox 198,dorothy badders,678, 226 36,4 98,8 33,nunavut,paper,0 38\\"\r\n}", "language" "json" } ], "selectedlanguageid" "encjz9tstg38f0x taa4x" }, "description" "\ncall the following api ", "currentnewparameter" { "label" "body parameter", "value" "bodydataparameters" } }