Python API: FeatureLayerCollection Manager, add_to_definition and the json_dict

Question

I am having trouble determining the proper way to use add_to_definition:

https://esri.github.io/arcgis-python-api/apidoc/html/arcgis.features.managers.html

A sample js dict seems to be here:

https://developers.arcgis.com/rest/services-reference/add-to-definition-feature-service-.htm

This may end up me not being able to determine the appropriate workflow. When I used ArcGIS Pro to publish my feature service the first time, the feature layers were published under one service definition (Map):

I am able to update layers using layer.edit_features, and remove them using featureLayerCollection.manager.delete_from_definition(json_delete_dict).

What I am trying to do is write a json_dict directly to the 'Map' Service Definition. I don't want to publish something separately via item.publish (unless I'm supposed to?):

https://esri.github.io/arcgis-python-api/apidoc/html/arcgis.gis.toc.html?highlight=publish#arcgis.gis.Item.publish

I want to directly 'append', for lack of a better word, the layer to the service definition in the same way the other layers and data were published the first time:

Is it possible to directly add a layer to a service definition without publishing the item first? Am I off base? If I'm not even close, can someone walk me through the steps to add a layer to a service definition? Is there sample code anywhere (specifically a python add_to_definition json dict)?

Appreciate any and all insight.

wightman_akibby · Answer

I made more progress. I want to change this script so it actually uses the add_to_definition method from the API (since it would probably make my script less verbose), but for now, this works. Below is a modified of my final script (because it's doing something slightly different than what you want), but this snippet might be helpful too. I haven't tested this exact script, but it should work. Just input the service URL of your table (it has to uploaded to AGOL first, doesn't matter where it is) and the item ID of where you want to add the table. Again, haven't tested this for a feature layer instead of a table. EDIT: test this on some dummy data first. I've had addToDefinition go wrong before and pretty much delete all my data (but it was okay b/c it was dummy data). The finalized script shouldn't do that, but still test it. from arcgis.gis import GIS from arcgis.features import FeatureLayerCollection, FeatureLayer import json, requests url = 'https://www.arcgis.com' user = 'username' pw = 'pw' gis = GIS(url,user,pw) def build_json(table, name): # turn PropertyMap type to list of dictionaries (PropertyMap is not JSON # serializable) fields = [] for i in table: d = {} for k,v in i.items(): d[k] = v fields.append(d) # assumes field OBJECTID is your objectIdField temp_json = json.dumps({'layers': [{'name':name, 'type': 'Table', 'objectIdField': 'OBJECTID', 'fields': fields}]}) return temp_json def add_to_definition(origin,add_json,table_name): token = gis._con.token flayer = FeatureLayerCollection.fromitem(origin) url = f'{flayer.service.url}/AddToDefinition?token={token}' # build URL to POST to payload_add = { 'addToDefinition': add_json, 'async': 'true', 'f': 'json', 'token': token } session = requests.Session() result = session.post(url,data=payload_add) print(result) def main(): ago_table = FeatureLayer('URL to your feature layer') origin = gis.content.get('ID of the feature class you want to add data to') table_name = ago_table.properties.name fields = ago_table.properties.fields add_json = build_json(fields,table_name) add_to_definition(origin, add_json, table_name) if __name__ == '__main__': main()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

JohnEvans6 · Answer

I may end up doing just that. It seemed like a lot of overhead considering the layers update/add/change frequently. If I end up burning too much time on the above add to definition table, I'll just overwrite the whole service.

Thanks!

JohnEvans6 · Answer

Hi Ryan appreciate the snippet. I could not figure out how to get a table added and this seems to do just that. I've got to wrap up another project then I'm diving back into this one. Thanks!