Power Query，使用表单数据发出http POST请求 [英] Power Query, make http POST request with form data

问题描述

我有一个REST API，该API仅接受带有表单数据的POST请求.

I have a REST API, which accepts only POST requests with form data.

我知道在Power Query中，JSON请求是这样的:

I know that in Power Query JSON requests are like this:

let
    url = "https://example.com",
    body = "{ ""first_param"": ""AAAAA"",  ""second_param"": ""BBBBBB""}",    

    Source = Json.Document(Web.Contents(url,[ Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(body) ] ))
in
    Source

如何发送表格数据?

推荐答案

使用Uri.BuildQueryString和Json.Document

let
    url = "https://example.com",
    body  = "{ ""first_param"": ""AAAAA"",  ""second_param"": ""BBBBBB""}",
    Parsed_JSON = Json.Document(body),
    BuildQueryString = Uri.BuildQueryString(Parsed_JSON),
    Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(BuildQueryString) ] ))
in
    Source

顺便说一句，您最好将 body 直接构造为 record ，避免使用文本字符串和双引号的双引号)

btw, you'd better construct body directly into a record, avoiding text string and double of double quotes )

这篇关于Power Query，使用表单数据发出http POST请求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！