Como copiar dados de cotação do dolar da página do Banco Central do Brasil em formato CSV para o Banco de Dados Azure SQL utilizando o Power Automate
We will know the techniques:🔹Create flow with manually executed trigger (INSTANT CLOUD FLOW); Get data by HTTP request (NEW STEP, HTTP ACTION, GET, URL); Convert Base64 text to Plain text (COMPOSE, BASE64 TO STRING); Get lines of the CSV format (split, decode uri component); 🔹🔹🔹 🔹Filter Array items (FILTER ARRAY, LENGTH, TRIM); 🔹Get the values of the columns (SELECT, SPLIT, ARRAY); Insert records into Azure SQL Database table (AZURE SQL DATABASE, SQL SERVER CONNECTION, INSERT ROW ACTION); 🔹🔹Format date and decimal values (SPLIT, REPLACE, CONCAT, SUBSTRING).
Data Scientist and Consultant for Digital and Analytics Solutions
@fabioms