Forum Discussion

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

Anonymous

Not applicable

4 years ago

Hi nicolast29,

I modify the code to split the URL to root and relativepath and add a query to the connection. You can try to use the following query if they suitable for your requirement:

let
    vToken = "Bearer " & "TokenXXX",
    vSecret = "SecretXXX",
    vsociety = "XXXX",
    rootURL = "https://api.myunisoft.fr/api",
    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,
                    Query = [
                        export_type = "1",
                        from = "2021-01-01",
                        to = "2021-12-30"
                    ]
                ]
            )
        )
in
    Source

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code Chris Webb's BI Blog (crossjoin.co.uk)

Regards,

Xiaoxin Sheng