ZacharyM.24658 (Customer) asked a question.
Hey All,
Currently, I'm trying to setup a Google Sheet as the source of truth for my Okta instance, however, I'm running into some challenges with regard to users that have already been created.
I'm using the Google sheet as an employee list and I am constantly adding new users to the sheet. I followed the instructions on this Okta blog (https://www.okta.com/blog/2024/01/import-users-from-google-sheets-create-users-in-okta/) to setup a Workflow that creates users based on the data in this sheet.
The problem however, is that, once a user has already been created, the workflow gives a workflow error: "login: An object with this field already exists in the current organization" and thus the workflow errors out and no updates go through to Okta for new users due to the existence of the old users.
Is this any kind of workaround for this situation? Ideally, I'd like for the workflow logic to skip a user if they already exist, and if there have been any changes to an existing user, I'd like those changes to be made, as well as new users being created which is the main intention of this workflow.
As it stands, this workflow is only useful for uploading new users alone, and then its required to remove all users from the Google Sheet in order to add new users again, which defeats the purpose of the sheet being a comprehensive user source of truth.
I'd appreciate any advice. Thanks.
@ZacharyM.24658 (Customer)
The blog you are referring to is a one time import guide from sheets to okta. It is not meant to use for a csv as source.
You might want to explore either Anything as a source https://developer.okta.com/docs/guides/anything-as-a-source/
Or CSV directory option https://help.okta.com/oie/en-us/content/topics/directory/csv-integration-configure-integration-settings.htm
First option should work for you in terms of continuous imports without additional infra.
Second option, you need agents installed for it.
Thank you for this advice. I will look into these potential solutions to figure out which one best works for our organization's needs.
that particular workflow is just to read a sheet and create users in okta. youd have to enhance the flow to do a "check if user exists" or somehow flag in the sheet that you already loaded it. but also like Rohit said you should consider checking out anythign as a asource (XaaS) as that is more designed for this use case. its complicated to put together but its what its designed for