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.
