Hi,

what i tried in advance editor is:

let
Source = Csv.Document(Web.Contents("http://localhost:8080/BundleService-1.0.0/v1/bundles/Master/data/name:excel" & Uri.EscapeDataString("/") & "derived/1.0.0/TabName/TabName"),[Delimiter=",", Columns=15, Encoding=1250, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers"= Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#"Promoted Headers"

but still i have error....

Please help,
Jacek

Try to encode the entire string:
Uri.EscapeDataString("http://localhost:8080/BundleService-1.0.0/v1/bundles/Master/data/name:excel/derived/1.0.0/TabName/TabName")

Thank you! 

I will test it - waiting for developer when system will be refreshed. 

Best,
Jacek

Hi, 

i tested and it is not working. 
It is changing whole url to encoding signs and trying to get data from encoded string. 

Where problem is that i have to not send PQ request with %2F. 
IT should send "%2F" as text, not changing anything - problem is that PQ is changing it for "/" before my Server - and this cause error. 

I didnt find any solution on web and i am afraid that this is very bug bug in PQ --> i would like to inform about it to microsoft. Where can i do this?

Best,
Jacek

Where is the csv name in your url?
Not seeing it in any of your posted code.

Web.Contents is NOT Folder.Files, in case you want to get multiple csv files from a web folder address, will not just give you a list of csv files.

Try step by step:

Source=Web.Contents("http://localhost:8080/BundleService-1.0.0/v1/bundles/Master/data/name:excel/derived/1.0.0/TabName/TabName"),

then analyze the response, take actions according to what the web page returns.

Web.Contents will return a html structure, you need to navigate to the html container that holds the files...

Hi Catalin,

i have csv on server provided by java environment. CSV is sitting on server disc with normal folder and subfolders structure.

On server i am getting folder url but within folder i have subfolder which PQ doesnt know how to read. It lost when i want to send request "2%F" because PQ is changing it automatically without any other possibilities (like sending just clean url string without encoding automatically). 

So when i do not have subfolder in folder url is working - i have just slashes, PQ read web contents like CSV and importing. 
But issue is when i want to pass just string 2%F which has to be send to url and server should decode it, not PQ....

I want to write about lacking of this feature to Microsoft.

Best,
Jacek