This article provides access to a series of short explainer videos covering the Assure Data Extraction API (a secure RESTful API that allows organisations to automatically extract EHS data from Assure into external applications and business intelligence tools). The videos cover setting up the API in Assure, exporting data into Excel and PowerBI using the JSON Lines format, exporting hourly data, and extracting iQ (Intelligent Questionnaire) template data using field mapping. This article also includes guidance on the two methods available for exporting iQ data. The article is part of the wider Data Extraction API topic area within Assure.
Overview
Important: Customer-specific integration steps are not supported by the Evotix team. This step should be supported by your IT team. You will need to use the correct request URL to identify the dataset you need. To use these URLs, replace the placeholder with the Assure stack name you use to access the Assure Web UI. For example, if you access the Assure Web UI athttps://uk2.sheassure.net/, your stack name value isuk2.
Video Library
Video 2: Exporting Assure data into your own system - Excel Overview video on how to export data into Excel using the JSON lines format.
Video 3: Exporting Assure data into your own system - PowerBI: Overview video on how to export data into PowerBI using the JSON lines format.
Video 4: Exporting and using iQ Data
Video 5: Exporting Hourly Assure data into your own system - Excel
Video 6: Exporting Hourly Assure data into your own system - PowerBI
iQ Data Export Options
Option 1: Export the Complete iQ Dataset
/iq to the end of the URL for that module. For example: incident-event/iq. Option 2: Export Specific iQ Fields
Note: The Data Extract export code does not need to be set for data to be included in the complete iQ data export for each module. The export code is only required when selectively exporting specific iQ questions.
AI Metadata
- Product Area: Assure - Data Extraction API, System Integration, Customer API
- User Role: IT Administrator, Integration Engineer, Assure System Administrator, Business Intelligence Analyst
- Tags: Data Extraction API, overview videos, JSON Lines, CSV, Excel, PowerBI, hourly extract, daily extract, iQ data, IQ template, field mapping, Data Extract export code, RESTful API, ETL, Business Intelligence
- Version/Region: All Assure versions; all regions
- Important Synonyms:
- Data Extraction API = Customer API = Assure API = Data Extract API
- iQ = Intelligent Questionnaire = IQ Template
- JSON Lines = JSONLines = JSON
- Stack name = Assure stack name = instance identifier
- CDM = Customer Development Manager
- CSM = Customer Success Manager
- Suggested Embedding Keywords: Assure data extraction API video, how to set up data extraction Assure, export Assure data Excel, export Assure data PowerBI, JSON Lines Assure export, hourly data extract video Assure, iQ data extraction Assure, IQ template field mapping export, Data Extract export code Assure, Assure API tutorial video, Assure integration video guide
- Relevant Modules and Cross-Module Implications: This article is part of the Data Extraction API section and spans all Assure modules. The videos apply to any module enabled for data extraction, including Incident, Risk, Audit, Environment, Asset, People, Contractor, Project, and Core. iQ data extraction applies to any module that uses iQ (Intelligent Questionnaire) templates. The iQ data export options described in this article apply across all modules that contain iQ template questions.