How to update info of 400 users from API Call

I’ve managed to get the API working and pulling data on request. I have 400 entries and would like to update them based on info stored in a Coda doc.

The question is, how can I store the JSON that’s returned, then use that to update each of my 400 entries in my Bubble app?

Ideally, I can do this once a week from a backend workflow.

Realy appreciate the help!