Getting Started

Suggest Edits

Overview

The SafetyChain PowerBI connector uses the record data extract (RDE) APIs to pull data into the PowerBI service to help in connecting SafetyChain data with other sources and create additional visualizations of the data.

The service uses the following endpoints:

  • getResources_Summary: Provides a summary of record count, pass count. pass percentage per each resource. This is calculated based on the date range provided to the application.
  • getLocations_Summary: Provides a summary of record count, pass count. pass percentage per each location. This is calculated based on the date range provided to the application.
  • getForms_Summary: Provides a summary of record count, pass count. pass percentage per each form. This is calculated based on the date range provided to the application.
  • getRecords: This will pull all header level information of a record based on the date range provided.
  • getRecordFields: This will provide a flattened view of record details, which includes the field name and value for each column per record. This will be pulled based on the date range parameter provided.
  • getFormsByResource: This is a function to be used to invoke by providing the resourceType and resourceName. This would be used to pull all related forms to the provided resource and return all unique Ids.
  • getLocationsByResource: This is a function to be used to invoke by providing the resourceName. This would be used to pull all related locations related to the provided resource and return all unique Ids.
  • getResourceAttributes: This function will query on Resource Name to get the related resource attributes. The table will provide the Attribute Short Name, Attribute Name, and Value for the resource provided.
  • getResourceDetails: This function will pull resources based on type and treelike, providing a table of all resources and their categories.
  • getVerifications: This function will query on VerificationName and date (date range or sliding time) to pull all verifications related to your records.

Updated 3 months ago