Cloudfront caching of API requests causing confusion with user expectations

[jordanpadams]

Checked for duplicates

Yes - I've already checked

🐛 Describe the bug

When I did a curl of a specific API request several times over several days, the response is not changing even though the underlying database has changed.

🕵️ Expected behavior

I expected the response to represent the data in the database within up to 24 hours.

📜 To Reproduce

Cached response:

$ curl -v -L --get "https://pds.mcp.nasa.gov/api/search/1/products?limit=1000&sort=ops:Harvest_Info.ops:harvest_date_time&q=%28product_class+eq+%22Product_Context%22+and+pds%3AResource.pds%3Atype+ne+%22Information.Science_Portal%22+and+pds%3AResource.pds%3Atype+ne+%22Information.Investigation%22%29&fields=lidvid"
...
{"summary":{"hits":2945,...

Rearranging the query parameters:

$ curl -v -L --get "https://pds.mcp.nasa.gov/api/search/1/products?limit=1000&sort=ops:Harvest_Info.ops:harvest_date_time&q=%28product_class+eq+%22Product_Context%22+and+pds%3AResource.pds%3Atype+ne+%22Information.Science_Portal%22+and+pds%3AResource.pds%3Atype+ne+%22Information.Investigation%22%29&fields=lidvid"
...
{"summary":{"hits":2952,...

🖥 Environment Info

• Version of this software [e.g. vX.Y.Z]
• Operating System: [e.g. MacOSX with Docker Desktop vX.Y]
  ...

📚 Version of Software Used

No response

🩺 Test Data / Additional context

No response

🦄 Related requirements

🦄 #xyz

⚙️ Engineering Details

No response

🎉 Integration & Test

No response