有没有什么方法可以通过PowerShell而不是JS文件来定义简单的表?
任何通过CSV创建简易表格的示例或有关通过JS文件定义的文档都会很有帮助。
发布于 2018-04-17 17:59:49
我们可以使用Rest API创建Easy表并将数据导入到easy表中。我用Postman进行了测试。
创建简易表格
https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Web/sites/tomtestmobile/extensions/Microsoft.Mobile.Management/tables?api-version=2014-11-01
正文样本:
{"name":"tableName","permissions":[{"name":"read","level":"anonymous"},{"name":"insert","level":"anonymous"},{"name":"update","level":"anonymous"},{"name":"delete","level":"anonymous"},{"name":"undelete","level":"anonymous"}],"links":[],"insert":"","update":"","delete":"","read":"","undelete":"","hasCustomPermissions":false,"extendedSettings":{"softDelete":true},"columns":[{"name":"Team","type":"String"},{"name":"Product","type":"String"},{"name":" name","type":"String"}]}
导入数据
https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Web/sites/tomtestmobile/extensions/Microsoft.Mobile.Management/tables/JustForTest3/data?api-version=2014-11-01
正文样本:
{"csvData":"Team,Cover Product, name\r\nCloud,Azure ,tom"}
请使用以下代码在Powershell中调用rest API。如何获得授权,你可以参考这个video。
$body = "jsonstring"
$hdrs = @{}
$hdrs.Add("Authorization","Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1d...")
Invoke-RestMethod -Uri $url -Method Post -Body $body -ContentType 'application/json' -Headers $hdrs
https://stackoverflow.com/questions/49810749
复制相似问题