I am attempting to use AWS AppFlow to transfer all events from Mixpanel to an S3 bucket and Glue Catalog. These are my params:
Flow name
Mixpanel_UDL_Flow004
Flow description
Transfer all events from Mixpanel to AWS
Source name
Mixpanel
Source object
/events?project_id=******
Source connection
Mixpanel_UDL
Select another connection
Source API version
2.0
Destination name
Amazon S3
Destination bucket
s3://bucket here
Status
Active
Trigger
On demand
But I'm getting an error: The request failed because the service Source Mixpanel returned the following error: Details: :Invalid parameter: unit, ErrorCode: InvalidArgument.
Now I designated the necessary filters for this from the following page:
https://docs.aws.amazon.com/appflow/latest/userguide/connectors-mixpanel.html#mixpanel-reference-objects
These are the necessary filter params: event* ; from_date* ; to_date* ; type* ; unit* . But I'm having trouble getting this to work or even finding a way to list all the events because there are a max of 10 filters that can be added and I have many more events than that to send to S3. Any help would be greatly appreciated and I will gladly provide more details upon request.
I'm confused what the unit parameter should be as well as the type parameter and cannot find any documentation to figure out what AWS is looking for in the filter design step of AppFlow
Successfully found page for these event filter types: https://developer.mixpanel.com/reference/list-recent-events
Necessary format for filters : event is exactly ["Document Viewed"] from_date is same July 11, 2024, 00:00:00 to_date is same July 12, 2024, 00:00:00 type is exactly general unit is exactly day
But I'm still only getting dates and not my Document Viewed information as intended, having a trouble mapping.