Finance | Project Operations, Human Resources, ...

adding SystemUser via API returns "The record already exists"

(0) Share

Report

Posted on by Matthew Baute

I am trying to create a new SystemUser in our D365 system. I can do so through the standard UI, but when trying to do so through the API I receive this message:

"Write failed for table row of type 'SystemUserEntity'. Infolog: Info: Cannot create a record in User information (SysUserInfo). User ID: mytest.\nThe record already exists.."

The user is definitely not existing.

I am sending a simple POST to xyzco.operations.dynamics.com/.../SystemUsers with a JSON body like this:

{

"UserID": "mytest",

"Alias": "mytest@swtc.edu",

"UserName": "Just A Test",

"NetworkDomain": "">https://sts.windows.net/",

"Company": "xyzco",

"EmailProviderID": "SMTP",

"Enabled": true,

"UserInfo_language": "en-us",

"Helplanguage": "en-us",

"AccountType": "ClaimsUser"

}

Any ideas what I may be doing wrong? I am able to successfully POST to /data/WorkerContacts and /data/WorkerPostalAddressesV2 to create new emails and postal addresses via the API. But POST to /data/SystemUsers gives the already exists error.

thanks,

Matthew

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 301,187 Super User 2025 Season 2 on at

Like (0)

Report

Hi Matthew,

Have you checked if both the tables SysUserInfo and UserInfo (system table) don't have a record for this user ID?

Was this reply helpful? Yes No
Matthew Baute 10 on at

Like (0)

Report

Hi André:

I do not have access to SQL, only OData / API.

Nonetheless, I receive the error if I enter any brand new email address that I make up on the spot. Which doesn't make any sense. How could the record already exist if I just entered it for the first time?

thanks,
Matthew

Was this reply helpful? Yes No
André Arnaud de Cal... 301,187 Super User 2025 Season 2 on at

Like (0)

Report

Hi Matthew,

Did you also provide a not used user ID when you enter new email addresses?

Was this reply helpful? Yes No
Suggested answer

Matthew Baute 10 on at

Like (1)

Report
Finally figured it out. Here is the body for the SystemUser POST:

{ "UserID": "jsmith", "UserName": "John Smith", "NetworkDomain": "https://sts.windows.net/", "Email": "jsmith@mycorp.com", "Alias": "jsmith@mycorp.com", --> this is the related "Person" and must exist in AD "Company": "MYCORP", "Enabled": true, "UserInfo_language": "en-us", "Helplanguage": "en-us", "AccountType": "ClaimsUser" }

Was this reply helpful? Yes No

Join the conversation

Community site session details

adding SystemUser via API returns "The record already exists"

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

adding SystemUser via API returns "The record already exists"

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates