首页 > 解决方案 > 403 服务器在使用soapui 获取Azure 存储数据时未能对请求进行身份验证

问题描述

我正在尝试使用soapUI 获取天蓝色存储表数据。这在邮递员中工作正常,但在soapUI中运行时发生错误。

在 Postman 中使用的 URL:

https://storagename.table.core.windows.net/tablename?$filter=CalUId%20eq%20'040000008200E00074C5B7101A82E0080000000030D26B53FE24D6010000000000000000100000005CC0FFC3A3676E4CB70214BB089618AE'&sv=2019-10-10&ss=t&srt=sco&sp=rl&se=2020-06-07T23:32:15Z&st=2020-05-07T15:32:15Z&spr=https&sig=nlrNa1GXTqQPOaKP3X3kDQ056S%2Bwq9Fl1Y%2BTS8A%2FAdQ%3D

SoapUI 中的请求:

GET https://storagename.table.core.windows.net/tablename?%24filter=CalUId%2520eq%2520%27040000008200E00074C5B7101A82E0080000000030D26B53FE24D6010000000000000000100000005CC0FFC3A3676E4CB70214BB089618AE%27&sv=2019-10-10&ss=t&srt=sco&sp=rl&se=2020-06-07T23%3A32%3A15Z&st=2020-05-07T15%3A32%3A15Z&spr=https&sig=nlrNa1GXTqQPOaKP3X3kDQ056S%25%252Bwq9Fl1Y%25%252BTS8A%25%252FAdQ%25%253D&accept=text%2F*%3Bq%3D0.3%2C%20text%2Fhtml%3Bq%3D0.7%2C%20text%2Fhtml%3Blevel%3D1%2Ctext%2Fhtml%3Blevel%3D2%3Bq%3D0.4%2C%20*%2F*%3Bq%3D0.5 HTTP/1.1
Accept-Encoding: gzip,deflate
Host: storagename.table.core.windows.net
Connection: Keep-Alive
User-Agent: Apache-HttpClient/4.1.1 (java 1.5)

SoapUI 中的错误响应:

HTTP/1.1 403 Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
Content-Length: 437
Content-Type: application/xml
Server: Microsoft-HTTPAPI/2.0
x-ms-request-id: f3375700-4002-0012-0c1d-25d9df000000
x-ms-error-code: AuthenticationFailed
Date: Fri, 08 May 2020 09:46:33 GMT

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
  <code>AuthenticationFailed</code>
  <message xml:lang="en-US">Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
RequestId:a15bcaa7-a002-001a-5f0c-25c3d0000000
Time:2020-05-08T07:43:20.2731207Z</message>
</error>

标签: groovyazure-storagesoapuiazure-table-storage

解决方案


在请求中添加接受标头将解决此问题。

accept */*

推荐阅读