Hello,
My team and I received a request from another department to take a copy of another organization's AGOL hosted Survey123 form, add some fields to it, and publish it to our own AGOL as a hosted Survey123 form. This survey contains several relationship classes based on GlobalIDs.
The hang-up is that they also requested all data to be regularly appended back into the other organization's hosted feature layer. The other organization has multiple editors for this survey so overwriting their service is out of the question.
Through some trial and error I discovered that within the Append tool, if you set it to preserve GlobalIDs, it will say it succeeded with warnings and "function not implemented" and no new rows in the table. Further searching online tells me that preserving GlobalIDs isn't supported for appending to a hosted feature layer.
I tried following the steps in this post. https://community.esri.com/t5/arcgis-online-questions/preserve-global-id-during-append-into-hosted/td-p/1211159 Down towards the bottom it gives instructions on how to append without overwriting the hosted feature layer. After downloading the map in Pro (step 3 of the link above) I can run the Append tool successfully and it preserves the GlobalID. But when trying to sync the map...nothing appears in the hosted feature layer.
So if the following statements are true:
1. Append cannot preserve GlobalIDS when applied against a hosted feature layer or any service.
2. GlobalIDs are required for the relationship classes to work.
3. Cannot overwrite the other organization's hosted feature layer for their Survey123 form.
then I'm stumped on how to proceed.
Has anyone else built a workflow where one hosted feature layer is appended into a different hosted feature layer without overwriting and while preserving GlobalIDs?
Many thanks,
Caitlin