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)

Sort by

André Arnaud de Cal... 305,643 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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... 305,643 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!
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