Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Needs to get access to...
Small and medium business | Business Central, N...
Answered

Needs to get access to internal Navision Groups and the Member via API

(0) ShareShare
ReportReport
Posted on by Mike Wiedemann 5

Hello,

one of our clients like to import User and Group information from the internal Navision user management into an Access Rights Management tool. With the standard Powershell command Get-NAVServerUser I get just the user with license information. But I like to get the information from the table called "dbo.User Group" and "dbo.User Group Members". Is there any way to export that via PowerShell or any WebService call? I checked a lot of answers in the web but there is no explanations how to extract the information nor why it is not possible. I know that the effective rights could be done with the PowerShell commands but that is not the goal. I don't want to extract that via SQL because the client likes to plan to go to 365 where I have no access to SQL isn't it? Is in 365 this internal groups still used? Maybe there is an internal Navision Job  I can create to export that data to an CSV? And would that run on 365 too?

Any help would be appreciated. 

Many Thanx for help, and have great day

Mike

  • Mike Wiedemann Profile Picture
    Mike Wiedemann 5 on at
    RE: Needs to get access to internal Navision Groups and the Member via API

    Thank you that makes our life much easier :-).

  • Verified answer
    THE Italian Profile Picture
    THE Italian on at
    RE: Needs to get access to internal Navision Groups and the Member via API

    If with 365 you mean Dynamics 365 Business Central yes you can. Same things as with NAV.

  • Mike Wiedemann Profile Picture
    Mike Wiedemann 5 on at
    RE: Needs to get access to internal Navision Groups and the Member via API

    Thank you very much, its much easier I thought. Can we do the same in 365?

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,749 on at
    RE: Needs to get access to internal Navision Groups and the Member via API

    Please check this link

    docs.microsoft.com/.../how-to--publish-a-web-service

  • Mike Wiedemann Profile Picture
    Mike Wiedemann 5 on at
    RE: Needs to get access to internal Navision Groups and the Member via API

    Hello Suresh,

    since I'm new and only an expert for PowerShell can you give me a hint where I can have a look to "publish" that pages and maybe an example for getting access to that published pages? Many thanx.

    regards

    Mike

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,749 on at
    RE: Needs to get access to internal Navision Groups and the Member via API

    You can publish the Page 9830 for User Groups and 9831 for User Group Members as web services as access the data from there.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans