Latest Contributions by DavinShokes1

Through the admin REST API, I've had some success creating 1:M relationships for existing hosted feature services. Why not just overwrite the service you ask? There is a bug during sd file creation in ArcMap, making republishing not an option. I start out by updating the layer definition for the layer with the origin field via - https://services.arcgis.com/<Organization ID>/arcgis/admin/services/<ServiceName>.FeatureServer/<layer ID>/addToDefinition In this case, the layer id is 0 and the origin field will be GlobalID. Here is what I add to the definition: {   "relationships" : [     {       "id" : 0,       "name" : "Layer1sInLayer0",       "relatedTableId" : 1,       "cardinality" : "esriRelCardinalityOneToMany",       "role" : "esriRelRoleOrigin",       "keyField" : "GlobalID",       "composite" : false     }   ] } The second layer has an id of 1 and the destination is a GUID field named "RelatedGUID" This is what I add to the layer definition: {   "relationships" : [     {       "id" : 0,       "name" : "Layer1sInLayer0",       "relatedTableId" : 0,       "cardinality" : "esriRelCardinalityOneToMany",       "role" : "esriRelRoleDestination",       "keyField" : "RelatedGUID",       "composite" : false     }   ] } After running these two, the relationship appears valid in the ArcGIS online map viewer and Collector for ArcGIS. Some things I've noticed: Must be done on both layers separately. I Could not add both layer parts to the definition of the entire feature service. Sometimes deleting relationships works. Other times I am unable to delete from the definition with a message saying a specific contraint doesn't exist. I do not see any sql server constraints visible from the REST service directory. It doesn't seem as though relationship names or id's need to match for both layers. Duplicate id numbers can be added to a layer and WILL BREAK IT! I've only tested GlobalID to GUID but assume Integer to Integer would work. I have not tested setting composite to true I have not tested many to many I have not had luck manipulating relationships with updateDefinition My question for anyone reading: Is there another way to add/modify/delete relationships to existing services? I highly doubt this is supported and there isn't any REST API documentation. Hopefully AGOL admins find this helpful. Relationships can be so powerful in a mapping application. It's too bad that we have to go to such extremes to apply them to hosted services when you can simply right-click create relationship class on the data behind ArcGIS Server services. Maybe enough people will break their services and we'll get a tool to manipulate hosted relationships! ... View more

The hydrant example from the blog post at Related Tables – Exploring New Ways to use Collector for ArcGIS | ArcGIS Blog, nests a 1:M relationship under another 1:M relationship. It is laid out like so: Layer--> Table --> Table. I'm trying to use a service with all layers instead of the tables. Has anyone successfully used Collector Offline with a Layer --> Layer --> Layer  relationship based on globalIDs? I can download web maps in Collector for ArcGIS 10.3 and 10.3.1 and create features for the first two layers. However, Collector always crashes when attempting to create a feature for the deepest layer. My service contains lines related to many points, each point related to many points. Any working example with just 3 layers would help point me in the right direction. Thanks, Davin ... View more

I have what appears to be a simple requirement for my Collector for ArcGIS users. Simply put, I need field1 to be calculated as field2 X field3 upon feature insert or update. Is this possible to do outside of Collector for ArcGIS? Scenario: User submits new point and fills in field2 and field3 User views feature popup and sees field1 has been populated Thank you. ... View more

The REST API shows the following example to query: "where" : "NAME LIKE 'A%'" I'm trying to only label features with values. I've tried to update the definition of the service and the specific feature layer with: "where" : "NAME is not null" . But the labels disappear completely. I've also tried to use the the example esri provides: "where" : "NAME LIKE 'A%'" However, something happens in the background to encode the value: "where":"NAME LIKE \u0027A%\u0027" How do I set labelingInfo where:"Field is not null" ? ... View more

The interface tells you to name the replica, but ignores input. The random string for the names make it incredibly difficult to script automation. Here is what I get with sync model=none: FileGDB: C:\Downloads\cce93b7ebc4c47d18f656ae7ea613ce8\447be11bdf3c4a64b1c229caada76d6a.gdb SQLITE: C:\Downloads\a021300b5c8f445eac500e01fe713e07.geodatabase JSON: C:\Downloads\748a4e8ab624424ebeee38f14bbd1d95.json The zip name is even different from the gdb! The purpose of the replica name alludes me.What value does requiring a Replica Name provide? Additionally, what is the point of generating a random name for the file that has no sync model and you cannot search through the  replicafiles directory? ... View more