API Query in BC

(0) Share

Report

Posted on by Anthony L

Hello,

I want to make a API query that connects the Item table and the Sales Line Discount Table.

I want to see the discounts on an Item for a customer. So I made an API query.

Now i'm testing because i don't have the way to read the users login number and link it to the customer number. But in this little test i get strange values back in postman.

Can anyone tell me what I'm doing wrong?

Thx

query 50100 "Itemprice Entity"
{
QueryType = API;
Caption = 'Itemprice API', Locked = true;
APIPublisher = 'Me';
APIGroup = 'Client';
APIVersion = 'v1.0';
EntityName = 'itemprice';
EntitySetName = 'itemprices';


elements
{
    dataitem(QueryElement1; Item)
    {
        column("articleNumber"; "No.") { }
        column("price"; "Unit Price") { }
        dataitem(QueryElement2; "Sales Line Discount")
        {
            DataItemLink = "Code" = QueryElement1."No.";
            SqlJoinType = LeftOuterJoin;

            column(discount; "Line Discount %") { }

        }
    }
}
}

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Andy Sather on at

Like (1)

Report
Copy link

Link copied!

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.

Was this reply helpful? Yes No