Gustavo S.

kapa.ai why is this event track using the php sdk failing? [ Base_MixpanelBase - line 196 ] : Queued message: {"$token":"0575d0615457cc818a156ccb1c0f1c27","$distinct_id":"2622","$time":1768915231.800992,"$set":{"$distinct_id":"2622"}} [ Base_MixpanelBase - line 196 ] : Queued message: {"event":"checkout","properties":{"mp_lib":"php","distinct_id":"2622","Type":"onetime","Booking":3618,"FirstTime":false,"CheckoutOrigin":"app","BookingFlow":"backend","BookingCreatedByAdmin":false,"time":1763508265,"Value":"148.57","token":"0575d0615457cc818a156ccb1c0f1c27"}} [ Base_MixpanelBase - line 113 ] : Flush called - queue size: 1 [ Base_MixpanelBase - line 114 ] : Making blocking cURL call to https://api.mixpanel.com/track [ ConsumerStrategies_CurlConsumer - line 152 ] : 0 [ Base_MixpanelBase - line 123 ] : Batch consumption failed! [ Base_MixpanelBase - line 128 ] : added batch back to queue, queue size is now 1 [ Base_MixpanelBase - line 135 ] : Batch of 1 consumed, queue size is now 1

kapa.ai I still want to use the export api, but filter by event property "Booking"

kapa.ai ok, how can I do that using JQL? on which api?

kapa.ai so I can only filter by event properties? What about the user linked to the event? How do I filter by that?

kapa.ai how do i filter by user id?

this code still doesn't work:

$projectId  = 3334207;
$fromDate   = '2025-12-28';
$toDate     = '2025-12-28';
$eventName  = 'checkout';
$distinctId = '4612';

$where = urlencode('properties["distinct_id"] == "3147"');

$response = $client->request('GET', 'https://data-eu.mixpanel.com/api/2.0/export', [
    'http_errors' => false, // IMPORTANT: lets you read the body on 400
    'auth' => [$username, $secret], // better than hardcoding a base64 header
    'headers' => [
        'accept' => 'text/plain',
    ],
    'query' => [
        'project_id' => $projectId,
        'from_date'  => $fromDate,
        'to_date'    => $toDate,
        'limit'      => 1,
        'event'      => json_encode([$eventName]),              // must be JSON array :contentReference[oaicite:1]{index=1}
        "where={$where}",
    ],
]);

echo "HTTP: " . $response->getStatusCode() . "\n";
echo (string) $response->getBody();