topic Re: get a list of all arcgis items with arcgis python module in ArcGIS API for Python Questions

get a list of all arcgis items with arcgis python module

JohnBroecher — Sun, 01 Apr 2018 01:13:04 GMT

Is it possible to get a list of all arcgis online items with the python module?

Re: get a list of all arcgis items with arcgis python module

DanPatterson_Retired — Sun, 01 Apr 2018 02:28:52 GMT

This is the API reference https://esri.github.io/arcgis-python-api/apidoc/html/

What specifically is it you need?

Re: get a list of all arcgis items with arcgis python module

JohnBroecher — Tue, 03 Apr 2018 13:41:22 GMT

Couldn't find anything in the reference. I'm looking for a way to get a list of all items in my AGO account.

Re: get a list of all arcgis items with arcgis python module

Anonymous User — Tue, 03 Apr 2018 13:51:10 GMT

You could try searching using an owner filter like:

gis.content.search("owner:my_username", max_items=1000)

If you authenticate with your account, then it should find everything you own.

arcgis.gis module — arcgis 1.4.0 documentation

Re: get a list of all arcgis items with arcgis python module

RonnieRichards — Tue, 03 Apr 2018 13:52:36 GMT

The API reference above is correct. There is a search method which should do exactly what you need.

Re: get a list of all arcgis items with arcgis python module

citrasagala — Sun, 12 Dec 2021 09:33:39 GMT

Maybe this script can help.

The output will export excel files contains all parameters like title, type, itemid, etc.

from arcgis.gis import GIS
import pandas as pd

portal = GIS("url portal", "username", "password")

#set "max_users" parameters in search() if you have more than 100 users in your portal
users_all = portal.users.search() 

def get_item(user):
       list_items = {}
       content_item = user.items()
       for item in content_item:
             list_items[item.itemid] = item
      
      folders = user.folders
       for folder in folders :
             folder_items = user.items(folder=folder['title'])
             for item in folder_items:
                     list_items[item.itemid] = item
       pd.DataFrame(list_items).transpose().to_excel(str(user.username)+'.xlsx')

for i in range(len(users_all)):
       print("extract "+ str(users_all[i]) + "data to excel...")
       get_item(users_all[i])‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: get a list of all arcgis items with arcgis python module

ConorMacNaughton — Fri, 30 Oct 2020 18:07:22 GMT

If I don't have an enterprise portal where does the Excel end up? It doesn't show up in my organization's content in AGO. The script seems to run fine and loops through my users, but I can't figure out where the exports are located.

Is there something I can add to the script to download the Excel after its been exported?

Re: get a list of all arcgis items with arcgis python module

Marc_Graham — Mon, 11 Jan 2021 22:37:16 GMT

I know this is a bit old but you can just modify the script to specify an output location:

pd.DataFrame(list_items).transpose().to_excel('C:\\temp\\' + str(user.username)+'.xlsx')

@ConorMacNaughton wrote:
If I don't have an enterprise portal where does the Excel end up? It doesn't show up in my organization's content in AGO. The script seems to run fine and loops through my users, but I can't figure out where the exports are located.
Is there something I can add to the script to download the Excel after its been exported?

Re: get a list of all arcgis items with arcgis python module

Marc_Graham — Tue, 12 Jan 2021 00:04:20 GMT

Great script thanks.

Re: get a list of all arcgis items with arcgis python module

ErnestoCarreras2 — Fri, 22 Jan 2021 21:02:32 GMT

The script is great! Thanks for sharing... I have been trying to perform this task but in my case, I just need to list the items inside a specific folder within AGOL's content folders. I like the way the original scripts outputs the table with title, type, itemid. Any assistance will be appreciated!

Re: get a list of all arcgis items with arcgis python module

SolanaFoo2 — Tue, 20 Apr 2021 03:44:36 GMT

I got it to work but was not getting all results. Turns out there's a default of 100 items returned max. I had to explicitly change that to see everything:

folder_items = user.items(folder=folder['title'],max_items=1000)