Memory issue/ random occurrence error when retrieving data from ext API

Options
Xano Support Chat
Xano Support Chat Administrator

ADMIN

edited January 2023 in ? Working with APIs

I am trying to pull data from one of my APIs and then insert it into a table. This pulls 200 records per API call and it may have 20000 records. But I keep getting this error:


Best Answer

  • Xano Support Chat
    Xano Support Chat Administrator

    ADMIN

    edited January 2023 Answer ✓
    Options

    We see your CPU, API requests, memory and function stack overall don't seem to be maxed out. If you don't need the data with the typical quick response of an API endpoint, the best way to process the volume of records you want to work with would probably be using a background task as they have dedicated resources to run the data. That way it won't affect your instance.