https://community.esri.com/t5/python-questions/maketableview-not-working-with-secured-service/m-p/1496716#M70910 <P>I have a bit of code that is making a Table View and then updating a field based on a WHERE clause.</P><P>as Long as my Service is PUBLIC it works fine... if I lock down to Organization or Owner it does not work.&nbsp; I am using a TOKEN but that still does not work...&nbsp;</P><P>I keep getting an error that the table view does not exist which is telling me the&nbsp;arcpy.management.MakeTableView is not working on the secured service.</P><P>Why does this not work on a Secured Service with a proper TOKEN</P><LI-CODE lang="c">def updateDataFlagValuesToImported(): gis2 = GIS("https://**unspecified**.com/portal", "username", "********") currenttoken2 = gis2._con.token print(currenttoken2) arcpy.env.overwriteOutput = True updateFlagURL = r"https://**unspecified**.com/env/rest/services/**unspecified**/FeatureServer/0?token=" + currenttoken2 print(updateFlagURL) whereClause = "FLAG IS NULL" tableView = "fLyr" try: arcpy.management.MakeTableView(updateFlagURL, tableView, whereClause) except Exception: # Handle errors accordingly...this is generic tb = sys.exc_info()[2] tb_info = traceback.format_tb(tb)[0] pymsg = 'PYTHON ERRORS:\n\tTraceback info:\t{tb_info}\n\tError Info:\t{str(sys.exc_info()[1])}\n' msgs = 'ArcPy ERRORS:\t{arcpy.GetMessages(2)}\n' print(pymsg) print(msgs) arcpy.management.CalculateField( in_table= "fLyr", field="FLAG", expression="'Imported'", expression_type="PYTHON3", code_block="", field_type="TEXT", enforce_domains="NO_ENFORCE_DOMAINS" )</LI-CODE><P>&nbsp;</P> Mon, 24 Jun 2024 16:05:42 GMT kapalczynski 2024-06-24T16:05:42Z https://community.esri.com/t5/python-questions/maketableview-not-working-with-secured-service/m-p/1496716#M70910 <P>I have a bit of code that is making a Table View and then updating a field based on a WHERE clause.</P><P>as Long as my Service is PUBLIC it works fine... if I lock down to Organization or Owner it does not work.&nbsp; I am using a TOKEN but that still does not work...&nbsp;</P><P>I keep getting an error that the table view does not exist which is telling me the&nbsp;arcpy.management.MakeTableView is not working on the secured service.</P><P>Why does this not work on a Secured Service with a proper TOKEN</P><LI-CODE lang="c">def updateDataFlagValuesToImported(): gis2 = GIS("https://**unspecified**.com/portal", "username", "********") currenttoken2 = gis2._con.token print(currenttoken2) arcpy.env.overwriteOutput = True updateFlagURL = r"https://**unspecified**.com/env/rest/services/**unspecified**/FeatureServer/0?token=" + currenttoken2 print(updateFlagURL) whereClause = "FLAG IS NULL" tableView = "fLyr" try: arcpy.management.MakeTableView(updateFlagURL, tableView, whereClause) except Exception: # Handle errors accordingly...this is generic tb = sys.exc_info()[2] tb_info = traceback.format_tb(tb)[0] pymsg = 'PYTHON ERRORS:\n\tTraceback info:\t{tb_info}\n\tError Info:\t{str(sys.exc_info()[1])}\n' msgs = 'ArcPy ERRORS:\t{arcpy.GetMessages(2)}\n' print(pymsg) print(msgs) arcpy.management.CalculateField( in_table= "fLyr", field="FLAG", expression="'Imported'", expression_type="PYTHON3", code_block="", field_type="TEXT", enforce_domains="NO_ENFORCE_DOMAINS" )</LI-CODE><P>&nbsp;</P> Mon, 24 Jun 2024 16:05:42 GMT https://community.esri.com/t5/python-questions/maketableview-not-working-with-secured-service/m-p/1496716#M70910 kapalczynski 2024-06-24T16:05:42Z https://community.esri.com/t5/python-questions/maketableview-not-working-with-secured-service/m-p/1496727#M70911 <P>Think I just got it... I added the line to sign into Portal and I think its working...&nbsp;<BR />I also removed the TOKEN which was not needed on the Service... the portal login was enough</P><P>&nbsp;</P><LI-CODE lang="c">portalURL = 'https://**unspecified**.com/portal' username = 'username' password = '********' arcpy.SignInToPortal(portalURL, username, password) def updateDataFlagValuesToImported(): updateFlagURL = r"https://**unspecified**.com/env/rest/services/**unspecified**/FeatureServer/0" whereClause = "FLAG IS NULL" tableView = "fLyr" arcpy.management.MakeTableView(updateFlagURL, tableView, whereClause) arcpy.management.CalculateField( in_table= "fLyr", field="FLAG", expression="'Imported'", expression_type="PYTHON3", code_block="", field_type="TEXT", enforce_domains="NO_ENFORCE_DOMAINS" )</LI-CODE><P>&nbsp;</P> Mon, 24 Jun 2024 16:21:25 GMT https://community.esri.com/t5/python-questions/maketableview-not-working-with-secured-service/m-p/1496727#M70911 kapalczynski 2024-06-24T16:21:25Z