Small and medium business | Business Central, N...

Calling an API to change the value of FlowFields

(0) Share

Report

Posted on by JJMc

293

Hi all.

I need to call the items API to get the Inventory field, but not the total Inventory but the Inventory for a specific location.

How do I need to do the call to the API? I tried this way:

items?$filter=Location_Filter eq 'SPAIN'

but BC gives me this error:

Could not find a property named 'Location_Filter' on type 'Microsoft.NAV.item

Thank you ever so much

All responses (10)

Answers (0)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi JJMc2 ,

Can you please replace your text with below?

items?$filters=Location_Filter="SPAIN"

and then please try.
JJMc 293 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer.

This does not give me the error, but it does not work. The Inventory field is the same as if I omit this filter
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi JJMc2,

This was test and I was getting the response successfully.

Can you please try this filter on Item list in business central and check if the result is same?

Thanks
JJMc 293 on at

Like (0)

Report
Copy link

Link copied!

On BC, Item list, Inventory = 22.

On Postman:

"value": [

{

"@odata.etag": "W/\"JzIwOzE0Nzg1Mzc3OTE1MjE1NjI5Njk5MTswMDsn\"",

"id": "beebbb78-2980-eb11-b853-000d3a20c029",

"number": "1000",

"displayName": "Bicicleta",

"type": "Inventory",

"itemCategoryId": "00000000-0000-0000-0000-000000000000",

"itemCategoryCode": "",

"blocked": false,

"gtin": "",

"inventory": 249,

"unitPrice": 4,
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Initially you problem was below, which is corrected now.

but BC gives me this error:

Could not find a property named 'Location_Filter' on type 'Microsoft.NAV.item

Now I can see your inventory not matching when you are putting filters, is this correct?
JJMc 293 on at

Like (0)

Report
Copy link

Link copied!

Yes it is.
cperezsx 60 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think your problem its about the field its not published in the default API page, may you have to create another one and publish this field for make the correct call.

docs.microsoft.com/.../devenv-develop-custom-api

Regards,
Suggested answer

Avinash B 1,455 on at

Like (0)

Report
Copy link

Link copied!

Hi

Make sure Location_Filter is enabled on the API. Otherwise I doubt it will work.

Hope it helps.
JJMc 293 on at

Like (0)

Report
Copy link

Link copied!

But the field "Location filter" is not a field itsef, it is a FlowFilter and it is used to change the value of FlowFields.

I can not believe than Microsoft has not keept this in mind in order to be able to obtain in an API the correct value of FlowFileds dependind on users needs
cperezsx 60 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Im not sure about the actual page using as API, but if you inspect the code of page 5470 from the base application, you can confirm the flowfield of location filter its not exposed, then, you can't use it from the API.

Another way its create your custom api, expose and try it.

Regards,