0

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.

0 comments

Please sign in to leave a comment.