How to quickly update "External Identity" with email address for Users - aka SSO

Kinetic ERP
1

Anyone have a quick automated way to place the email address into External Identity field for users in order to use SSO? Or is it a manual effort?

Tried using the /api/swagger to pull back methods on Ice.Proxy.BO.UserTracingImpl, but get a 404. Looked in the swagger library, found Ice.BO.UserTracingSvc - specifically UpdateExt, but External Identity is not one of the fields.

Appears the External Identity is in the Ice.SysUserFile. Part of the payload on the UpdateExt is:

"ExtensionTables": [
      {
        "Table": [
          {
            "ColumnValues": [
              {}
            ],
            "RowMod": "string",
            "SysRowID": "00000000-0000-0000-0000-000000000000"
          }
        ],

Could I use that to reference Ice.SysUserFile, then the column ExternalIdentity?
2

UserTracingSvc doesn’t sound like the correct one to use, Ice.SysUserFile sounds more like it.

Have you performed an update to one user within the Epicor UI, and traced it to see what calls are made? You can do it all in Chrome, login to Epicor, make the change whilst looking at the Network tab in Dev Tools (Press F12 to open).

1 Like
3

You can use PATCH UserFiles({UserID})

/api/v1/Ice.BO.UserFileSvc/Ice.BO.UserFileSvc/UserFiles(epicor)

witt payload like

{
“ExternalIdentity”: “youremail@company.com”
}

image
image1133Ă—884 71 KB

1 Like
4

Do you have DMT? I think that would be the quickest solution. Maybe I’m misunderstanding the issue/question…are you trying to update the users in bulk, or automate populating this field in some other scenario?

5

Sure did…

Ice.Proxy.BO.UserTracingImpl
GetNewOrGetByID
https://central
Ice.BO.UserTracingDataSet
3/16/2023 08:25:28:3992399 AM

Ice.Proxy.BO.UserTracingImpl
Update
https://central
System.Void

6

Perfect - that makes sense, I’ll head that route.

7

I personally tend to be faster with api than dmt, but I’m not a user of the system.

8

Ah right - that isn’t the actual trace of the methods - that’s just where it turned on the tracing!

I did it in the browser, and there are a few calls - some of which are just populating the screen. You can probably get away with the ones I’ve highlighted:

image

OR even easier is the way that @Olga showed with a patch.

1 Like