Retain Data Store in SAP CPI based on Retain Until Date

[nidhi_srivastava22]

Hi Experts,

We have a requirement for retaining the datastores data more than 90 days. Since, it is not possible as per the settings a custom Iflow is created to handle the same but it is polling all the data which is creating load on the system and might occupy more memory than required.

Can we add some step which can take the consideration of expiration date and extend the date based on that instead of all the data at one go. Please suggest if we can optimize this in a better way?

Thanks.

Best Regards,

Nidhi Srivastava

[philippeaddor]

Hi, 

you could use the Message Store API: https://api.sap.com/api/MessageStore/path/get_DataStoreEntries

There you can read the "retain until" attribute of the different entries and react upon that. 

This will however cost you one message (counting towards the billed messages) each time you read the data store using the API. 

Philippe