Answered

Help with Oracle connector, getting data

(0) Share

Report

Posted on by phillippoole

I have a very simple Power Automate Flow and am using the Oracle "Get Rows" connector and when it runs, it is successful but there is no data.

It is simple and runs successful but I cannot see any data. How can I see the result?

I get the following Output:

{"statusCode":200,"headers":{"Cache-Control":"no-store, no-cache","Pragma":"no-cache","Vary":"Accept-Encoding","Strict-Transport-Security":"max-age=31536000; includeSubDomains","x-ms-request-id":"c2f3baf6-e776-4f1a-b145-325aebff0e58","X-Content-Type-Options":"nosniff","X-Frame-Options":"DENY","x-ms-connection-gateway-object-id":"0baf22de-6185-4009-8f0d-9aed2bea1c40","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"false","x-ms-apihub-obo":"false","Date":"Fri, 03 Nov 2023 17:46:49 GMT","Content-Type":"application/json; charset=utf-8; odata.metadata=minimal","Expires":"-1"}}

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

GdarmonAbra 77 on at

Like (2)

Report
Copy link

Link copied!

Hi,
can you share the json you are getting back when you dont use any filter ?
does the field UTU_USER_ID exists in the result - is it a string ?
Try to add a Single quote around the TechId,
UTU_USER_ID eq ''

______________________________________________________________

Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

br,
Gill

Was this reply helpful? Yes No
phillippoole 85 on at

Like (0)

Report
Copy link

Link copied!

That did it, thank you

Was this reply helpful? Yes No