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
Value | Description |
---|---|
value | The value of the matched attribute |
error-attribute-not-found | If an error occurs, or no matching attribute is found |
Note: return values are case sensitive
Formula Logic
-
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.
-
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.
-
All returned assets are examined to find any with an ASSETTYPE matching the asset type input.
-
The attributes of any assets with a matching ASSETTYPE are examined, to find an attributes matching the attribute code input.
-
If no attribute is found, the result is error-attribute-not-found. Otherwise, the value of the attribute is returned.