Azure SQL Video
75 page views
1186 video views
2024, April 25, Thursday

Copy CSV data from the Internet in Power Automate for Azure SQL

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).