Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Pull links to Business Central posts via OData/webservices

(1) ShareShare
ReportReport
Posted on by 4
Dear experts

Our company is primarily project based and thus there is a need for the different project managers to view their expenses in an easy way for each project. We have build some Excel-files that pull data via OData-connection and makes it presentable for the project managers in table form - one row for each entry. The file works really well, although OData-updating is not always working properly. A great improvement to these files would be, if it would be possible to include links in the data-tables, that open the respective entries in Business Central. I'm referring to the link that can be copied, if an entry is to be shared (/copy link/). Hope that makes sense. Any chance that this is possible, i.e. to find a data table with a link for each Business Central entry? I've looked through many data tables in web services but haven't been able to find it - primarily because the IT-terms that are used are confusing to a person without an IT-background.

Example: Lets say I pulled a table with 100 rows, each row representing an entry (expense/income) in Business Central. There are various columns with information like /Amount/, /Date of entry/, /VAT/, /Name of customer/ etc. I would like to have another row with the direct link/URL that opens the specific entry in Business Central, so that our project managers just need to click on the link to open the respective entry in Business Central

Thanks for your help
 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 78,034 Super User 2025 Season 1 on at
    Pull links to Business Central posts via OData/webservices
    If you mean to open a specific project card, you can use the URL to open it.
    More details:
    Dynamics 365 Business Central: Filtering Data by the Web Client URL
     
    Hope this helps.
    Thanks.
    ZHU
  • gdrenteria Profile Picture
    gdrenteria 14,573 Most Valuable Professional on at
    Pull links to Business Central posts via OData/webservices

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans