Hi, I've been trying to access a non-spatial hosted table on ArcGIS Online with python and have been stuck here. I can search for the table and access its table id but I've been unable to access any of the table's data. I only want to access the table's data, not edit and re-upload the table.
table = GIS.content.search('title: User List', 'Feature Layer')[0]
table_id = table.id
info = search_GIS.content.get(table_id)
Since I only need one column of the table, I first thought of extracting that column as a list and tried to query it but with the line below but I get the following Attribute Error:
table_query = info.query(out_fields='UserName')
AttributeError: 'Item' object has no attribute 'query'
I've also tried converting the column to a spatial dataframe to work with using the line below but I get a KeyError: 'filter'.
result = info.sdf
AttributeError: 'Item' object has no attribute 'filter'
Could someone point me in the right direction to access the hosted table with python? Also, is it possible to convert it to a pandas dataframe to easily work it?
Thank you!