Skip to main content
Monitoring integrations

Export events, entities and jobs

Download any Events, Entities or Jobs search as a file, and pick up large exports from the Exports page.

You can export the results of any search on the Events, Entities or Jobs page as a file. Exports under 10,000 rows download straight away; larger ones run in the background, and HighCohesion (HC) emails you when the file is ready.

When to use this

Use this when you need a copy of your integration data outside the Control Panel, for example to check a day's orders against your own system or to share a list of failed events with your team.

Before you start

  • An export contains exactly what your search shows, so set your filters first.

  • Exports of 10,000 rows or more run in the background. Only one background export of each type (events, entities or jobs) can run per organisation at a time.

  • Every export is listed on the Exports page for 7 days, then it expires.

Steps

The steps below use the Entities page. Events and Jobs work the same way.

  1. In the left menu, under Reporting, click Entities.

  2. Click the filter icon at the top right of the list and set the filters you need, for example data type and created date.

  3. Click the checkbox menu at the top left of the list and choose Select all. Select this page only exports the rows on the current page.

  4. Open Actions and choose the export action.

  5. In the left menu, click Export.

Picking up a large export

For 10,000 rows or more, the Control Panel shows a message that the export is queued and that you will be emailed when the file is ready.

  1. Wait for the email from noreply@highcohesion.com and click its link, or go to Exports under Reporting.

  2. Open your export from the list. Its Status moves from Queued to Completed, and Progress shows how many rows have been written.

  3. When the status is Completed, click Download.

What you should see

  • A compressed CSV file (.csv.gz). Uncompress it before opening it in Excel or Google Sheets.

  • An events export includes the event ID, job ID and destination IDs for each event. All timestamps are in UTC.

  • A jobs export has 12 columns: Job ID, Stream, Status, Message, Is Rerun?, Original Job ID, Resend / Rerun Request ID, Due At, Started At, Finished At, Created At and Updated At.

  • A new row on the Exports page showing who requested the export, what it covered, its status, progress, file size and expiry date.

If it did not work

Nothing downloaded after you clicked Export. Your search probably has 10,000 rows or more, so the export is running in the background. Check the Exports page, or wait for the email.

The export stays Queued. Only one background export of each type can run per organisation at a time. Check the Exports page for another export of the same type that is still running.

The file will not open in Excel. The file is compressed. Uncompress the .csv.gz file with your computer's archive tool first, then open the CSV inside it.

The export is no longer on the Exports page. Exports expire after 7 days. Run the export again.

If none of these help, contact HC through How to get support.

Related

Was this helpful?

Still need help? Ask the team