Summarize by Group

2 min

groups by a key and then sumarrized the values present in a given key in json objects within a list 124,614,99 true unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type api definition { "tab" "examples", "url" "https //orca pathfix com/functions/list/groupandsummarize", "name" "sum json objects api", "method" "post", "request" { "pathparameters" \[], "queryparameters" \[], "headerparameters" \[], "bodydataparameters" \[], "formdataparameters" \[] }, "results" { "languages" \[ { "id" "28usdqyeh3qrdmtvamsqt", "code" "{\n \\"output\\" \[\n {\n \\"source\\" \\"facebook\\",\n \\"sum\\" \\"6500\\",\n \\"count\\" \\"2\\",\n \\"avg\\" 3250 0\n },\n {\n \\"source\\" \\"linkedin\\",\n \\"sum\\" \\"3200\\",\n \\"count\\" \\"1\\",\n \\"avg\\" 3200 0\n }\n ],\n \\"size in bytes\\" 488 0\n}", "language" "200" }, { "id" "yix64dyiudpjgbrfsfawb", "code" "{\n \\"message\\" \\"error\\"\n}", "language" "404" } ], "selectedlanguageid" "28usdqyeh3qrdmtvamsqt" }, "examples" { "languages" \[ { "id" "encjz9tstg38f0x taa4x", "code" "{\r\n \\"input\\" \[\r\n {\r\n \\"email\\" \\"bruce\@pathfix com\\",\r\n \\"source\\" \\"facebook\\",\r\n \\"other\\" \\"test\\",\r\n\t\t\t\\"date\\" \\"2022 01 25\\",\r\n\t\t\t\\"lead value\\" \\"2000\\"\r\n },\r\n {\r\n \\"email\\" \\"paul\@pathfix com\\",\r\n \\"source\\" \\"facebook\\",\r\n\t\t\t\\"date\\" \\"2022 02 12\\",\r\n\t\t\t\\"lead value\\" \\"4500\\"\r\n },\r\n {\r\n \\"email\\" \\"chang\@pathfix com\\",\r\n \\"source\\" \\"linkedin\\",\r\n\t\t\t\\"date\\" \\"2022 02 15\\",\r\n\t\t\t\\"lead value\\" \\"3200\\"\r\n }\r\n ],\r\n\t\\"value field\\" \\"{{lead value}}\\",\r\n\t\\"group fields\\" \[\r\n\t\t\\"{{source}}\\"\r\n\t]\r\n}", "language" "json" } ], "selectedlanguageid" "encjz9tstg38f0x taa4x" }, "description" "\ncall the following api ", "currentnewparameter" { "label" "body parameter", "value" "bodydataparameters" } }