Pricing

from $1.00 / 1,000 input row processeds

Try for free

Go to Apify Store

Dataset Aggregate, Group By & Pivot

Try for free

Returns GROUP BY and pivot tables for any Apify dataset or JSON array: count, sum, average, min, max, median per group, date buckets, plus CSV or Excel export. Inputs: dataset ID or inline data, group-by fields, aggregations. Agent-ready: pay per event (x402 and MCP), per input row and file.

Pricing

from $1.00 / 1,000 input row processeds

Rating

0.0

(0)

Developer

Adam Pearce

Actor stats

Bookmarked

Total users

Monthly active users

12 hours ago

Last modified

Categories

Developer tools

Automation

Agents

You can access the Dataset Aggregate, Group By & Pivot programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

# Set API token
$API_TOKEN=<YOUR_API_TOKEN>

# Prepare Actor input
$cat > input.json << 'EOF'
<{
<  "data": [
<    {
<      "orderId": 1001,
<      "region": "North",
<      "product": "Widget",
<      "amount": "$1,200.00",
<      "orderedAt": "2026-07-03"
<    },
<    {
<      "orderId": 1002,
<      "region": "North",
<      "product": "Gadget",
<      "amount": 350,
<      "orderedAt": "2026-07-18"
<    },
<    {
<      "orderId": 1003,
<      "region": "South",
<      "product": "Widget",
<      "amount": "890.50",
<      "orderedAt": "2026-07-22"
<    },
<    {
<      "orderId": 1004,
<      "region": "south",
<      "product": "Gizmo",
<      "amount": 120,
<      "orderedAt": "2026-08-02"
<    },
<    {
<      "orderId": 1005,
<      "region": "East",
<      "product": "Widget",
<      "amount": 2400,
<      "orderedAt": "2026-08-05"
<    },
<    {
<      "orderId": 1006,
<      "region": "East",
<      "product": "Gadget",
<      "amount": "n/a",
<      "orderedAt": "2026-08-09"
<    },
<    {
<      "orderId": 1007,
<      "region": "North",
<      "product": "Gizmo",
<      "amount": 75,
<      "orderedAt": "2026-08-11"
<    },
<    {
<      "orderId": 1008,
<      "region": "",
<      "product": "Widget",
<      "amount": 410,
<      "orderedAt": "2026-08-14"
<    }
<  ],
<  "groupByFields": [
<    "region"
<  ],
<  "aggregations": [
<    {
<      "function": "count",
<      "alias": "orders"
<    },
<    {
<      "field": "amount",
<      "function": "sum",
<      "alias": "total_amount"
<    },
<    {
<      "field": "amount",
<      "function": "avg",
<      "alias": "avg_amount"
<    }
<  ],
<  "exportFormats": [
<    "csv",
<    "xlsx"
<  ]
<}
<EOF

# Run the Actor using an HTTP API
# See the full API reference at https://docs.apify.com/api/v2
$curl "https://api.apify.com/v2/actors/nerolabs~dataset-aggregate-pivot/runs?token=$API_TOKEN" \
<  -X POST \
<  -d @input.json \
<  -H 'Content-Type: application/json'

Dataset Aggregate, Group By & Pivot - SQL GROUP BY on Apify API

Below, you can find a list of relevant HTTP API endpoints for calling the Dataset Aggregate, Group By & Pivot Actor. For this, you’ll need an Apify account. Replace <YOUR_API_TOKEN> in the URLs with your Apify API token, which you can find under API & Integrations in Apify Console. For details, see the API reference.

Run Actor

POST
https://api.apify.com/v2/actors/nerolabs~dataset-aggregate-pivot/runs?token=<YOUR_API_TOKEN>

Note: By adding the method=POST query parameter, this API endpoint can be called using a GET request and thus used in third-party webhooks. Please refer to our Run Actor API documentation.

Run Actor synchronously and get dataset items

POST
https://api.apify.com/v2/actors/nerolabs~dataset-aggregate-pivot/run-sync-get-dataset-items?token=<YOUR_API_TOKEN>

Note: This endpoint supports both POST and GET request methods. However, only the POST method allows you to pass input data. For more information, please refer to our Run Actor synchronously and get dataset items API documentation.

Get Actor

GET
https://api.apify.com/v2/actors/nerolabs~dataset-aggregate-pivot?token=<YOUR_API_TOKEN>

For more information, please refer to our Get Actor API documentation.

Actors can be used to scrape web pages, extract data, or automate browser tasks. Use the Dataset Aggregate, Group By & Pivot API programmatically via the Apify API.

You can choose from:

Dataset Aggregate, Group By & Pivot API in Python

Dataset Aggregate, Group By & Pivot API in JavaScript

Dataset Aggregate, Group By & Pivot API through CLI

Dataset Aggregate, Group By & Pivot OpenAPI definition

You can start Dataset Aggregate, Group By & Pivot with the Apify API by sending an HTTP POST request to the Run Actorendpoint. An Actor’s input and its content type can be passed as a payload of the POST request, and additional options can be specified using URL query parameters. The Dataset Aggregate, Group By & Pivot is identified within the API by its ID, which is the creator’s username and the name of the Actor.

When the Dataset Aggregate, Group By & Pivot run finishes you can list the data from its default dataset(storage) via the API or you can preview the data directly on Apify Console.

Dataset Cleaner & Exporter

nerolabs/dataset-cleaner-exporter

Returns a deduplicated, flattened and cleaned copy of any Apify dataset or JSON array, plus CSV and Excel files. Inputs: dataset ID or inline data, dedup mode and keys, flatten, email/phone/URL cleaning, export formats. Agent-ready: pay per event (x402 and MCP), per cleaned record and file.

Adam Pearce

Facebook Group Posts Scraper

khadinakbar/facebook-group-posts-scraper

Scrape public Facebook group posts by group URL or group ID. Export post text, author, reaction/comment/share counts, media URLs, top comments, and pagination cursors. No login or cookies required. MCP/API-ready.

Khadin Akbar

Facebook Groups Scraper

khadinakbar/facebook-groups-scraper

Scrape public Facebook group posts by group URL or group ID. Export post text, author, engagement counts, media URLs, top comments, and pagination cursors. MCP/API-ready.

Khadin Akbar

Facebook group member scraper

curious_coder/facebook-group-member-scraper

Scrape facebook group members of any group with all available information

Curious Coder

2.1K

2.5

Facebook Group Posts Scraper

powerai/facebook-group-posts-scraper

Search Facebook group posts by keywords—optional group and date filters—with authors, text, reactions, and media in structured rows.

PowerAI

163

Facebook Groups Scraper

api-ninja/facebook-groups-scraper

📘 Extract Facebook group posts, future events, and group details from one or more group URLs, handles, or IDs.

API ninja

218

5.0

Facebook Search Groups Results Scraper

memo23/facebook-search-groups-scraper

Scrape facebook groups from search results and get important details such as group name, description, is group public or private, group members count, activity and group URL.

Muhamed Didovic

229

1.0

Facebook Group Posts And Details Scraper

scrapio/facebook-group-posts-and-details-scraper

Extract Facebook Group content with precision. Capture posts, media, comments, reactions, authors, and activity insights across any public group. Perfect for analysts, marketers, and researchers building datasets for monitoring group behavior or engagement trends.

Scrapio

Dataset Diff & Change Detector

nerolabs/dataset-diff-detector

Returns what was added, removed or changed between two Apify datasets or JSON arrays, matched by key, field by field, with an optional CSV or Excel diff report. Inputs: old and new dataset IDs or inline data, key fields. Agent-ready: pay per event (x402 and MCP), per difference found and file.

Adam Pearce