I have a service published in ArcGis Online that consists of a layer and two related tables.
I have to access one of the tables to write a url and I'm using Pandas to do it. Until now it worked correctly, but now I get the following error.
item = gis.content.get("xxxxxxxxxxx")
foto = (item.tables)[1]
field_service_dataframe = pd.DataFrame.spatial.from_layer(foto)
Could not load the dataset: 'PropertyMap' instance has no attribute 'drawingInfo'
If I want to access the layer, I can create the dataframe correctly; however with a table I can't.
Is it normal that only the data of the layer can be accessed or I have something missing in my code?
Thank you for your interest in my problem and excuse the "username dance" I write with.
So you're telling me that it's not possible to access a table within a feature service published in ArcGis Online using
pd.DataFrame.spatial.from_layer(item.tables[0])
right?
I need to access that table because I want to automatically modify a field with a value I collect in my survey.
I get this value from a layer via
item.tables[0].query_related_records()
Or at least I used to.
I tried
SpatialDataFrame.from_layer(item.tables[0)
and I can get into the table, as I told you
.
However, the "objectID" field of the table, which I need to get the related value from the layer, doesn't appear, all fields (GlobalId, ParentId..except that one).
Can you think of another way to access the table?
Thanks!