<p>如果有人正在寻找使用restapi从azure表存储查询表的python代码,下面是代码</p>
<pre><code>import requests
import hashlib
import base64
import hmac
import datetime
storageAccountName = 'my-account-name' # your storage account name
storageKey='my-account-key'# your storage account access key
url = 'https://' + storageAccountName + '.table.core.windows.net/table-name'
version = '2016-05-31' # x-ms-version
date = datetime.datetime.utcnow().strftime("%a, %d %b %Y %H:%M:%S GMT") #x-ms-date
parameters = 'table-name'
CanonicalizedResources = '/' + storageAccountName + '/' + parameters
CanonicalizedHeaders = 'x-ms-date:' + date
stringToSign = date + '\n' + CanonicalizedResources
# note the b64decode of the storageKey
signature = base64.b64encode(hmac.new(base64.b64decode(storageKey),
msg=stringToSign, digestmod=hashlib.sha256).digest())
headers = {'x-ms-date': date,
'x-ms-version': version,
'Authorization': 'SharedKeyLite ' + storageAccountName + ':' +
signature,
'Accept': 'application/json;odata=nometadata '}
# send the request
#print signature
response = requests.get(url, headers=headers)
print response
print response.headers
print response.content
</code></pre>
<p>更多操作请参考
<a href="https://docs.microsoft.com/en-us/rest/api/storageservices/fileservices/table-service-rest-api" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/rest/api/storageservices/fileservices/table-service-rest-api</a></p>