topic Re: Feature layer added to Feature Service does not show in AGOL in ArcGIS Online Questions

Feature layer added to Feature Service does not show in AGOL

MarkC1 — Wed, 15 Jun 2022 21:10:13 GMT

I've added a new feature layer to an existing feature service via the REST API (Add to Definition). The new feature layer gets added successfully and it is listed in the layers when viewing the service via the service URL. However, the layer does not appear in AGOL and I cannot access it.

I've tested it with several existing feature services in my agol, by adding the exact same layer definition to multiple feature services. Some of for some of them it works perfectly but for others I get the above behaviour. I have even tried to duplicate one of the existing layers in the feature services where I see this issue with no success.

Has anyone experienced this or can provide any help? I am guessing that there is something different about the layers it does not work on.

Edit: It seems to affect feature services originally published from Arcgis Pro

Example:

Point Layer 2 added via to existing layer via REST API. Visible at feature service URL but not showing up in AGOL

Re: Feature layer added to Feature Service does not show in AGOL

MarkC1 — Wed, 15 Jun 2022 21:46:36 GMT

Ok, so I suspect this is related to feature services published from Arcgis Pro. If you view such the JSON for such a layer in AGOL assistant there is a "Data" page which specifies the layers. This does not seem to get updated when a new layer is added via the REST api.

When you compare a feature service created directly in AGOL versus one published from Pro this data page is not present, only the feature service description.

So, I edited the JSON on the data page in AGOL Assistant and just left an empty set of curly brackets and suddenly the layers I added via the REST api were visible in AGOL. This doesn't seem to have affect my existing data and the service seems to still work fine.

Feature service created via AGOL: Just one "Description Page"

Feature service created in Pro: Description page and Data page detail the layer

Edit made to the Data page:

Re: Feature layer added to Feature Service does not show in AGOL

RyanTucker — Wed, 07 Sep 2022 23:21:19 GMT

I'm trying to do the same right now. I have been successful adding a layer to an existing feature service using the rest API JSON example for Add To Definition.

However I'm having issues with my own JSON code. Would you be willing to share your JSON code?

Re: Feature layer added to Feature Service does not show in AGOL

MarkC1 — Sat, 23 Jul 2022 17:56:13 GMT

Hi @RyanTucker , sorry but I can't share the code. What's your issue? Was your feature service originally published from Arcgis Pro? If so, maybe you can try deleting the service definitio that gets published with it? Did you try my fix above?

Re: Feature layer added to Feature Service does not show in AGOL

RyanTucker — Sat, 23 Jul 2022 23:07:25 GMT

@MarkC1 the data is loaded from a zipped file geodatabase.

I'm thinking I'm having a syntax issue. When I submit my checked code (JSON lint)I'm getting a random 400 exception error. So I'm not even getting to the point of seeing a layer listed under the feature service.

I'll try again. I guess one thing I don't understand from the Add to Definition example is how do you determine the database_username part of the table name?

Re: Feature layer added to Feature Service does not show in AGOL

MarkC1 — Sun, 24 Jul 2022 10:40:19 GMT

To determine the database_username part of the table name just look at the json for any layer in your AGOL.This is the same for every layer/fs in your AGOL and doesn't change. Although I don't think it matters if you use the wrong one.

Below is JSON what will work and the steps involved. As a quick test, create a test feature service and see if you can add it.

You said above that you were able to successfully add a layer? Where/when is the 400 exception error occuring? It sounds like you are actually having trouble adding the layer in the first place. If so, it's probably poor json. The easiest thing to do is to copy the json from an existing feature layer and edit it.

An easy way is to first create the layer you want to add to your existing feature service as a new, seperate feature service. Define the fields etc. in Arcgis Pro or in AGOL, then just copy the json that AGOL creates for you.

So for example, here is a simple point layer I created in AGOL. Create you own layer with the fields etc. that you need.

View the feature service in and switch to Admin mode (link in top right):

Open the layer you want to "copy" to your existing feature service and view and copy the raw json:

Edit the json:

1. Add { "layers" : [ to the beginning

2. Add corresponding closing brackets to the end ]}

3. Change the "Name" (Row 19)

3. Optional: Change the Layer ID (Row 15) to whatever number you want. If you leave it at 0 AGOL will just assign a layer id to it that doesnt' conflict with any other layers in the feature service

{ "layers" : [ { "adminLayerInfo" : { "tableName" : "db_72280.user_72280.Test_Point_Layer_TESTING", "geometryField" : {"name" : "Shape"}, "xssTrustedFields" : "" }, "id" : 0, "enableUseOfScaleOutReplicasWhenEditable" : true, "name" : "Testing", "type" : "Feature Layer", "serviceItemId" : "e662b9687e584b07916701428c21c0dc", "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1658654341208 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsQueryWithDatumTransformation" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsDefaultSR" : true, "supportsFullTextSearch" : true }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -17811118.526923772, "ymin" : -15538711.096309224, "xmax" : 17811118.526923772, "ymax" : 15538711.096309224, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}, "allowGeometryUpdates" : true, "hasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "isEnabled" : true }, { "name" : "name", "fieldName" : "ATT_NAME", "isEnabled" : true }, { "name" : "size", "fieldName" : "DATA_SIZE", "isEnabled" : true }, { "name" : "contentType", "fieldName" : "CONTENT_TYPE", "isEnabled" : true }, { "name" : "keywords", "fieldName" : "Keywords", "isEnabled" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : true, "allowUpdateWithoutMValues" : true, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field1", "type" : "esriFieldTypeString", "alias" : "Field1", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "visible" : true, "domain" : null, "defaultValue" : null }, { "name" : "Field2", "type" : "esriFieldTypeString", "alias" : "Field2", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "visible" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "Test_Point_Layer_TESTING_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index" }, { "name" : "PK__Test_Poi__F4B70D85571405E5", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Field1" : null, "Field2" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,imageCollection", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,excel", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "supportedContingentValuesFormats" : "JSON, PBF", "supportedSyncDataOptions" : 4, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" } ] }

Add to your exsiting service layer. So here is a dummy one I set up:

Before

Add to Definition:

Remove the json already there and paste your edited json from above.

Paste in your edited json from above and you should see this response if successful:

Re: Feature layer added to Feature Service does not show in AGOL

RyanTucker — Mon, 25 Jul 2022 22:58:02 GMT

@MarkC1 I was able to get it to work with your example, and subsequently my field schema after some substitution. THank you!

I also found this Hosted Features Services Reference page on github which was a tremdous help. Apparently for table name you dont need to use db_ and user_ .

/* Create Point layer example from GitHub Link in post */ { "layers": [{ "currentVersion": 10.51, "id": 0, "name": "Point layer", "type": "Feature Layer", "displayField": "", "description": "", "copyrightText": "", "defaultVisibility": true, "editingInfo": { "lastEditDate": null }, "relationships": [], "isDataVersioned": false, "supportsAppend": true, "supportsCalculate": true, "supportsTruncate": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsRollbackOnFailureParameter": true, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSql": true, "supportsCoordinatesQuantization": true, "supportsApplyEditsWithGlobalIds": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsPaginationOnAggregatedQueries": true, "supportsQueryRelatedPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsQueryWithResultType": true, "supportsSqlExpression": true, "supportsAdvancedQueryRelated": true, "supportsCountDistinct": true, "supportsLod": true, "supportsReturningGeometryCentroid": false, "supportsQueryWithDatumTransformation": true, "supportsHavingClause": true, "supportsOutFieldSQLExpression": true }, "useStandardizedQueries": true, "geometryType": "esriGeometryPoint", "minScale": 0, "maxScale": 0, "extent": { "xmin": -20037508.342788905, "ymin": -8175201.3721496435, "xmax": -10018754.171394452, "ymax": 12175461.54272524, "spatialReference": { "wkid": 102100 } }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "RedSphere.png", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=", "contentType": "image/png", "width": 15, "height": 15 } } }, "allowGeometryUpdates": true, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasM": false, "hasZ": false, "objectIdField": "OBJECTID", "uniqueIdField": { "name": "OBJECTID", "isSystemMaintained": true }, "globalIdField": "", "typeIdField": "", "fields": [{ "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "sqlType": "sqlTypeOther", "nullable": false, "editable": false, "domain": null, "defaultValue": null }], "indexes": [], "types": [], "templates": [{ "name": "New Feature", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": {} } }], "supportedQueryFormats": "JSON, geoJSON", "hasStaticData": false, "maxRecordCount": 2000, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "maxRecordCountFactor": 1, "capabilities": "Query,Editing,Create,Update,Delete,Sync", "syncEnabled": true, "adminLayerInfo": { "geometryField": { "name": "Shape", "srid": 102100 } } }], "tables": [] }

Re: Feature layer added to Feature Service does not show in AGOL

RyanTucker — Fri, 28 Oct 2022 20:36:31 GMT

@MarkC1 just FYI; I have a case open with ESRI to try and rectify this issue where we need to edit the JSON through Assistant to make the added features layers show up on the feature service content page.

Re: Feature layer added to Feature Service does not show in AGOL

DougGreen — Thu, 17 Aug 2023 18:37:06 GMT

Any word if this case is resolved. I've just successfully added layers to a hosted feature layer and they show up in the rest services directory but not on the Item overview page.

Re: Feature layer added to Feature Service does not show in AGOL

RyanTucker — Fri, 18 Aug 2023 00:14:29 GMT

Unfortunately, no.

Re: Feature layer added to Feature Service does not show in AGOL

mikaël — Mon, 28 Aug 2023 12:55:46 GMT

I talked to ESRI support about this and they finally told me it was a known bug: https://support.esri.com/fr-fr/bug/new-layers-added-to-a-service-via-the-rest-endpoint-do-bug-000145205

If you need to add the layer/table to a map, you can do it manually as explained at the bottom of the bug page.

Re: Feature layer added to Feature Service does not show in AGOL

ANRGIS — Sun, 03 Dec 2023 19:02:18 GMT

Hello,

I was successful testing this on a newly created hosted feature layer but when I try and add it to my production hosted feature layer I get this message:

{
  "error" : 
  {
    "code" : 400, 
    "message" : "Unable to add feature service definition.", 
    "details" : [
      "Incorrect syntax near the keyword 'on'."
    ]
  }
}

I ran the JSON through Lint and it was valid. Any insight on why?

The hosted feature layers are deployed from an ARCGIS Solution and there's bunch of existing layer and tables.

Re: Feature layer added to Feature Service does not show in AGOL

mikaël — Mon, 04 Dec 2023 13:24:29 GMT

What are you sending?

"Incorrect syntax near the keyword 'on'."

Seems to me like it's something you're sending to the API.

Re: Feature layer added to Feature Service does not show in AGOL

ANRGIS — Mon, 04 Dec 2023 13:35:26 GMT

Yep. It's JSON for adding a new layer using the addToDefinition parameter like @MarkC1 outlines. Works for newly created layer but not the one I want.

Re: Feature layer added to Feature Service does not show in AGOL

mikaël — Mon, 04 Dec 2023 14:16:29 GMT

Are you sure you are in the right thread? This is for successfully sent data through the API where the layer/table appears afterwards when querying the API but does not show on the AGOL interface.

Anyway, check what you are sending to the API and search for "on" as is suggested in your error message. Possibly a SQL query?

Re: Feature layer added to Feature Service does not show in AGOL

ANRGIS — Mon, 04 Dec 2023 15:37:07 GMT

You're right, not exactly the right thread but the thread has best explanation executing the add layer definition. "on" shows up about a hundred times, I don't think the error is helpful in this case. Thanks

Re: Feature layer added to Feature Service does not show in AGOL

AvinashDalvi_ — Fri, 26 Apr 2024 05:53:23 GMT

How to upload file while using AddToDefination API ?

Re: Feature layer added to Feature Service does not show in AGOL

BRENNEJM — Tue, 30 Jul 2024 10:59:31 GMT

For anyone else that finds this page and tries to follow the work around instructions for BUG-000145205, the instructions on that page are not correct. Those instructions have you create a new hosted feature layer (which defeats the purpose of using "Add to Definition"). Correct instructions below:

Open the hosted feature layer page that you added a new layer to
Click on any of the layers shown in the "Layers" section
Within that page on the right side, find and copy the rest service URL
Open the map you want to add the new layer to in map viewer
Go to Add > Add layer from URL
Paste the URL in the URL box ("ArcGIS Server web service" should get selected by default)
In the URL, change the ending number to the layer ID of the new layer you added
Click on Next
The layer should now be visible in the map

Re: Feature layer added to Feature Service does not show in AGOL

MitchellGrafstein — Tue, 26 Nov 2024 14:13:07 GMT

Finally found this after searching a bit yesterday when this same issue came up, so thank you @MarkC1 and others for your efforts here.

Appreciate this thread alerting me to take a look at the service's Data JSON via ArcGIS Assistant.

{ "id": 3 }, { "id": 4 }, { "id": 5 }

The "id" in this case corresponds to the sublayer or table in the service. If you click on a layer or table in the web interface, or if you drill down into a layer or table via the REST pages, you will see this "sublayer" information. https://blahblah/name_of_service/0 <--- the '0' in this example.

I added two new tables to my service using the addToDefinition REST API (described here and elsewhere.) These tables did not show up in the data JSON. (Sublayers/tables with an ID of 6 and 7.)

I edited the DATA JSON and added in the missing IDs (under "tables" since I was adding tables.)

{ "id": 6 }, { "id": 7 }

Doing the above added the two new tables back into the web interface which resolved my issue.

Few things to note - the "id" in this case corresponds to the sublayer/table in the item - these increment as you add them and normally start with layers and end in tables. So, if you had two layers and one table...

Sublayer 0: Layer 0
Sublayer 1: Layer 1
Sublayer 2: Table 0

I hope this helps add to the discussion.

As a general rule of thumb for this whole process, and there are examples of using addToDefinition elsewhere and within this thread - I suggest creating a mock service with new layers/tables in AGOL/Enterprise or hosted via ArcGIS Pro. Use the REST Admin pages to copy the layer or table formatting for an individual layer and the beginning format for the "layers" or "tables" part of the object from the mock service. I do not believe you need the database section of the JSON - just the section starting with the new layer/table ID and the formatting for the "layers" or "tables" part of the JSON.

Also, always make sure you make a copy of the full Admin JSON on your existing service. We back these up from time-to-time, as well. I would suggesting backing up your service to FGDB, as well.

After adding the new layer/table to the existing definition, if the layer/table does not show up in the Overview page - edit the Data JSON using ArcGIS Assistant as above.

This whole process is not for the faint-of-heart. I find it extraordinarily easy to mismatch the formatting somewhere and not have the addToDefinition take or something else like this can occur even if you do everything correctly. If there is an enhancement to be able to add a new layer or table to an existing service in AGOL or Enterprise via the web interface, which also allows copying the schema from an existing layer or table, I would gladly upvote!

I hope this helps.

Re: Feature layer added to Feature Service does not show in AGOL

Katie_Clark — Tue, 06 May 2025 14:09:38 GMT

Chiming in here, I was working on this issue yesterday. Check out my response to this post here, I shared a snippet of my code in which I update the Item Details to reflect the layer change. Hope it helps.