Hi,
I am trying to create a Query API on the Change Log Entry table that will be use in Power Automate.
I'm having an issue adding the flowfields (Table Caption, Field Caption, etc...)
If I add them directly as columns, the Query doesn't work. Instead of returning the values, I'm getting this message
"error": { "code": "BadRequest_NotFound", "message": "No HTTP resource was found that matches the request URI...
As soon as I removed the flow fields, it's ok.
I tried adding a dataitem and getting the value myself but it doesn't let me because those flowfields are related to virtual tables
How can I get the field and table captions from the Change Log Entry in a Query API?
Thanks
-Julie