View as Markdown
Mixpanel (Service Account) icon

Mixpanel (Service Account) ACTION

Query Profiles

Look up user profiles and their stored properties. Results are paginated: when the number of results equals page_size, call again with the returned session_id and the next page number. See the documentation
  • Action
  • Read only
  • API key
  • SDK
  • MCP

IMPLEMENTATION

Call this tool

Connect a user's Mixpanel (Service Account) account once, then configure and run Query Profiles from your backend or agent.

import { PipedreamClient } from "@pipedream/sdk"

const pd = new PipedreamClient({
  projectId: process.env.PIPEDREAM_PROJECT_ID!,
  clientId: process.env.PIPEDREAM_CLIENT_ID!,
  clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
  projectEnvironment: "production",
})

const result = await pd.actions.run({
  id: "mixpanel_service_account-query-profiles",
  externalUserId: "{external_user_id}", // any stable ID for this user in your system
  configuredProps: {
    mixpanel_service_account: { authProvisionId: "apn_xxxxxxx" },
    distinctId: "Distinct ID",
    distinctIds: ["Distinct IDs"],
  },
})

console.log(result)

SCHEMA

Inputs

Pipedream supplies the connected account. Your application provides the operation-specific values below. Dynamic inputs are resolved against that user's account.

Query Profiles inputs
Property Type Description
distinctId Distinct ID string
A single distinct_id to fetch the profile for, for example user_1234. Set only one of Distinct ID, Distinct IDs, or Where.
Optional
distinctIds Distinct IDs string[]
Several distinct_id values to fetch profiles for in one call, for example ["user_1234", "user_5678"]. Set only one of Distinct ID, Distinct IDs, or Where.
Optional
where Where string
A segmentation expression that selects which profiles to return. Profile properties are addressed as user["..."], for example user["$email"] == "jane@example.com" or user["$city"] == "Austin". See the expression syntax
Optional
filterByCohortId Cohort ID integer
Return only the profiles in this saved cohort, for example 12345. Use List Saved Cohorts to find the ID.
Optional
includeAllUsers Include All Users boolean
Only applies when Cohort ID is set. When true (the default), every distinct_id in the cohort is returned even if it has no profile. Set to false to return only users that have a profile.
Optional
outputProperties Output Properties string[]
The profile property names to return, for example $email and $last_seen. Leave empty to return every property. Restricting this can speed up large queries considerably.
Optional
dataGroupId Data Group ID string
Set this to query group profiles (companies, workspaces) instead of user profiles. The value is the numeric ID of a group key, for example 1234567890, not the group key's name. See the documentation
Optional
sessionId Session ID string
The session_id value returned by a previous call, for example 1234567890-EXAMPL. Required whenever Page is greater than 0, and speeds up paging through a large result set.
Optional
page Page integer
Which page of results to return. Pages start at 0. Any value above 0 also requires Session ID.
Optional
workspaceId Workspace ID integer
The ID of the Data View to query. Only needed for projects that use Data Views; leave it empty otherwise. It is the segment after /view/ in a project URL such as https://mixpanel.com/project/1234/view/5678/app/boards.
Optional

REFERENCE

Tool details

Behavior hints are published with the component in the Pipedream registry and surface as MCP tool annotations, so an agent can reason about a tool before it calls it.

Registry key
mixpanel_service_account-query-profiles
Version
0.0.1
App
Mixpanel (Service Account)
Authentication
API key
Read-only
Yes
Destructive
No
Open world
Yes