Forum Discussion

artikrh's avatar
artikrh
New Member
3 years ago

POST requests in M Language without any parameters

Hi, I have this REST API endpoint which expect a HTTP POST request in order to download a CSV file.

 

However, the issue with PBI here is that this POST request does not have/expect any parameter as input, and in order to denote a POST request in M language according to some previous threads, I have to specify Content = Text.ToBinary("") within Web.Contents to let PBI know it's a POST and not GET.

 

Unfortunately, this just triggers another error:

DataFormat.Error: We found extra characters at the end of JSON input.
Details:
Value=,
Position=8

 

If I remove this line (therefore script does a GET request), for some reasons I get an "Access to resource is forbidden" message (for this particular API call, for the ones with GET expected it works just fine).

 

How can I proceed further with this "extra character" error? Many thanks in advance.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  artikrh ,

    Are you trying to connect to one REST API? If yes, could you please provide the related REST API info? And the following is the thread which has the similar problem as yours, hope it can also help you solve the problem.

    DataFormat.Error: We found extra characters at the end of JSON input

    It should be #"Authorization" in Headers 

    let
    Source = Json.Document(Web.Contents("xxx", 
    [
        RelativePath = "xxx",
        Content=Text.ToBinary(""),
        Headers=[#"Content-Type"="application/json", 
        #"Authorization"="Bearer xxx"
        ]  
    ]))
    
in
    Source

    Best Regards