Automating appending to web layer in python

Question

I've been trying to automate updating my organizations web-layers so i don't have to do it automatically, but I was having trouble making a model work so I decided to try moving it to python.

I have a geodatabase with all the files I want to use as sources, and the feature layers they match to all have the same name, so it should be easy to match them.

I have written this code, which runs fine until it get to the second for loop. Before I added the second for loop it actually ran with no errors but returned nothing. I have walked step by step through the code and the problem seems to be that it gets to the feature datasets, but then at ListFeatureClasses, it always returns null, even though all the datasets are full of feature classes.

I tried to use arcpy.da.Walk and pycharm says there is no such reference in arcpy.da and I can't even find any info on why that would be.

I feel like once I can get the data in properly, doing the truncate and append with be easy, but I'd need to get there first.

import arcpy
import os

workspace = r'D:\Master_GIS_Files\Data\Florence\Utilities\FlorenceUtilities.gdb'

def FCIterator():
    with arcpy.EnvManager(workspace=workspace):
        fdl= arcpy.ListDatasets()
        featureclasses = arcpy.ListFeatureClasses(fdl)
    for fds in fdl:
        featureclasses.extend(arcpy.ListDatasets(fds))
        for fc in arcpy.ListFeatureClasses(fds):
            yield os.path.join(workspace, fds, fc), fc

def GetWebLayer(name):
    from arcgis.gis import GIS
    gis = GIS('https://city-of-florence.maps.arcgis.com/home', username="KitFlorence", password="Thorne!Florence27")
    ttl = f"title:*{name}"
    q = ttl + 'AND item_type="Feature Layer" AND "owner:' + gis.users.me.username + r'"'
    fLayerz = [f for f in gis.content.search(query=q)][0]
    if fLayerz:
        fLayer = fLayerz[0]
        flID = str(fLayer.id)
        return flID
    else:
        pass

for path, Fname in FCIterator():
    lID = GetWebLayer(Fname)
    print(path, Fname)
    print(lID)

Janeer · Answer

I like ListFeatureClasses function. It takes a number of optional parameters, including wild_card, which allows the user to filter the list of feature classes by a specific search pattern. Additionally, the function returns a list of strings, which makes it easy to iterate over and manipulate the resulting feature class names in subsequent code.

productivity program view

OrrGvili · Answer

try using ListFeatureClasses example from the page

it works for me evry time

JoshuaSharp-Heward · Answer

Yeah getting the query right is often difficult in my experience. You might want to bring "item_type" out of the query and just add it to the gis.content.search() parameters to remove one of the potential variables that could be going wrong. I'd also try to just print out that query to make sure the string is being formatted correctly, at a glance I'm not sure the "" around the owner:username section is right as it doesn't seem to match the query examples on the API reference page. If you are still struggling you could fetch a list of your items by using user.items() instead, although that is less ideal.