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 %") { }
}
}
}
}


Report
All responses (
Answers (