API PUT (Update) - Edit Cells instead of Replace

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.


Please sign in to leave a comment.