64
Hellog guys,
My question is if I'm allow to sort an API with variables defined in the page or can I do this only with fields from the table?
For example I'm trying to sort Items custom API using a variable ModelNumber and I'm getting the following error:
{
"error": {
"code": "Unknown",
"message": "The supplied field number '-1' cannot be found in the 'Item' table. CorrelationId: c1f2fa30-3c53-449f-99c2-3350065e428c."
}
Hi, just adding some info.
In fact, variables are not only in the API, but also cannot be sorted on the page.
For example,
Real field:
So if you want to sort by your variable, you need to create a new field in the table and add it as a new second key would be better.
Hope this helps as well.
Thanks.
ZHU
is there other way to sort without adding the variables as fields on the table ?
Variable is not accessibly through API
I added the variables on custom API Items page and then trying to test using Postman call.
api.businesscentral.dynamics.com................................................................../Items
Hi,
Variable defined on Page not available with API on normal page.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (