I was looking for a mock solution that should record the API requests and responses based on response content received from the actual API and store and response when requested.

Hi, have you tried Wiremock’s record and playback feature - https://wiremock.org/docs/record-playback/

Can this be automated without any manual intervention ?

yes, you can explore & use the record/playback API's for your automation.