Skip to main content

Notifications

Community site session details

Community site session details

Session Id : jRSc6Mq7Dsju0zOdDCVFkB
Power Automate - General Discussion
Unanswered

export oracle query into csv file

Like (0) ShareShare
ReportReport
Posted on 8 Mar 2024 15:57:39 by 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:
  • sunamiwave Profile Picture
    4 on 11 Mar 2024 at 13:54:34
    Re: export oracle query into csv file

    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.

     

  • DJ_Jamba Profile Picture
    2,815 Super User 2025 Season 1 on 09 Mar 2024 at 14:42:04
    Re: export oracle query into csv file

    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']

     

  • DJ_Jamba Profile Picture
    2,815 Super User 2025 Season 1 on 09 Mar 2024 at 14:36:38
    Re: export oracle query into csv file

    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?

  • sunamiwave Profile Picture
    4 on 08 Mar 2024 at 16:30:46
    Re: export oracle query into csv file

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
Pstork1 Profile Picture

Pstork1 18 Most Valuable Professional

#2
rpersad Profile Picture

rpersad 16

#3
David_MA Profile Picture

David_MA 10 Super User 2025 Season 1

Overall leaderboard
Loading started