Forum Discussion
CSV from a website to Bi
It depends. When you hover over the button (or press it), do you see a URL that gives the full path to the file (i.e., ends in .csv)? If so, you can probably use that path in the Web.Contents( ) function to scrape the file from the site.
Here is an example url that works in Web.Contents( )
https://people.sc.fsu.edu/~jburkardt/data/csv/addresses.csv
Pat
Hi Syndicate_Admin,
Based on my experience, fetching files by immitating HTTP request sent by a button on intranet is at least painful even if possible at all as it involves setting up request details which are not simple to get in PQ. After all this is data manipulation, not general purpose language.
Try what mahoneypat suggested, but buttons are rarely contain address of the file, I would imagine that this is some end-point trigger address for sending the file back over HTTP.
It may be simpler if you could find out (from your IT team, I guess) where is the file stored andif you can have access to this location and then use a conventional connector to get the data.
If this is not an option, you can play with the Developer functionality of your Internet browser (I am sure this can be summoned by F12 button on both Edge and Chrome). There is a section relating to network calls. You can try to trace what is happening when you pressing the button there and try to replicate the setting in the Web.Content (search on Internet how to set headers, etc.).
Kind regards,
John