web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate export oracle query in...

Power Automate

Unanswered

export oracle query into csv file

(0) Share

Report

Report

Posted on by sunamiwave

4

Hi

I tried referencing this article but it does not appear to work for me.

Solved: Re: Place Oracle Query in CSV File -- Getting Erro... - Power Platform Community (microsoft.com)

In message 5 of the thread above they are able to select "Query Results" in the From section, which is the output of the Oracle database.

I however am unable to do so. I did test my flow, and I have verified that my Oracle query does create output, the first few lines are as follows

{
"statusCode": 200,
"headers": {
"Cache-Control": "no-store, no-cache",
"Pragma": "no-cache",
"Transfer-Encoding": "chunked",
"Vary": "Accept-Encoding",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"x-ms-request-id": "23bea97c-642d-4b82-9e25-50fb73e5d18b",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"x-ms-connection-gateway-object-id": "ee38c3e5-5bb4-404e-aae9-dda69433d7ac",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Fri, 08 Mar 2024 15:41:00 GMT",
"Content-Type": "application/json; charset=utf-8",
"Content-Length": "67031",
"Expires": "-1"
},
"body": {
"OutputParameters": {},
"ResultSets": {
"Table1": [
{
"OUTAGE_ID": "XYZ",
"PLANNED_START": "2024-02-07T07:00:00",
"PLANNED_END": "2024-02-07T15:00:00",

Can anyone offer any assistance? I'm extremely new to powerautomate , powerapps , powerbi, etc.

I'm generally trying to query from an oracle database, and dump into a CSV file.

thanks in advance.

Categories:

query-results-fai...

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

sunamiwave 4 on at

Like (0)

Report

Here's something else i tried which doesn't appear to work, which was a suggestion from the above link

oracle_query_resu...

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

Hi @sunamiwave
"Query Results" does not exist in the Oracle output example you provided.
What is in the From property for action Create CSV table?

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Missed your screenshot!
You might have to map fields via a select but first, can you try this in the From property of action Create CSV table?
body('Execute a Oracle query')?['ResultSets']?['Table1']

Was this reply helpful? Yes No
sunamiwave 4 on at

Like (0)

Report

Hi

thanks for the tip, but I had to add a step to Parse the JSON. Basically the results of Query an Oracle database produces JSON. I added in that JSON to produce a SCHEMA in the Parse JSON step. afterwards i was able feed that into Create CSV, and then dump it to a file in sharepoint.

csv-example.png

Was this reply helpful? Yes No

Join the conversation