Deep insert in API page problems

skollops

Hi,

I'm having some trouble using API in my cloud BC. I have it working in my local docker container, but the syntax seems a bit different against my cloud BC.

This path seems to work fine.
https://api.businesscentral.dynamics.com/v1.0/{{tenant}}/{{environment}}/ODataV4/Company('{{company}}')/salesReturnOrder


However, when I want to expand on the items part of the page, the property can't be found, the error is below.
https://api.businesscentral.dynamics.com/v1.0/{{tenant}}/{{environment}}/ODataV4/Company('{{company2}}')/salesReturnOrder?$expand=items

{
    "error": {
        "code": "BadRequest",
        "message": "Could not find a property named 'items' on type 'NAV.salesReturnOrder'.  CorrelationId:  d09b8fd3-1119-46fe-9c07-226d1bcdc726."
    }
}

So how do I expand properly? I guess the problem is the URL.
Below is a bit more information:

I had the same problem on my docker-container, but I fixed it by using another syntax in the request url. Here is the syntax I use there:
http://{{containerName}}:7048/BC/api/{{publisher}}/{{apiGroup}}/v1.0/companies({{company}})/salesReturnOrder?$expand=items
The difference I can see is that I use the publisher and apiGroup to make it clear what should be expanded.

The pages:

page 50003 "SalesReturnOrder_REAP"
{
    PageType = API;
    Caption = 'modifySalesReturnOrder';
    APIPublisher = '{{publisher}}';
    APIGroup = '{{apiGroup}}';
    APIVersion = 'v1.0';
    EntityName = 'salesReturnOrder';
    EntitySetName = 'salesReturnOrder';
    SourceTable = "Sales Header";
    DelayedInsert = true;
    ModifyAllowed = true;
    DeleteAllowed = false;

    layout
    {
        area(Content)
        {
            group(GroupName)
            {
                field(customerNo; "Sell-to Customer No.")
                {
                }

                field(documentNo; "No.")
                {
                }

                field(type; "Document Type")
                {
                }
                part(items; Items_REAP)
                {
                    ApplicationArea = All;
                    EntityName = 'item';
                    EntitySetName = 'items';
                    SubPageLink = "Document No." = field("No."), "Document Type" = Const("Return Order");
                }
            }
        }
    }
}

And the page used in the part:

page 50004 "Items_REAP"
{
    PageType = API;
    Caption = 'items';
    APIPublisher = '{{publisher}}';
    APIGroup = '{{apiGroup}}';
    APIVersion = 'v1.0';
    EntityName = 'item';
    EntitySetName = 'items';
    SourceTable = "Sales Line";
    DelayedInsert = true;
    ModifyAllowed = false;
    DeleteAllowed = false;
    layout[s][/s]
    {
        area(Content)
        {
            repeater(GroupName)
            {
                field(itemNo; "No.")
                {
                }
                field(itemType; "Type")
                {
                }
                field(itemDescription; "Description")
                {
                }
                part(serialNo; serialNo_REAP)
                {
                    EntityName = 'serialNo';
                    EntitySetName = 'serialNo';
                    SubPageLink = "Item No." = field("No."), "Source ID" = field("Document No.");
                }

            }
        }
    }

    trigger OnInsertRecord(BelowxRec: Boolean): Boolean
    begin
        Insert(true); // Call the Table trigger because the API does not call it.

        exit(false); // Must abort the Page trigger because the record has already been inserted.
    end;

foo_bar

Hi Skollops,

in your docker url you are using the API endpoint, in your BC online url you are using the ODataV4 endpoint (this endpoint does not support deep inserts)

try changing
https://api.businesscentral.dynamics.com/v1.0/{{tenant}}/{{environment}}/ODataV4/Company('{{company2}}')/salesReturnOrder?$expand=items
to
https://api.businesscentral.dynamics.com/v1.0/{{tenant}}/{{environment}}/api/{{publisher}}/{{apiGroup}}/v1.0/companies({{company}})/salesReturnOrder?$expand=items

wait

I don't think the PageType of the subpage should be API, it should be ListPart.

wait

Unrelated, I did a lot of API stuff in NAV 2018 and then it was not possible to have three level down like you are trying with the serialNo. Is that possible now?

If you run into problem with that then you can try complex types.

https://forum.mibuso.com/discussion/72539/nav-2018-api-complex-types#latest

skollops

wait wrote: »

I don't think the PageType of the subpage should be API, it should be ListPart.

It works quite fine in my docker with API-pages, the url syntax on my cloud BC just seems different.

wait wrote: »

Unrelated, I did a lot of API stuff in NAV 2018 and then it was not possible to have three level down like you are trying with the serialNo. Is that possible now?

If you run into problem with that then you can try complex types.

https://forum.mibuso.com/discussion/72539/nav-2018-api-complex-types#latest

Same answer as above It works in docker, but not here.

Thank you for your responses though!

foo_bar

Hi Skollops,

in your docker url you are using the API endpoint, in your BC online url you are using the ODataV4 endpoint (this endpoint does not support deep inserts)

try changing
https://api.businesscentral.dynamics.com/v1.0/{{tenant}}/{{environment}}/ODataV4/Company('{{company2}}')/salesReturnOrder?$expand=items
to
https://api.businesscentral.dynamics.com/v1.0/{{tenant}}/{{environment}}/api/{{publisher}}/{{apiGroup}}/v1.0/companies({{company}})/salesReturnOrder?$expand=items

skollops

@foo_bar Thank you! That seems to be it

wait

skollops wrote: »

Same answer as above It works in docker, but not here.

Cool, guess this has changed in BC, just out of curiosity, how is the syntax to expand the third level, in your case serialNo?

foo_bar

@wait ,
It is now possible to nest API pages, if you want to expand nested collections, you can use this format for this example
https://api.businesscentral.dynamics.com/v1.0/{{tenant}}/{{environment}}/api/{{publisher}}/{{apiGroup}}/v1.0/companies({{company}})/salesReturnOrder?$expand=items($expand=serialNos)

@skollops , I just noticed a little error in your Items_REAP page

part(serialNo; serialNo_REAP)
                {
                    EntityName = 'serialNo';
                    EntitySetName = 'serialNo';
                    SubPageLink = "Item No." = field("No."), "Source ID" = field("Document No.");
                }

should be

part([b]serialNos[/b]; serialNo_REAP)
                {
                    EntityName = 'serialNo';
                    EntitySetName = '[b]serialNos[/b]';
                    SubPageLink = "Item No." = field("No."), "Source ID" = field("Document No.");
                }

and then also be sure to check your settings (entityname, entitysetname) on your serialNo_REAP page