Administrators frequently encounter the necessity to create or update user profiles that include array datatype values when managing user profiles in Okta through the Okta Users API. A prevalent challenge is ensuring these array values are correctly formatted to be recognized by the API.
- Okta Core API
- String Array Datatypes
This issue becomes especially pronounced during bulk operations using tools such as Postman Runner, where the source data is stored in a CSV file. Ensuring the array string values in the CSV file are properly formatted is crucial for the successful completion of these operations.
When extracting data from a CSV file, it's essential to format each array value as a string, using a particular notation for double quotes. To represent the values Blue, Yellow, and Green in an array for a field such as workingCode, input the value in the CSV as "[""Blue"", ""Yellow"", ""Green""]". This method involves enclosing the entire array string in quotes and doubling the double quotes for each array element.
NOTE: While there is no item limit in a user profile array attribute, Okta support does not recommend more than 1000 items.
Below are working examples:
- Sample CSV File
- Postman Collection
- API Response
