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 setting description value field summarizes the value in this field user substitution curls group fields one or many fields that the value should be grouped by use substitution curls in the list of fields see example request input list of json objects 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" } }