Share
ReportHello all,
I'm building a website and I use both SQL and Dataverse as database. For dataverse, I use "contact" and "account" tables so that I can manage the contact- and account-type table permissions.
For now I have created two virtual tables from SQL tables. Both tables have one lookup column that links them to "account" table in the Dataverse. I am able to perform GET and PATCH operations via webapi on both virtual tables including the lookup columns. However, when I try to perform GET operation, where I also expand data of the lookup column, I always receive this error message:
{
"error": {
"code": "9004010D",
"message": "Common Data Service error occurred.",
"cdscode": "0x80040224"
}
}
This is the url I use "/_api/xxxx_my_virtual_tables?$expand=xxxx_Organization($select=name)"
"xxxx_Organization" is the Schema name of the look up column that is linked to the account table.
I tried it with other Dataverse tables and there was no problem. I only get the error when I try it with virtual tables. Is this a known limitation? Did I make any mistake or is there any way to work around it so that I can get the value of the primary column of the account table?
Thanks for your help in advance.
All responses (
Answers (
69
