> You can ditch the AWS part actually. I was originally planned to query the API directly from the Pico W. However the performance was not good.

Network or compute? I don't quite understand how making AWS a middle-man helps?

Guessing it’s to cache the results so it’s faster to access it later

Yes, it also trims out unused information.