Skip to main content

Northgate M3PP / Assure - Get Property Asset Attribute Value

  • What is it? This calculation will count the number of assets that are of a type specified and have the attribute of a specified value, for a particular property in M3PP / Assure.

Setup

The formula requires connection to a Jadu hubIS instance, which can be configured in the Integrations page. Your Jadu hubIS instance should be configured to connect to your M3PP / Assure instance. For help setting up and configuring hubIS, contact Jadu Support.

Inputs

This formula requires the following inputs to be passed through to it:

  • the name of the M3PP / Assure instance as configured in Jadu hubIS
  • the UPRN of the property to check
  • the asset type to find
  • the attribute code to find

The mapped value for the UPRN must come from an address lookup question, using the property_identifier variable option.

Return values

ValueDescription
valueThe value of the matched attribute
error-attribute-not-foundIf an error occurs, or no matching attribute is found

Note: return values are case sensitive

Formula Logic

  1. A check is made to see if the integration has been enabled in the Settings > Integrations page. If the integration is not enabled the formula returns error-attribute-not-found.

  2. A call is made to GetAssets passing in the UPRN input. This returns all the assets set on a property. If the call fails, the result is error-attribute-not-found.

  3. All returned assets are examined to find any with an ASSETTYPE matching the asset type input.

  4. The attributes of any assets with a matching ASSETTYPE are examined, to find an attributes matching the attribute code input.

  5. If no attribute is found, the result is error-attribute-not-found. Otherwise, the value of the attribute is returned.