Hello,
I need to be able to summarize nested related records. I have been through the documentation and sample notebooks but have been unable to connect the dots on this. I would appreciate any help in understanding the process.
Here is where I am now:
# get the feature layer collection from AGOL
feature_layer_collection = gis.content.get('bf7307237621413fb692f2f1a6f26211')
# get the feature layer of interest
feature_layer = feature_layer_collection.layers[0]
# get the related tables of interest
feature_table1 = feature_layer_collection.tables[0]
feature_table2 = feature_layer_collection.tables[1]
# query the related records from feature_table
related_table1 = feature_layer.query_related_records(object_ids="2", relationship_id="1", out_fields="*")
related_table2 = feature_table1.query_related_records(object_ids='2', relationship_id="2", out_fields="*")
# Look at what's inside the result
related_table1?
Type: dict String form: {'fields': [{'name': 'objectid', 'type': 'esriFieldTypeOID',
'alias': 'ObjectID', 'sqlType': 'sql <...> 'sqlTypeOther',
'length': 128, 'domain': None, 'defaultValue': None}], 'relatedRecordGroups': []} Length: 2 Docstring: dict() -> new empty dictionary dict(mapping) -> new dictionary initialized from a mapping object's (key, value) pairs dict(iterable) -> new dictionary initialized as if via: d = {} for k, v in iterable: d = v dict(**kwargs) -> new dictionary initialized with the name=value pairs in the keyword argument list. For example: dict(one=1, two=2)
There is nothing in the 'relatedRecordsGroups', how do I access the values in the related table?
How do I summarize those values?
Thank you for any help.
Here is the URL for the feature service I am using in this example: https://services8.arcgis.com/ZbDl0kmn9FILhh7J/arcgis/rest/services/service_02ec21de18564c0782c96723d...
