topic Re: Python Script to Download Data from Hosted Feature Layer in Enterprise Portal in Python Questions

Python Script to Download Data from Hosted Feature Layer in Enterprise Portal

JoshSmithWCWD — Fri, 12 Aug 2022 15:55:10 GMT

Hi!

I have a model that I run in ArcGIS Pro that uses the table to table tool to export the data from a hosted feature layer to a csv. We'd like to get this process automated with a python script. Does anyone have one that they would be willing to share that does this or something similar?

Everything example I've found online uses ArcGIS Online and not Enterprise.

Thanks!

Re: Python Script to Download Data from Hosted Feature Layer in Enterprise Portal

Anonymous User — Fri, 12 Aug 2022 16:15:14 GMT

You can export your model to a script, which will give you the best 'working' script example using your variables.

exporting-a-model-to-python

Re: Python Script to Download Data from Hosted Feature Layer in Enterprise Portal

JoshSmithWCWD — Fri, 12 Aug 2022 16:45:55 GMT

Hey Jeff,

Thanks for the reply. That is what we've tried, but have been unsuccessful so far. We get the following error: ERROR 000732: Input Rows: Dataset ### does not exist or is not supported

It seems like the dataset is inaccessible in our Enterprise Portal where we use an active directory. Would you happen to have a sample script on accessing an enterprise environment?

Thanks again!

Re: Python Script to Download Data from Hosted Feature Layer in Enterprise Portal

Anonymous User — Fri, 12 Aug 2022 18:06:34 GMT

cool, well... connecting to a portal can be done a few ways. with a local account:

from arcgis.gis import GIS portalGIS = GIS("https://your portal", 'username', "password") dataitem = portalGIS.content.get('the id of the table that you want to get')

Using oauth takes some steps to get set up, provided here which involves creating an Application to set up an client id.

client_id = 'you have to creat it to get it' portalGIS = GIS(client_id=client_id, url='your portal stuff') dataitem = portalGIS.content.get('the id of the table that you want to get')

... this will prompt the user to connect though, and required a generated key to be pasted last time I ran it. If you want it hands free automated, setting up the local portal account would work easiest.

Is the data shared at a level where you can get it?