You’re offline. This is a read only version of the page.
Hi
I tried referencing this article but it does not appear to work for me.
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.
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.
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?
Share
Report
All responses (
Answers (
body('Execute a Oracle query')?['ResultSets']?['Table1']
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?
Here's something else i tried which doesn't appear to work, which was a suggestion from the above link
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
