Share
Report
28I am attempting a simple query of a materialized view from my database but I am seeing this error.
Request to XRM API failed with error: 'Message: Flow client error returned with status code "BadRequest" and details "{"error":{"code":"InvalidOpenApiFlow","message":"Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'postgresql' operation 'GetTable' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: {\r\n \"status\": 400,\r\n \"message\": \"The specified item 'schema.myMatView' is not found.\\r\\n inner exception: The specified item 'schema.myMatView' is not found.\\r\\nclientRequestId: c83dd48f-b8e0-44be-9008-6586989c9dff\",\r\n \"error\": {\r\n \"message\": \"The specified item 'schema.myMatView' is not found.\\r\\n inner exception: The specified item 'schema.myMatView' is not found.\"\r\n },\r\n \"source\": \"postgresql-eus2.azconn-eus2.p.azurewebsites.net\"\r\n}'."}}". Code: 0x80060467 InnerError: '.
It is a simple query with no OData filters of just the materialized view, the name of which I've altered above. I have triple checked the spelling and that the materialized view does in fact exist in the database. Does this connector not allow for materialized views or views to be queried, or am I missing some sort of setting?
All responses (
Answers (
