c# - 正确解码 Azure Blob SAS Url 以避免签名格式不正确错误

Question

为了在 Neo4j 中进行进一步处理，我需要对 SAS 编码的 URL 进行未转义，因为 Neo4j 会再次进行编码并导致 403 http 错误代码。

将 json 文件上传到 Azure Blob 存储并获取编码的 SAS Url 并使用 DecodeUrlString 对其进行解码的代码:

BlobContainerClient containerClient = new BlobContainerClient(absConnectionString, absContainerName);
await containerClient.CreateIfNotExistsAsync();

string fileName = fileKey + ".json";

// Get a reference to a blob
BlobClient blobClient = containerClient.GetBlobClient(fileName);

await using (MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(json)))
{
    response = await blobClient.UploadAsync(ms, new BlobUploadOptions
    {
        HttpHeaders = new BlobHttpHeaders
        {
            ContentType = "application/json",
            ContentEncoding = "UTF-8"
        }
    });
}

var absoluteUrl = string.Empty;
if (response.GetRawResponse().Status == 201)
{
    // 1 hour valid
    var originalUrl = blobClient.GenerateSasUri(BlobSasPermissions.Read, DateTimeOffset.UtcNow.AddHours(1)).AbsoluteUri;
    originalUrl = DecodeUrlString(originalUrl);
}


private static string DecodeUrlString(string url)
    {
        string newUrl;
        while ((newUrl = Uri.UnescapeDataString(url)) != url)
            url = newUrl;
        
        return newUrl;
    }

有时解码的 URL 会起作用，有时我会在 Neo4j 和浏览器中遇到此错误(取决于 SAS 编码的 URL，尤其是签名字段 => 以 &sig= 开头):

AuthenticationFailed Server failed toauthenticate the request. Make sure the value of Authorization headeris formed correctly including the signature.RequestId:552242c2-301e-003e-55d9-457612000000Time:2022-04-01T15:04:20.4824344ZSignature fields not wellformed.

原始 Blob URL:

https://[ACCOUNTNAME].blob.core.windows.net/[CONTAINER]/file.json?sv=2021-04-10&se=2022-04-01T10%3A10%3A46Z&sr=b&sp=r&sig=%2BTCB%2FwyaV5RfI7X7%2Fb7yoOlGZSzd5OjgXw2GDOCkB04%3D

解码后的网址:

https://[ACCOUNTNAME].blob.core.windows.net/[CONTAINER]/file.json?sv=2021-04-10&se=2022-04-01T10:10:46Z&sr=b&sp=r&sig=+TCB/wyaV5RfI7X7/b7yoOlGZSzd5OjgXw2GDOCkB04=

Neo4j 的问题描述如下:apoc.load.jsonParams with Azure Blob signed URL leads to http 403 error

如何正确转义 SAS URL 以避免此类错误？

Answer 1

现在 Neo4j v4.4.7 和 apoc v4.4.0.5 版本已经解决了这个问题。