How can I export my Email Alarm list?

Your Email Alarm List (including all technical data and Email Addresses (under the field/column "ExtraValue") can be downloaded as JSON using the the API URL

USA Region

https://us.sureviewops.com/api/Responses/GetResponses?page=1&pageSize=1000&isEmailAlarms=true

EU Region

https://eu.sureviewops.com/api/Responses/GetResponses?page=1&pageSize=1000&isEmailAlarms=true

Important Note: This export includes a lot of technical data, most of which can be safely ignored (or deleted after exporting and converting).  The important fields / columns for basic email alarms are:

To make this easier to work with, you can convert the JSON data into a CSV spreadsheet using jsongrid.com by following the steps below:

1. Login to your SureView Response account
   
   
2. If your account is in the US region go to: https://us.sureviewops.com/api/Responses/GetResponses?page=1&pageSize=1000&isEmailAlarms=true
   
   your account is in the EU region go to: https://eu.sureviewops.com/api/Responses/GetResponses?page=1&pageSize=1000&isEmailAlarms=true
   
3. Copy the results - in Chrome - select all with CTRL+A and press Ctrl+C to copy
   
   
   
4. Go to https://jsongrid.com/json-grid and paste your results
   
5. Press the Arrow to convert to a Grid
   
   
   
6. Expand your data
   
   
   
7. Click the table menu button then click "Export to CSV"
   
8. Your email alarm points will now download as a CSV which you can open in your preferred spreadsheet software (Excel, Google Sheets etc)
   
   
9. Open the spreadsheet in Excel (or other spreadsheet software) and delete unnecessary columns to make it easier to work with. For basic Email Alarms we recommend that you delete all columns except the following:
   

   groupTitle	The name of the Area/Site that the alarm point is associated with
   scriptTitle	The name of the Action Plan (if any) the alarm point is associated with
   responseID	The unique database identifier of the alarm point - this allows you to sort the results to order it by the alarm point creation order (e.g. so you can quickly find the email addresses of your most recent alarm points)
   title	The name of the Alarm Point
   priority	The Priority of the alarm point
   autoHandle	If the alarm point is set to be "Auto Handled" or not
   extraValue	The Email Address of the Alarm Point

Tips & Tricks

How to sort by newest added alarms

In order to view the newest added alarms, you will need to modify the entries for your spreadsheet to display the entries ordered by the most recently added alarms (sorted by highest ResponseID). In order to help make this easier to read, you may remove all of the columns from the export, leaving only the "GroupTitle", "ResponseID", "Title" and "ExtraValue" columns.

With the newly displayed information, selecting the ResponseID column, clicking sort and setting this to sort alphabetically from Z-A will show the most recent entries in the database, to the oldest. Below is an example screenshot of how this can be done in Google Sheets.