Predefined Calculation: Northgate M3PP / Assure - Get asset key(s) of type(s) with attribute value(s) for property
This calculation will return a comma-separated list of asset keys that match specified assets types with attribute values.
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.
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(s) to consider
- the attribute code
- the accepted value(s) to include
The mapped value for the UPRN must come from an address lookup question, using the property_identifier variable option.
|comma separated list of asset keys||The keys of any assets that match the specified asset types, and have a matching attribute with one of the accepted values|
|empty string||If an error occurs|
Note: return values are case sensitive
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 an empty string.
A list is created to track matching assets.
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 n empty string.
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 any attributes matching the attribute code input.
Any matching attributes are examined, to find any where the value matches one of the accepted value(s) input.
If any attributes with a matching value are found, the asset's key is added to the list, and the next asset is examined.
The result is set to be a comma-separated version of the list of asset keys