web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to display company...
Small and medium business | Business Central, N...
Suggested answer

How to display company or any other entity data into the page by using OData URL?

(0) ShareShare
ReportReport
Posted on by Inkey Solutions 2,086

Hello,

We are having a requirement to display Company data into the page of Business Central by using OData URL and also pass the displayed data into the other system by using an API call. We have two questions right now to achieve this requirement.
1. How to display data in a Page using OData URL of business Central?
--> In this case, we are assuming that we need to create an OData URL for this but we are not able to find anything about this.
2. On click of the Submit button we need to prepare the JSON of the displayed data in a page.
--> In this case, we have a plan to make JSON of displayed data but we are struggling to make JSON from displayed data.
It would be great help if somebody could guide us what to do. It would be really very appreciated.
I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 121 on at
    RE: How to display company or any other entity data into the page by using OData URL?

    Check out the web services page. If you have an idea of the pages already then you can select from the ready to go list. If the page does not meet your requirement you can create a new one with AL. The json structure is predefined based on the page design so very little work here indeed. Not completely relevant to your scenario but this blog shows some DEV and general usage of odata: joshanglesea.wordpress.com/.../

  • Suggested answer
    Tabrez Ajaz Profile Picture
    Tabrez Ajaz 785 on at
    RE: How to display company or any other entity data into the page by using OData URL?

    Hi,

    First check the default Web Services of type Page or Query in Business Central, if required Web Service not available then you can create your own custom Web Service of type Page or Query by writing AL code. Whenever you are creating your own Web Service make sure it's type should be page or query because these two types only support OData. 

    Steps to create OData URL:
    * Create a page or query with the related table 
    * Open Web Services Page in Business Central choose Object Type: Page or Query and enter Object ID of your page or query, give your service a Name
    * After this make Publish field true copy the OData Url and make request to get the data.

    To get data in JSON through service call you can get Idea of Service call from below URL: Consume REST API Url in Microsoft D365 Business Central

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,275

#2
Sumit Singh Profile Picture

Sumit Singh 2,677

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,526

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans