Esri ArcGIS Enterprise UK Data Loader - Get Property field value
- What is it? This calculation will retrieve the value of the specified field for the property identified by the supplied UPRN (or its parent).
Setup
The formula requires Esri ArcGIS Enterprise UK Data Loader integration to be configured. This can be done under Settings > Integrations > Esri ArcGIS Enterprise UK Data Loader.
Inputs
This formula requires 3 inputs to be passed through to it:
| Field | Description |
|---|---|
| UPRN | the UPRN of the property to look up |
| Check Parent | whether or not to return a value from the Parent property (if there is one) |
| Field Name | the name of the field on the property record to return a value for |
Return values
| Value | Description |
|---|---|
| string | The value of the field for the property (or its parent) |
| false | If the property (or parent property) or field is not found, or there is an error fetching the results |
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 logic returns 'false'.
-
The property is fetched from Esri using the supplied UPRN value.
-
If the property has a Parent and the Check Parent option is set to 'Yes', the value of the specified Field Name is returned for the Parent property.
-
Otherwise, the value of the specified Field Name is returned for the property identified by UPRN.
If the property or the Field Name field is not found, 'false' will be returned.