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?