createReplica not maintaining table-to-table relationships

jmidtlyng — Mon, 27 Jan 2025 16:26:03 GMT

We're using https://developers.arcgis.com/rest/services-reference/enterprise/create-replica to build a replica with the following hierarchy:

layer -> child layer -> child table 1 -> child table 2

layer relates one to many to child layer

child layer relates one to many to child table 1

child table 1 relates one to many for child table 2

When we set a query on the top-most layer then we only get related data for child layer and the related data (to child layer) for child table 1. However, child table 2 has no data. We would expect child table 2 to have the data related to child table 1 cascading from the chain of relationships to the query on layer.

Does anyone have experience writing a createReplica query to do this? Is this possible with syncOptions?

topic createReplica not maintaining table-to-table relationships in ArcGIS REST APIs and Services Questions

createReplica not maintaining table-to-table relationships