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

Add new field in web service of 'Job Planning Lines' Page Id 1007

(1) Share

Report

Posted on by Miscrosoft Dynamcis GP

Hi All,

I want to sync data of 'Project Planning Lines' from Dynamics 365 BC.

We have a table in BC Table ID: 1003 =>Project Planning Lines contains a column as 'ModifiedAt'. Please see attached screenshot.

I am using Page Id 1007 web service to get data from BC, please see attached screenshot.

The response received from web service do not have 'ModifiedAt' field.

Is there a way to modify web service and add 'ModifiedAt' column in web service response?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Dynamics_Decoded_Gokul 487 on at

Like (0)

Report
Copy link

Link copied!

Hi

Extend the Page ID using AL code and add the required column and republish the webservice to get the required information.

Thanks

Gokulnath

Was this reply helpful? Yes No
Suggested answer

Gokulavasan Srinivasan 44 on at

Like (0)

Report
Copy link

Link copied!

Hi,

It’s not possible to extend standard API pages directly. For more details, you can refer to this discussion: Community Dynamics Forum - API Page Extensions.

To retrieve data from the fields in the 'Project Planning Line' table using a web service, you can create a custom API page by following these steps:
Refer to this guide for detailed instructions: How to Create Custom APIs in Business Central.

The example below shows how to include the 'LastModifiedAt' field in the web service response. I have tested this approach for 'customer' table, and it works successfully.

Feel free to reach out here if you have any further questions about this.

Thanks,
Gokul
Congruent Infotech - https://www.congruentsoft.com/

Was this reply helpful? Yes No
Miscrosoft Dynamcis GP 18 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for the help.

I am trying to extend the Page Id using AL code in visual studio, but while Downloading symbol I am getting the error as

The request for path /v2.0/sandbox/dev/packages?publisher=Microsoft&appName=System&versionText=1.0.0.0&appId=8874ed3a-0643-4247-9ced-7a7002 failed with code Forbidden. Reason: Your license does not grant you the following permissions on TableData 2000000206 Published Application: IndirectRead for company My Company.

To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '10172'.

[2024-12-19 16:34:35.95] The request for path /v2.0/sandbox/dev/packages?publisher=Microsoft&appName=Application&versionText=25.0.0.0&appId=00000000-0000-0000-0000-000000000000 failed with code Forbidden. Reason: Your license does not grant you the following permissions on TableData 2000000206 Published Application: IndirectRead for company My Company.

To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '10171'.

[2024-12-19 16:34:35.96] Could not download reference symbols. Please ensure that:

1. The correct server name and instance are specified in the launch.json file.

2. The correct application version is specified in the app.json file.

3. The dependencies are correctly specified in the app.json file.

Where to check these permissions in Online Business central? Please suggest.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,130 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hope this helps: https://community.dynamics.com/forums/thread/details/?threadid=103da5d4-8449-4996-9cb6-2130873d42d0

https://thinkaboutit.be/2022/03/how-do-i-solve-error-your-license-does-not-grant-you-the-following-permissions-on-tabledata-published-application-indirectinsert/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps as well.

Dynamics 365 Business Central: Failed with code UnprocessableEntity (insufficient permissions error on publishing extension – Reason: You do not have the following permissions on TableData XXXX)

https://yzhums.com/8391/

Thanks.

ZHU

Was this reply helpful? Yes No