Latest Contributions by MattTarkington1

Hello all, I'm attempting to automatically compile an array of domain codes for comparison when deciding how to visualize a layer.  So this is what I've got so far:   var codearray = Array(1) var domain = Domain($feature, "Status") var index = 0 var codedValues = domain.codedValues[index].code for(var att in codedValues){ Insert(codearray, 0, codedValues) index + 1 } return codearray  Results: array(4) 0: null 1: "Run" 2: "Run" 3: "Run" Input Data (results of Domain function) dictionary codedValues: array(2) 0: dictionary code: "Run" name: "Run" 1: dictionary code: "Standby" name: "Standby" dataType: "esriFieldTypeString" name: "HydrantLoc_111319_Status_f1dd7c78-d63c-4b23-8d0d-a5f5c916c584" type: "codedValue"   The Results I'm looking for: array(2) 0: "Run" 1: "Standby"   Then to take this a step further I'm looking to do this for multiple fields and then combine them into another array that contains every combination of value from each array. But maybe that's a problem for a different post.   Thanks In Advance Yall! ... View more

Hi everyone, I'm trying to take some models in ArcPro that I've built, and translate them into a AGOL Advanced notebook. (It'd be a lot easier to just leave this in models, but IT issues cause periodic disconnect from portal mid processes and it corrupts the data) Originally I was building the notebook in pro for testing. However I just tried it in the online environment and am not having any success.  Here's the code (works in an ArcPro Notebook.) from arcgis.gis import GIS gis = GIS("home") import arcpy line_url = ("https://services8.arcgis.com/kiN57DOJrIhpvBby/arcgis/rest/services/<LineLayer>/FeatureServer/98") table_url = ("https://services8.arcgis.com/kiN57DOJrIhpvBby/arcgis/rest/services/<TableForJoin>/FeatureServer/0") arcpy.management.DeleteField(in_table=line_url, drop_field=["Freight", "Price_Per_Foot", "Price_Per_Unit", "Type", "Description" ])[0] arcpy.management.JoinField( in_data=line_url, in_field="Lock", join_table=table_url, join_field="Key_", fields="Description;Price_Per_Foot;Price_Per_Unit;Freight", fm_option="NOT_USE_FM", field_mapping=None )   And the error (returned in AGOL Notebook, no errors in pro): ExecuteError Traceback (most recent call last) Input In [110], in <cell line: 2>() 1 #Drop Fields ----> 2 arcpy.management.DeleteField( 3 in_table=line_url, 4 drop_field="Lock;Description;Price_Per_Foot;Price_Per_Unit;Freight", 5 method="DELETE_FIELDS" 6 ) 8 arcpy.management.JoinField( 9 in_data=line_url, 10 in_field="Lock", (...) 15 field_mapping=None 16 ) File /opt/conda/lib/python3.9/site-packages/arcpy/management.py:6025, in DeleteField(in_table, drop_field, method) 6023 return retval 6024 except Exception as e: -> 6025 raise e File /opt/conda/lib/python3.9/site-packages/arcpy/management.py:6022, in DeleteField(in_table, drop_field, method) 6020 from arcpy.arcobjects.arcobjectconversion import convertArcObjectToPythonObject 6021 try: -> 6022 retval = convertArcObjectToPythonObject(gp.DeleteField_management(*gp_fixargs((in_table, drop_field, method), True))) 6023 return retval 6024 except Exception as e: File /opt/conda/lib/python3.9/site-packages/arcpy/geoprocessing/_base.py:512, in Geoprocessor.__getattr__.<locals>.<lambda>(*args) 510 val = getattr(self._gp, attr) 511 if callable(val): --> 512 return lambda *args: val(*gp_fixargs(args, True)) 513 else: 514 return convertArcObjectToPythonObject(val) ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Table: Dataset https://services8.arcgis.com/kiN57DOJrIhpvBby/arcgis/rest/services/<LineLayer>/FeatureServer/98 does not exist or is not supported Failed to execute (DeleteField). So my end goal here is to have a table hosted in AGOL that when updated, will update prices in hosted Feature Layers. Then on to field calculates to get price of line based on (feet*price per foot).  I'm deleting fields before joining because if I don't delete, the join just continually adds more sequential fields that do not fit in with the field calculation done later in the script (at least that's how it worked in model builder).  I've also tried gis.content.get, and converting to the FeatureLayer module in this script, and get a different error: RuntimeError Traceback (most recent call last) Input In [111], in <cell line: 2>() 1 #arcpy.management.DeleteField(in_table=lineFeature, drop_field=["Freight", "Price_Per_Foot", "Price_Per_Unit", "Type", "Description"])[0] ----> 2 arcpy.management.DeleteField( 3 in_table=FuturePipe, 4 drop_field="Lock;Description;Price_Per_Foot;Price_Per_Unit;Freight", 5 method="DELETE_FIELDS" 6 ) 8 arcpy.management.JoinField( 9 in_data=lineFeature, 10 in_field="Lock", (...) 15 field_mapping=None 16 ) File /opt/conda/lib/python3.9/site-packages/arcpy/management.py:6025, in DeleteField(in_table, drop_field, method) 6023 return retval 6024 except Exception as e: -> 6025 raise e File /opt/conda/lib/python3.9/site-packages/arcpy/management.py:6022, in DeleteField(in_table, drop_field, method) 6020 from arcpy.arcobjects.arcobjectconversion import convertArcObjectToPythonObject 6021 try: -> 6022 retval = convertArcObjectToPythonObject(gp.DeleteField_management(*gp_fixargs((in_table, drop_field, method), True))) 6023 return retval 6024 except Exception as e: File /opt/conda/lib/python3.9/site-packages/arcpy/geoprocessing/_base.py:512, in Geoprocessor.__getattr__.<locals>.<lambda>(*args) 510 val = getattr(self._gp, attr) 511 if callable(val): --> 512 return lambda *args: val(*gp_fixargs(args, True)) 513 else: 514 return convertArcObjectToPythonObject(val) RuntimeError: Object: Error in executing tool If anyone knows of a better way to do this or how to get the delete then join function working correctly, I very much appreciate the help. Cheers, Matt ... View more