Can I add a standalone table to existing feature service

Question

In AGOL I have a hosted feature service that supports a couple different maps and apps.  A new business requirement has surfaced that requires adding a new standalone table to the existing hosted feature service.  Is such a thing possible?  If so, how?  If not, what are some suggestions for doing this - perhaps add the standalone table as a separate hosted feature layer?

Trippetoe · Answer

Hi Micah.

Thanks for the heads up on the Attachments.  With that warning and some of my other concerns about data loss, i am looking at alternatives like creating a new hosted feature service to keep the old and new data separate

MicahBabinski · Answer

Hi Tom,

Since you have attachments, heads up that you might need to export the data from the hosted feature service. Go to the item details for the service and choose the Export option (to file geodatabase). That should retrieve all of the data and attachments in your service. I've had issues (10.4) creating local copies of hosted services that use GUIDs (which are used in attachments).

As for direct editing of stand-alone (not related) tabular records, I don't think it's possible in the default AGOL map viewer, but you can do this by going to the item details of your feature service containing the table, go to the data tab, and then you will have the ability to edit the tabular data. There may be a widget that you could configure implement in web application builder, but I'm not sure.

Micah

Trippetoe · Answer

Thank you all for your responses. I am going to group my responses here.

Guido van der Kolk - i am interested in adding a true stand alone table - no joins and no relates to the feature class. I would like to be able to create, edit, view records in that standalone table

Adrian Welsh‌ - thank you for the links. My biggest concern is adding the table to an existing AGOL hosted feature service and preserving the existing data

Micah Babinski‌ - You are right; my biggest concern/interest is preserving the existing data. We have years of records, photographs, etc.  When i saw the warning from ArcMap that over-writing an existing service erases the data, i got very nervous.  So i created a very small sample data set, published that to AGOL, and then went through the process to over-write that service while adding in the new table. It seemed to work as desired.

I didn't know about the 'local copy' approach you suggested so i will give that  a try this morning with a somewhat bigger data set.

Thanks again to everyone for your responses.

ps - i know its probably a new thread, but i'll ask here just in case...... is there a way to create a new record in a standalone table, i.e. a table that is not related/joined to a feature class in a hosted feature service?