Problem: When updating a massive table (133k cells) there is a large processing burden to move data from our XML data source into the JSON upload. The only way to update a table via the API is to overwrite the entire table with a new one. There is no ability to recognize a Primary Key in the data table and do Update/Append operation, as the API PUT command replaces the Data Source.
Affected Users: Data Source - Manual Upload users
Environment: FormSpaces - Data Sources
Suggested Solution: Allow users to designate a Data Source Column as a Primary Key, and alert the user if there are duplicates. Add a method for PUT to include "update" so when the body does not include the original complete table, rows and columns will append to the existing Data Source.