Mixpanel Community Icon
Join Our Community
Community Questions

Issues with Backfilling Events in Mixpanel Using /import API

Avatar of DanDan
·
·

I'm attempting to backfill some events using the /import API today and I'm not sure what I'm doing wrong. I've called the API and receive a successful response: { code: 200, num_records_imported: 2, status: 'OK' } . When I look for my imported events in Mixpanel they are not there. Has anyone had this issue before? I thought maybe there is a delay before events can be seen in the UI but it's been more than 30 minutes. My imported data looks something like this 

[
  {
    event: 'Completed Session',
    properties: {
      distinct_id: '1c84b592-9b63-11ee-bc16-0a499a41197b',
      '$insert_id': 'b24510e0-1006-11f0-ae7c-02466f607f67',
      time: 1743631747,
      sessionId: 'b24510e0-1006-11f0-ae7c-02466f607f67'
    }
  },
  {
    event: 'Completed Session',
    properties: {
      distinct_id: '0bfc1cc2-651d-11ef-ae55-02466f607f67',
      '$insert_id': '3a9dcfb8-1002-11f0-a98d-02466f607f67',
      time: 1743626369,
      sessionId: '3a9dcfb8-1002-11f0-a98d-02466f607f67'
    }
  }
]

3 comments

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·

    I just finished a massive set of imports (>1mm records) and the only thing I can say is I found that sometimes, if they were older records, I had to click on the "show more" a bunch of times in the Events list (even though I had the time frame set to the past) bc the interface was trying to show more current records.

  • Avatar of Dan
    Dan
    ·
    ·

    Thanks for the tip! I thought this might be the case as well but I've filtered by a specific property on the event that I thought would bring it up (sessionid) and I'm getting nothing back.

  • Avatar of Thena
    Thena
    APP
    ·
    ·

    Hi Dan! Julianne from Mixpanel Support here. Echoing Andrew, it could be that you need to click 'Load More' on the Events page to see the older data. This is necessary even if querying for a specific property since the page loads 30 days at a time. If you see a 'Load More' button, that indicates the entire time period isn't being displayed. Inline Attachment: image.png If that's not the issue, the other thing you can check is to confirm the events were sent to the right project. If that also looks okay, I'd recommend submitting a ticket here about the issue. When you submit the ticket, it would be helpful if you included the full payload sent (auth info removed) along with a link to the project where you expect the events.