API Update records

[Pethipojquis56]

I would like to update multiple rows from a different table, should i just increment a column? is that the best way to do it with API? is updating everything on the table the same as updating 1 row, sync wise?

{
"Action": "Edit",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Timezone": "Pacific Standard Time",
},
"Rows": [ <<START: SELECT(perz made materoals[Material ID], [Supplier ID]="c9Hvc9wa")>>
{
"Material ID":"<<[Material ID]>>",
"Materials": "teat"

}
<<END>>
]
}

[dbaum]

I'm not sure exactly what you're asking about.

---

@Pethipojquis56 wrote:

should i just increment a column?

---

Maybe you're asking about a technique that is sometimes called a quick update system? That's certainly a valid approach for triggering recalculation of one or more rows.

---

@Pethipojquis56 wrote:

is that the best way to do it with API?

---

It's certainly possible to do that via API. Consider also using instead a combination of data actions like execute on a set of rows and update column values in a row.

---

@Pethipojquis56 wrote:

is updating everything on the table the same as updating 1 row, sync wise?

---

The more rows being recalculated, the longer it takes to do so, and the longer it takes to sync the updates between the cloud and a user's device.

If your scenario entails updating rows with new values that don't trigger recalculation of other columns, that's typically faster.