Cannot see table in MySQL

(0) Share

Report

Posted on by shakudu

I have a connection to a MySQL database with two tables.

Schema privileges are the same on both tables (select and update).

However, i can only see one of the tables in Power Automate. If i type the name of the table manually i get the error message:

Request to XRM API failed with error: 'Message: Flow client error returned with status code "BadRequest"

 The dynamic operation request to API 'mysql' operation 'GetTable' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: 
{
 "status": 400,
 "message": "The specified item 'db.customer' is not found"
}

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

Sort by

shakudu 32 on at

Like
a
(0)

Report
Copy link

Link copied!

So, after clicking around i tested with a third table and it appeared right away.
I think the problem is related to the fact that this table is created with system versioning.
This has also caused issue with query from Power BI (it cannot see the table).

Was this reply helpful? Yes No
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@shakudu Thanks for sharing... I had a similar problem in the past and tried typing the table name by using "Enter Custom Value"? Which did not work in your case 😞

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No