How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

(0) Share

Report

Posted on by Govinda Kumar

2,211 Moderator

Hi, everyone

I am trying to create a web service for the 'G/L Balance/Budget' page 422 in Business Central, but I am having trouble filtering by fields that are not part of the underlying table for that page.

I have tried using the filters that are part of the G/L table

Same thing I cannot do for the PeriodType

they only work for the fields that exist in the table. Is there a way to filter by fields that are added to the page but not part of the table? Any suggestions or guidance would be greatly appreciated!

I have the same question (0)

All responses (6)

Answers (0)

Hammed Rildwan Bolaji 15 on at

Like (0)

Report

RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

YOU HAVE TO CREATE NEW FIELDS USING TABLE EXTENSIONS THEN FILTER WITH IT

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,595 Moderator on at

Like (1)

Report

RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

You need to add data first on newly created field, and then you can use this field as a filter in your API url

Was this reply helpful? Yes No
Govinda Kumar 2,211 Moderator on at

Like (0)

Report

RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

Thank you for your suggestion, Nitin Verma. Can you please clarify how to use my field to filter data on the G/L Balance/Budget page? Thank you again.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,595 Moderator on at

Like (0)

Report

RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

Unfortunately it will no work, you have create a field using Table extension, and use that in filter the data.

Was this reply helpful? Yes No
Govinda Kumar 2,211 Moderator on at

Like (0)

Report

RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

Thanks, Nitin Verma.

I understand that the filters will only work for the fields that are part of the table, but in my case, I need to filter by fields that are added to the page but not part of the table. My requirement is to create a flow in Power Automate to pass the necessary parameters to that page and get the filtered data in response, which I have to email to someone. Do you have any suggestions or guidance for me?
Regards

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,595 Moderator on at

Like (0)

Report

RE: How to filter when creating web service for G/L Balance/Budget page (422) in Business Central?

Hi,

If the fields are not in table only in page, and then It will not filter the data, if the fields already available in the Table, you can try with option's index value if its not working with option's text value.

Thanks.

Was this reply helpful? Yes No