Store rows from CSV attachment to postgres table

(0) Share

Report

Posted on by Moonking

Hello All,

I am new to this so finding it difficult. I have the basics figured out but don't know how to put it together.

I get a CSV report everyday and I want to take all the rows and insert them into the table in a postgres DB in GCP. I have created a table from csv file, I have connection to the table is working but I am not able to figure out how to load individual row of CSV data table to a row in postgres table.

Please ignore "Create File" as that is just to keep a copy on one drive.

Seems like Insert Row requires data, but how do I extract data for individual column from the CSV table row?

All responses (1)

Answers (1)

Verified answer

v-chengfen-msft on at

Like (0)

Report

Re: Store rows from CSV attachment to postgres table

Hi @Moonking ，
The CSV file is a comma-separated values file
Line breaks separate rows and commas separate columns
Here is a test for your reference:
Here is CSV file:

Here is test:
Put data lines into an array by line breaks, then turning [,] into [; ]

Note:
Parse JSON needs to get the schema:
1.You need to test it first to get Select's Body

2.Put Select's Body in

Finally
Here is result :
You can load a single row from a CSV data table into a row in a postgres table.

Here is a link for you reference:
Parse CSV File Using Power Automate (c-sharpcorner.com)
Best Regards
Cheng Feng