Thanks @ravi_joshi for the information. That's what i am thinking. But GET requests we can cache at magento fastly CDN but Why cif core OOTB components don't use GET( url becomes too long and http error would be there) and each time they call Magento to fetch data.
For POST additional app level cach...
Links can't automaticlaly be tracked. You can create tag in GTM with some class (css) to track all links and it will push required details of triggered tag in GA
Or You can push required details to datalayer and make variable in GTM and track in GA.
Thanks @arunpatidar i was looking for any tool if aem provides. We can use jmeter but configuring urls we need to do at our end but yeah thats fine.
So custom solution would be needed for the same only
you need to write a custom sling servlet that handles the upload of the asset. Before placing the content into the JCR - check to see if the size of the asset is according to your requirement. If not then reject it.
You need to write custom logic to read excel file and create node as per your requirement means name of th node and set property accordingly. Better to run this job as scheduler/sling job on Author and then publish as per your requirements.
As you mentioned data frequency is very less (less changes in year) then you can pull data weekly(as you mentioned atmost once per week) from api and push to AEM crx via scheduler. Fix your cron job for weekly. Then you can use these data.
There is no need to call api everytime.