WEB API Power BI / The server committed a protocol violation

[Ronald123]

Hello,

Did anyone have a solution or workaround to import the web api of Bitstamp?

https://www.bitstamp.net/api/v2/order_book/xrpusd/

Error: 

Details: "The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF"

[magnifybi]

I am desperate to find a solution to this issue!

Please respond if there is one, or a workaround for getting data from these sites.

Thanks,

Jon

[Ronald123]

Anybody?

[magnifybi · Accepted solution]

Ronaldo, I think the site blocks this type of access via its cookie policy. I saw that someone managed to get round it with a VPN, but I wasn’t so lucky.

Think it needs to be scraped via a script.