| HTTP_APPKEY | String | Required | | MIN: 32 | Common Put Your APPKEY |
| model_name | String | Required | | | Your table Model Name |
| logic | Enum | Optaion | and | Range: and/or | Where condition logic, logic=and for logical and, logic=or for logical or |
| wheres | ArrayJSON Format | Required | | | 批量条件，格式为：wheres=[第一组,第二组,……]。每一组where参数格式如下：
SQL WHERE condition, JSON format: [condition_1, condition_2, ...]
EACH condition: ["FIELD", "OP", "COMPARE_VALUE"]
- FIELD: Table field name;
- OP: such as >、>=、<、<=、<>、!=、EQ、GT、GE、LT、LE、NE、LIKE、NLIKE、IN、NIN、BETWEEN、NBETWEEN
- COMPARE_VALUE: The values that need to be compared, the format of the comparison value will be different. If the field is a numeric type, pass the numeric type, not a string.
Example: logic=and, where=[["id",">",9],["id","<=",10]], It means: id > 9 AND id <= 10 |
| change_field | ArraySeperated with , | Required | | | 待修改数值的字段名，多个字段名用英文逗号分割。change_value和change_field分割后的数量应当相同。 |
| change_values | ArrayJSON Format | Required | | | 批量待叠加的数值，格式是：change_values=["第一组","第二组","……"]。每一组格式为：正数表示相加，负数表示相减，需要传递有效数值。多个数值用英文逗号分割。每一组和change_field分割后的数量应当相同。示例：change_values=["1","2"]，更新多个值时的示例：["1,11","2,22"] |
| try_add_datas | ArrayJSON Format | Optaion | | | 批量的初始化数据，格式为：try_add_datas=[第一组，第二组，……]。当无更新时尝试创建的数据，仅当无更新且有传此参数时才会进行数据创建。此参数可用于初始化等操作。try_add_datas要么不传，要么需要和change_values的数量保持一致，对于不需要初始化的可以设置为NULL。此参数只用于初始化，不会再进行change_value的修改。 |