Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : KxJ5pedgNRxbuhKXvRIh0r
Small and medium business | Business Central, N...
Answered

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

Like (0) ShareShare
ReportReport
Posted on 6 May 2020 16:43:09 by 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
    5 on 08 May 2020 at 06:21:31
    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
    on 07 May 2020 at 12:14:30
    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
    5 on 07 May 2020 at 10:04:06
    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
    46,489 on 06 May 2020 at 20:58:17
    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
    5 on 06 May 2020 at 20:40:33
    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
    46,489 on 06 May 2020 at 16:59:30
    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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 293,518 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,594 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans