Looking for API field type feedback

[turnk]

Hello guys,

Has anyone ever experienced storing the body response of an API call as a field in the database?
Actually, I am making an API call to an external database that retrieves 100,000 items (with pagination of 1,000 items per page). Then, I have a back-end that adds each response to my field’s list (field type of my api call as a list).

So I am able to store 100 000 items with a very limited WU’s cost (around 10 WU for the entire call).

I’m looking for feedback on this topic and any limits as I am not able to find any for now

Thanks in advance for your help !