Web.Content DataSource Error

[Bessonnizza1992]

Hello, there!

I try to get data from web service and get an error:

let
            data = Json.FromValue([token="token",dateFROM="2020-08-01",dateTo="2020-09-01",format="JSON"]),
            headers = [#"Content-Type"="application/json"],
            web = Web.Contents("https://online.petrolplus.ru/public-api/v1/transaction-list", [ Content = data, Headers = headers, ManualStatusHandling = {404, 400}]),
            result = Json.Document(web),
            #"Converted to Table" = Record.ToTable(result)
        in
            #"Converted to Table"

DataSource.Error: The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF
Details:
https://online.petrolplus.ru/public-api/v1/transaction-list

Can somebody explain me what i can do to exclude this error?

Try to uwrap VPN and block cookies, without result:(

[Bessonnizza1992 · Accepted solution]

Solution:

1. Download СharleskProxy, run it.

2. Set SSL Proxying settings for yours site

3. Block cookies setting for you site

4. Enjoy data 🙂

[Bessonnizza1992]

Fiddler Web Debbuger tell me than request returns me data (2654) and http code 200 (ok):

But PQ can't transform it.