2Hi.
I am using Business Central as a source for virtual tables in dataverse.
Everything worked fine a month ago, now the data is no longer being downloaded to dataverse.
I can enable the virtual table without any error, and then I can see my table in dataverse.
But I get an error when downloading the data.
Data is retrieved correctly for native tables from Business Central: item, Sales Order, etc.
The problem occurs only for my custom tables and api pages.
Everything worked fine a month ago, now the data is no longer being downloaded to dataverse.
I can enable the virtual table without any error, and then I can see my table in dataverse.
But I get an error when downloading the data.
Data is retrieved correctly for native tables from Business Central: item, Sales Order, etc.
The problem occurs only for my custom tables and api pages.
HTTP code: 400
Message: { “error”:{ “code”: “0x80050263”, “message”: “An OData error occurred.”}}
Message: { “error”:{ “code”: “0x80050263”, “message”: “An OData error occurred.”}}
Data is retrieved correctly for native tables from Business Central: item, Sales Order, etc.
The problem occurs only for my custom tables and api pages.
The problem occurs only for my custom tables and api pages.
My BC version is: 24.1.18927.19282
Here is my code:
TABLE:
table 50100 test_agreement
{
fields
{
field(1; ID; Code[20])
{
}
field(2; Contact_ID; GUID)
{
TableRelation = Contact.SystemId;
}
field(3; Name; Text[40])
{
}
}
keys
{
key(Key1; ID)
{
Clustered = true;
}
}
}
PAGE:
PAGE:
page 50107 test_agreement_api
{
PageType = API;
APIPublisher = 'ITI';
APIGroup = 'b2b';
Caption = 'Agreement';
APIVersion = 'v2.0', 'v1.0';
EntityName = 'test_agreement_api';
EntitySetName = 'test_agreement_apis';
SourceTable = test_agreement;
DelayedInsert = true;
ODataKeyFields = SystemId;
layout
{
area(Content)
{
repeater(GroupName)
{
field(id_guid; Rec.SystemId)
{
Caption = 'id_guid';
}
field(ID; Rec.ID)
{
Caption = 'ID';
}
field(Name; Rec.Name)
{
Caption = 'Name';
}
}
}
}
}
