How can I export my Email Alarm list?

Have more questions? Submit a request

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:

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

 

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 Firefox click "Copy"
      2023-08-09 09_51_32-Mozilla Firefox.png

      in Chrome - select all with CTRL+A and press Ctrl+C to copy
      2023-08-09 09_52_33-us.sureviewops.com_api_Responses_GetResponses_page=1&pageSize=999&isEmailAlarms=.png

    4. Go to https://jsongrid.com/json-grid and paste your results
      2023-08-09 09_59_02-Json Grid Viewer Online - All-in-One Solution — Mozilla Firefox.png
    5. Press the Arrow to convert to a Grid
      2023-08-09 10_00_56-Json Grid Viewer Online - All-in-One Solution — Mozilla Firefox.png

    6. Expand your data
      2023-08-09 10_01_49-Json Grid Viewer Online - All-in-One Solution — Mozilla Firefox.png

    7. Click the table menu button table_menu.PNG then click "Export to CSV"
      2023-08-09 10_02_36-Json Grid Viewer Online - All-in-One Solution — Mozilla Firefox.png
    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.


1. Right click column header, 2. Select Sort Z-A

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.