Forum Discussion

Bessonnizza1992's avatar
5 years ago
Solved

Web.Content DataSource Error

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:(

  • Solution:

     

    1. Download Ð¡harleskProxy, run it.

    2. Set SSL Proxying settings for yours site

    3. Block cookies setting for you site

     

    4. Enjoy data 🙂

     

2 Replies

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

    But PQ can't transform it.

  • Solution:

     

    1. Download Ð¡harleskProxy, run it.

    2. Set SSL Proxying settings for yours site

    3. Block cookies setting for you site

     

    4. Enjoy data 🙂