Skip to main content

Notifications

Announcements

No record found.

Business Central forum

Problem with integration with Dataverse by Virtual Tables

Posted on by 2
Hi.
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.


 
HTTP code: 400
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.

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 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';


 
                }
 
            }
 
        }
 
    }
 
}

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans