# Error while importing accounts and entitlements for Delimited Source

**URL:** <https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963>\
**Category:** SHF Discussion and Questions\
**Created:** [November 4, 2021, 9:02am UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963 "2021-11-04T09:02:36Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![sindhu\_v\_murthy](https://avatars.discourse-cdn.com/v4/letter/s/9fc29f/32.png) [@sindhu\_v\_murthy](https://developer.sailpoint.com/discuss/u/sindhu_v_murthy)\
**Post date:** [November 4, 2021, 9:02am UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/1 "2021-11-04T09:02:36Z")

</div>

Hi Team,

We have created a Delimited Source and are trying to import the accounts on the source.  
Schema was configured with following values  
UID (marked as Account ID and Account Name),FirstName,LastName,Access.

 ![image](https://global.discourse-cdn.com/sailpoint/original/1X/6eda67333420aa4c6b6a7ec90d55675bd1d4c42c.png)

However while importing the csv file with account and entitlement details below error occurs.  
“sailpoint.connector.ConnectorException: Index value for [id] on new object was null.”. Could you please help us with this?

 ![image](https://global.discourse-cdn.com/sailpoint/original/1X/c51a5dbce65900ed2e1c20845542592d0518bfda.png)

This was working as expected earlier, We observed that Delimited File Source Connectory configurations are updated. We followed all the instructions as per Delimited File Source Connector Configuration.  
We are also facing issue with Entitlement import. When ever we import entitlments using Import entitlments it always shows as Group type, due to which we are not able to configure Access Profile.

Please let us know if anyone have any pointers.

---

<div class="post-metadata">

**Author:** ![sailajaprathi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/sailajaprathi/32/216_2.png) [@sailajaprathi](https://developer.sailpoint.com/discuss/u/sailajaprathi)\
**Post date:** [November 4, 2021, 3:28pm UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/2 "2021-11-04T15:28:25Z")

</div>

@colin_mckibben Do you have any pointers on this? Is there any recent changes on Delimited Connector?

---

<div class="post-metadata">

**Author:** ![colin\_mckibben](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/colin_mckibben/32/37182_2.png) [@colin\_mckibben](https://developer.sailpoint.com/discuss/u/colin_mckibben)\
**Post date:** [November 4, 2021, 3:55pm UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/3 "2021-11-04T15:55:30Z")

</div>

I tested this on my tenant and it worked as expected. I used the same account schema as you described.

 ![image](https://global.discourse-cdn.com/sailpoint/original/1X/e63179fb09e2731fc042270dc9d949518ea2765f.png)

I uploaded the following CSV file:

```nohighlight
UID,FirstName,LastName,Access
1,colin,mckibben,granted
2,john,doe,denied

```

The account aggregation was successful.

 ![image](https://global.discourse-cdn.com/sailpoint/original/1X/39b9b48a906dcb05818e7d110af1eb72e7197ce6.png)

@sindhu_v_murthy, do you see anything different with how I configured it? Maybe your CSV contains an empty value for `UID`?

---

<div class="post-metadata">

**Author:** ![sailajaprathi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/sailajaprathi/32/216_2.png) [@sailajaprathi](https://developer.sailpoint.com/discuss/u/sailajaprathi)\
**Post date:** [November 4, 2021, 3:59pm UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/4 "2021-11-04T15:59:59Z")

</div>

@colin_mckibben It is failing for below, If we wanted to add multiple entitlements

UID,FirstName,LastName,Access  
1,colin,mckibben,granted1  
1,colin,mckibben,granted2  
2,john,doe,denied

---

<div class="post-metadata">

**Author:** ![sailajaprathi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/sailajaprathi/32/216_2.png) [@sailajaprathi](https://developer.sailpoint.com/discuss/u/sailajaprathi)\
**Post date:** [November 5, 2021, 7:43am UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/6 "2021-11-05T07:43:27Z")

</div>

@colin_mckibben Did it worked after changing as above?

Thank you!  
Sailaja Prathi

---

<div class="post-metadata">

**Author:** ![colin\_mckibben](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/colin_mckibben/32/37182_2.png) [@colin\_mckibben](https://developer.sailpoint.com/discuss/u/colin_mckibben)\
**Post date:** [November 5, 2021, 5:18pm UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/7 "2021-11-05T17:18:27Z")

</div>

I did some more testing and here is what I found works.

The account aggregation is looking for a field called `id`. Since your `Account ID` and `Account Name` are tied to `UID`, the aggregation is failing because it can’t find `id`. If you change your `UID` to `id`, this will work.

 ![image](https://global.discourse-cdn.com/sailpoint/original/1X/a3a28a4abe5ba1563542e44a4fd10c701955e64d.png)

accounts.csv

```auto
FirstName,LastName,Access,id
colin,mckibben,access1,1
colin,mckibben,access2,1
john,doe,access1,2

```

 ![image](https://global.discourse-cdn.com/sailpoint/original/1X/9e830de2806d1d56ed96a802944b481312602cde.png)

I’m not sure if this is a bug or intended. I’m going to ask around internally to see what the expected behavior is. It seems like you should be able to use any name for the `Account ID` rather than being locked into using `id`.

---

<div class="post-metadata">

**Author:** ![Ajit\_Pawar](https://avatars.discourse-cdn.com/v4/letter/a/eada6e/32.png) [@Ajit\_Pawar](https://developer.sailpoint.com/discuss/u/Ajit_Pawar)\
**Post date:** [November 8, 2021, 10:35am UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/8 "2021-11-08T10:35:08Z")

</div>

Hi,

We are investigating the issue, for time being could you please update source using source API to update the following value:

indexColumn: “UID”

Let us know whether it helps.

Thanks  
Ajit

---

<div class="post-metadata">

**Author:** ![colin\_mckibben](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/colin_mckibben/32/37182_2.png) [@colin\_mckibben](https://developer.sailpoint.com/discuss/u/colin_mckibben)\
**Post date:** [November 8, 2021, 5:21pm UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/10 "2021-11-08T17:21:45Z")

</div>

@Ajit_Pawar, your suggestion to manually update the `indexColumn` on the source worked. However, it should work automatically with IDN. Please let us know what you find when you investigate.

@sindhu_v_murthy , if you want to continue using `UID`, you can use the API to manually assign `UID` as the indexColumn. Start by getting the ID of your source by invoking the [GET sources](https://developer.sailpoint.com/idn/api/v3/list-sources) endpoint and finding your source ID in the list. Then, you can use the [PATCH source](https://developer.sailpoint.com/idn/api/v3/update-source) endpoint with the following body to update your `indexColumn`. Be sure to set the `Content-Type` header to `application/json-patch+json`.

```json
[
    {
        "op": "replace",
        "path": "/connectorAttributes/indexColumn",
        "value": "UID"
    }
]

```

---

<div class="post-metadata">

**Author:** ![sailajaprathi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/sailajaprathi/32/216_2.png) [@sailajaprathi](https://developer.sailpoint.com/discuss/u/sailajaprathi)\
**Post date:** [December 8, 2021, 6:48pm UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/11 "2021-12-08T18:48:23Z")

</div>

The issue is fixed on API also.

---

<div class="post-metadata">

**Author:** ![colin\_mckibben](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/colin_mckibben/32/37182_2.png) [@colin\_mckibben](https://developer.sailpoint.com/discuss/u/colin_mckibben)\
**Post date:** [January 6, 2022, 1:57pm UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/12 "2022-01-06T13:57:38Z")

</div>

The underlying issue should now be fixed. You should no longer have to manually assign the UID as the indexColumn via the API, it should automatically work in the UI.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [July 19, 2023, 2:22pm UTC](https://developer.sailpoint.com/discuss/t/error-while-importing-accounts-and-entitlements-for-delimited-source/1963/13 "2023-07-19T14:22:14Z")

</div>