Overwriting Hosted Table in Online Capabilities

[kphaneuf]

Overwriting Hosted Table in Online Capabilities

[kphaneuf]

FLTest.csv

Sure, here you go.

[nanaeaubry]

Extra comment:

params = {"capabilities": "Query,Editing,Create,Update,Delete",
    "layerOverridesEnabled": True,}

updating the definition with this works but removing and having just Query is not working. Normally this was as expected but it seems online no longer blocks the capability even though we do.

Need to mess with it online

[nanaeaubry]

@kphaneuf Can you post the small csv we had used?

[nanaeaubry]

@kphaneuf

Ok I was able to test this better and found a few things. First of all you can just pass {"locationType" : None} to the publish method and it will create the table. So no need for the analyze step.

Second, the front end seems to have a bug. When we turn off editing capabilities, it shows that you can still overwrite and when you overwrite you get a little green popup at the bottom of the screen saying overwrite was successful. But this is wrong! If we look at the network traffic we see that success was actually False:

So the necessity to set the capabilities to "Query, Editing,...." as we had seen is actually needed. I will report this bug to online since the ability to overwrite is not available without them.

So just to conclude:
the workflow we found where to define the capabilities, do an update_defintion with the FeatureLayerCollectionManager, overwrite the service, and then set back the capabilities to just "Query" is the best workflow and the correct way to do it.

Hope all of this helps, Ill close the issue since it is resolved and alert online about it but feel free to comment more if needed. Thanks!