Forum Discussion

nicolast29's avatar
nicolast29
Helper V
4 years ago

post request

Hi folks, I wish to connect to our new software provider via Api https://docs.api.myunisoft.fr/#b953be72-03e7-4be6-8638-d14025bdab46   I have no problem to make get request, but the post didn't wo...
Need Help
nicolast29's avatar
nicolast29
Helper V
4 years ago

I make further search, 

It seem that i should have a body in order to make a POST request

https://developer.genesys.cloud/forum/t/connecting-with-power-bi/14366

 

but in my case i should send a empty body

I try by adding this 

vbody = "the post method",

 

Source =
Json.Document(
Web.Contents(
//vURL,
rootURL,
[
Headers = [
Content=Text.ToBinary(vbody),
Authorization = vToken,
#"X-Third-Party-Secret" = vSecret,
#"society-id" = vsociety,
#"Content-Type" = "application/json"
],
RelativePath = relativePath,
Query = [
export_type = "1",
from = "2021-01-01",
to = "2021-12-31"
]
]
)
)


in
Source

 

 

but i still have a error :

Expression.Error : Désolé... Nous n'avons pas pu convertir une valeur de type Binary en type Text.
Détails :
Value=[Binary]
Type=[Type]

 

 

It is the same with Content=Text.ToBinary("")

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi nicolast29,

In fact, 'Content' is an optional parameter in web connector and it should list at the same level as 'Header':

let
    vToken = "Bearer " & "TokenXXX",
    vSecret = "SecretXXX",
    vsociety = "XXXX",
    rootURL = "https://api.myunisoft.fr/api",
    body = "{}",
    relativePath = "/v1/export/FEC",
    //vUrl = "https://api.myunisoft.fr?export_type=1&from=2021-01-01&to=2021-12-30",
    Source =
        Json.Document(
            Web.Contents(
                rootURL,
                [
                    Headers = [
                        Authorization = vToken,
                        #"X-Third-Party-Secret" = vSecret,
                        #"society-id" = vsociety,
                        #"Content-Type" = "application/json"
                    ],
                    RelativePath = relativePath,
                    Content = Text.ToBinary(body),
                    Query = [
                        export_type = "1",
                        from = "2021-01-01",
                        to = "2021-12-30"
                    ]
                ]
            )
        )
in
    Source

I'm not so sure which type of content your API requirement, maybe you can check the API document and add the corresponding JSON strings in the 'body' step.

Regards,

Xiaoxin Sheng

  • nicolast29's avatar
    nicolast29
    Helper V
    4 years ago

    i still have a problem

    I am working on 

    Thanks