Hi Everyone,
I'm having an issue in AGOL when creating a Joined Hosted Feature Layer View in which I get the following message:
"Unable to add feature service definition."
The reason for the join is to connect the following two hosted Feature Layers:
- A Static Polygon Layer
- A Dynamic Survey123 survey response Layer
The join will be a 1 : M with the Point data creating a new feature in the Polygon Feature Layer, potentially creating several duplicates of polygon features, as in this picture:
Join Attribute is a String e.g. TY002357
This seems to fit the intended remit in Esri documentation:
Using this joined data, updated survey information can dynamically appear on a dashboard that references this data. For the intended display / filtering implemented in the dashboard, the polygon data is the recipient of the I : M :Joined Features.
The join process appears to work in the following 2 instances:
- If I export a static copy of the Survey123 feature layer and reimport to a new hosted feature layer, using the static Survey123 data to join
- If I publish the Survey123 using Web Designer, rather than Survey123 Connect
For the workflow I'm working on, using Survey123 Connect is necessary to enable the custom queries performing geocoding operations when the survey is submitted, so I was wondering if there were any known gotchas/bugs/tricks for getting a Survey123 Connect Survey to be part of a Joined Hosted Feature Layer View.
I've not seen anything in the documentation that indicates that this is not supported, so hopefully there is a way to get this to work.
Thanks!
Dean
**** Update : 2023/07/09 : I have tested this further and the error with the join view only appears to occur if the survey contains a repeat in the Survey123 Connect design. Without the repeat in the survey, it appears to join successfully, so is not a Survey123 Connect issue, as much as it appears to be a repeat issue.