编辑Easytable Azure的数据(Edit Data of Easytable Azure)

编辑Easytable Azure的数据(Edit Data of Easytable Azure)

无论如何修改Easytable Azure中的数据？

例如，我想将第一行的文本更改为“测试23/2”。 怎么做？ 此外，我想将删除从true更改为false。 知道怎么做吗？

Is there anyway to modify the data in Easytable Azure?

For example, I want to change the text for the first row to "testing 23/2". How to do that? Besides, I want to changed the deleted from true to false. Any idea how to do that?

最满意答案

据我所知，如果你想使用简易表，你必须连接到数据库。 因此，如果要更改easy表中的数据，可以在azure sql数据库中找到该表并进行修改。

您可以在数据连接标记中找到您的数据库。 此外，我建议您可以安装MMSE并使用它连接到您的azure sql数据库，然后您可以使用MMSE修改它。

更多细节，您可以参考以下链接和查询：

链接： https ： //docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-ssms

脚步：

1.连接到azure sql数据库

2.选择表格并进行编辑

此外，我建议您也可以使用Restful API的send patch方法来更新行数据。

---

更新：

这是执行图像：

结果：

此外，正如我所说，您可以使用zumo-api向easy表发送请求以更改表的结果。

首先，我建议您查看easy table的权限。

您需要设置更新是允许匿名访问。

然后你可以使用fiddler发送请求。

Method:PATCH URL: http://YOURSSITENAMEHERE.azurewebsites.net/Tables/text/YOURROW’SID Head: Accept: application/json Content-Type: application/json Content-Length: 32 ZUMO-API-VERSION: 2.0.0 Host: YOURSSITENAMEHERE.azurewebsites.net Content: {"text":"bbbl","complete":false} Yours maybe {"TEXT":"bbbl","COMPLETE":false}

如下图所示：

结果：

As far as I know, if you want to use easy table, you must connect to a database. So if you want to change the data inside the easy table, you could find the table in the azure sql database and modify it.

You could find your database in the data connection tag. Besides, I suggest you could install an MMSE and use it connect to your azure sql database, then you could modifty it by using MMSE.

More details ,you could refer to follow link and query:

Link: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-ssms

Steps:

1.connect to azure sql database

2.Select the table and edit it

Besides, I suggest you could also use send patch method by Restful API to update the row data.

---

Update:

Here is the execute image:

Result:

Besides, as I says you could use zumo-api to send request to the easy table to change the table’s result.

At first ,I suggest you could check the easy table’s permission.

You need set the update is allow anonymous access.

Then you could use fiddler to send the request.

Method:PATCH URL: http://YOURSSITENAMEHERE.azurewebsites.net/Tables/text/YOURROW’SID Head: Accept: application/json Content-Type: application/json Content-Length: 32 ZUMO-API-VERSION: 2.0.0 Host: YOURSSITENAMEHERE.azurewebsites.net Content: {"text":"bbbl","complete":false} Yours maybe {"TEXT":"bbbl","COMPLETE":false}

Like below image shows:

Result: