Possible issues with frequent updates to Lookup Tables

I am getting the following Upsert error to a LookupTable:


"Message: An unexpected error occurred.: Error in calling Operation Upsert One or more errors occurred. Response status code does not indicate success: 429 ()."


I am using an Upsert to a Lookup Table inside a Fetch control. For each record in the main query, there may be several hundred records returned in the Fetch.


I'm trying to find a "max" record in the Fetch entity.


Is there a stability or performance issue when using Lookups this way? Is there a better way to accomplish what I'm trying to do?





(2) Answers