topic Missing Tables when connecting to a map service using arcgis.gis in Python Questions https://community.esri.com/t5/python-questions/missing-tables-when-connecting-to-a-map-service/m-p/292515#M22634 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am trying to connect to a published map service using the python arcgis.gis api to get at some tables and layers that are attached to a map service on our portal.</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>from arcgis.gis import GIS<BR /> from arcgis import features<BR /> from arcgis.features import FeatureLayer</P><P><BR /> gis = GIS('https://portalurl.com/portal','username','password')<BR /> <BR /> #IncomingData<BR /> incoming_data_item = gis.content.get('Item ID')<BR /> incoming_data_tables = incoming_data_item.tables<BR /> print(incoming_data_tables)<BR /> incoming_data_layers = incoming_data_item.layers<BR /> print(incoming_data_layers)</P><P></P><P>#table layers</P><P>table_one = incoming_data_tables[0]</P><P>table_two =&nbsp;<SPAN style="background-color: #f6f6f6;">incoming_data_tables[1]</SPAN></P><P></P><P>#query results<BR /> query_result_order = table_one.query(where=query)</P><P><SPAN style="background-color: #f6f6f6;">query_result_customers&nbsp;=<SPAN>&nbsp;</SPAN></SPAN><SPAN style="background-color: #f6f6f6;">table_two</SPAN><SPAN style="background-color: #f6f6f6;">.query(where=query)</SPAN></P><P></P></BLOCKQUOTE><P>This should return one Layer and two Tables, but it is only including the single layer, and the tables return empty.</P><P></P><P>This code does work just fine when I am trying to reach a Feature Service, but this is a Map Service so I am curious if I should be doing something different. Can anyone weigh in?</P></BODY></HTML> Tue, 03 Nov 2020 17:08:31 GMT NathanKoski 2020-11-03T17:08:31Z Missing Tables when connecting to a map service using arcgis.gis https://community.esri.com/t5/python-questions/missing-tables-when-connecting-to-a-map-service/m-p/292515#M22634 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am trying to connect to a published map service using the python arcgis.gis api to get at some tables and layers that are attached to a map service on our portal.</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>from arcgis.gis import GIS<BR /> from arcgis import features<BR /> from arcgis.features import FeatureLayer</P><P><BR /> gis = GIS('https://portalurl.com/portal','username','password')<BR /> <BR /> #IncomingData<BR /> incoming_data_item = gis.content.get('Item ID')<BR /> incoming_data_tables = incoming_data_item.tables<BR /> print(incoming_data_tables)<BR /> incoming_data_layers = incoming_data_item.layers<BR /> print(incoming_data_layers)</P><P></P><P>#table layers</P><P>table_one = incoming_data_tables[0]</P><P>table_two =&nbsp;<SPAN style="background-color: #f6f6f6;">incoming_data_tables[1]</SPAN></P><P></P><P>#query results<BR /> query_result_order = table_one.query(where=query)</P><P><SPAN style="background-color: #f6f6f6;">query_result_customers&nbsp;=<SPAN>&nbsp;</SPAN></SPAN><SPAN style="background-color: #f6f6f6;">table_two</SPAN><SPAN style="background-color: #f6f6f6;">.query(where=query)</SPAN></P><P></P></BLOCKQUOTE><P>This should return one Layer and two Tables, but it is only including the single layer, and the tables return empty.</P><P></P><P>This code does work just fine when I am trying to reach a Feature Service, but this is a Map Service so I am curious if I should be doing something different. Can anyone weigh in?</P></BODY></HTML> Tue, 03 Nov 2020 17:08:31 GMT https://community.esri.com/t5/python-questions/missing-tables-when-connecting-to-a-map-service/m-p/292515#M22634 NathanKoski 2020-11-03T17:08:31Z