Possible to update rows with data only accessible via API call?
"Columns" look different (dates vs strings vs numbers); the values within a given column all look the same (eg, all are dates)
"Rows" look similar, but with different values.
A "table" is a collection of any number of rows, but of a fixed number of columns.
An API call must go to some application language code (Java, PHP, or ...) which interprets the yucky REST syntax and proceeds to, for example, issue a SELECT (for a GET REST call) or INSERT/UPDATE (for a PUT), etc.  You must write this app code; MySQL does not understand REST.
I suspect REST is so restrictive that a PUT is not allowed to return what a GET would return.  So, perhaps you have to do 2 API calls.  This also happens with talking to MySQL -- an INSERT or UPDATE merely says 'ok' or 'err'; you then need to do a SELECT to fetch stuff.


I hope this helps.  To continue this Q&amp;A, please provide


More details about your application.
Whether you have settled on an app language to code REST in.
Some hints of what column types your table(s) has.


(Otherwise, it will probably be closed as "too broad".)