How to get data from post request?

[LuccaFaro]

Hello everyone,

I'm trying to get the .cvs file from https://www2.cetip.com.br/TitulosCRI into Power BI automatically. In order to do download the file manually, you must first click in the button that says "Enviar" (send, in portuguese) and then in the button that says "Exportar para CSV" (export to CSV).

My first attempt was to find out the download link for the file, but it turned out to be the webpage link itself.

Reading about it, I learnt it might be the case that when I click the buttons, I'm making HTTP post requests. I tried to find some examples of Power BI code to make this kind of request, but my lack of knowledge in the subject made it hard to understand the code provided.

By analyzing the page's source code, I found the code below, which might have something to do with the request:

<input type="submit" name="btExportarCSV" value="Exportar para CSV" id="btExportarCSV" class="button">

Can anyone help me understand how can I get this file automatically using power BI?

[Anonymous]

Have a look at this post on SO:

https://stackoverflow.com/questions/24757285/how-can-i-find-the-source-or-link-behind-a-button-on-a-...

Best
Darek

[LuccaFaro]

Hi darlove,

Thanks for the help! After reading the post, I can see that my case is definetly a post resquest!

Can this kind of request be made using Power BI? The code on SO is for wget...

Best

Lucca

[Anonymous]

No idea. Never had to do that....

Best
D.