Forum Discussion

LuccaFaro's avatar
LuccaFaro
New Member
7 years ago

How to get data from post request?

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?

3 Replies