resetIndex

khoonks · September 2022

Hi I am trying to resetIndex on Anaplan numbered list. And I am running a POST through POSTMAN.

https://-----/models/45B36E7BA9BB4A0/lists/101000000309/resetIndex -

However, I am getting the "threshold has not been exceeded.. " error.

The reason I am trying to run it is to ensure that we run the script to reset the index (coz we have millions of rows and we get to the threshold pretty quick).

However, as per the error message, it looks like we cannot reset the index if it has not reached about the 900 mil.

I heard that we should be able to run it automatically through API Curl which is why I was trying via POSTMAN to get started. Any suggestions? What is the option to run it without reaching the threshold?

Thanks.

ryan_kohn · September 2022

You should first make a call to retrieve the list metadata.

/workspaces/{workspaceId}/models/{modelId}/lists/{listId}

There are two fields returned that you need to check before resetting the index:

nextitemIndex. Check to see if this is >=900,000,000.
itemCount. Check to see this is 0 (kudos to @KirillKuznetsov for reminding me of that requirement).

KirillKuznetsov · September 2022

@khoonks

Did you make sure that your list is empty as it's required for the index reset? https://help.anaplan.com/f5f76c88-127f-4109-b022-d215917cba24-Reset-the-list-index

resetIndex

Answers

Categories