Transform Grouped List to a Flat List

1 min

converts a single level nested list into a flat list on conversion it only retains the values of the keys mentioned in the "group fields" and "list fields" api definition { "tab" "examples", "url" "https //orca pathfix com/functions/list/grouptolist", "name" "transform grouped list api", "method" "post", "request" { "pathparameters" \[], "queryparameters" \[], "headerparameters" \[], "bodydataparameters" \[], "formdataparameters" \[] }, "results" { "languages" \[ { "id" "28usdqyeh3qrdmtvamsqt", "code" "{\n\t\\"output\\" \[{\n\t\t\t\\"name\\" \\"gates\\",\n\t\t\t\\"city\\" \\"long island city\\",\n\t\t\t\\"state\\" \\"new york\\"\n\t\t},\n\t\t{\n\t\t\t\\"name\\" \\"micheal\\",\n\t\t\t\\"city\\" \\"lehigh acres\\",\n\t\t\t\\"state\\" \\"florida\\"\n\t\t}\n\t]\n}", "language" "200" }, { "id" "yix64dyiudpjgbrfsfawb", "code" "{\n \\"message\\" \\"error\\"\n}", "language" "404" } ], "selectedlanguageid" "28usdqyeh3qrdmtvamsqt" }, "examples" { "languages" \[ { "id" "encjz9tstg38f0x taa4x", "code" "{\r\n\t\\"input\\" \[{\r\n\t\t\t\\"name\\" \\"gates\\",\r\n\t\t\t\\"address\\" {\r\n\t\t\t\t\\"street\\" \\"2037 geraldine lane\\",\r\n\t\t\t\t\\"city\\" \\"long island city\\",\r\n\t\t\t\t\\"state\\" \\"new york\\"\r\n\t\t\t}\r\n\t\t},\r\n\t\t{\r\n\t\t\t\\"name\\" \\"micheal\\",\r\n\t\t\t\\"address\\" {\r\n\t\t\t\t\\"street\\" \\"4212 sunburst drive\\",\r\n\t\t\t\t\\"city\\" \\"lehigh acres\\",\r\n\t\t\t\t\\"state\\" \\"florida\\"\r\n\t\t\t}\r\n\t\t}\r\n\t],\r\n\t\\"input list\\" \\"address\\",\r\n\t\\"group fields\\" \\"name\\",\r\n\t\\"list fields\\" \\"city,state\\"\r\n}", "language" "json" } ], "selectedlanguageid" "encjz9tstg38f0x taa4x" }, "description" "\ncall the following api ", "currentnewparameter" { "label" "body parameter", "value" "bodydataparameters" } }