20
Views
2
Comments
Storing the static data outside of outsystems
Question
Application Type
Reactive

Hi

Is there any other option to store the static data instead of using entity in outsystems?

Because it will easier to update the data if the data in stored in external file like xml .

2018-10-29 08-31-03
João Marques
 
MVP

Hi Sowndhar,


You can do that sure, but then you lose the ability of joining the static data from the XML with other entities from the database, which may come in handy when you are trying to mesh data.

I would suggest do the following:

  • Create a normal entity for this data
  • Create a backoffice to populate it with scaffolding with minimum effort (older video but the point is the same nowadays) 
  • Add an export / import mechanism using Excel to Record List and Record List to Excel built-in functions, to be easy and quick to change them
  • Consider adding cache to getting data / invalidating cache upon changing data, for better performance as this table would likely be considerably target of more reads than subject to changes


Kind Regards,
João

UserImage.jpg
Sowndhar S

Hi Joao Marques

I am currently created a normal entity to store the data and passing it to the REST API's.

Just a few static data only,remaining it will be from web form.

When anyone wants to update the data who didn't have much outsystems,it will be difficult.

So I am thinking of like store it in key value pairs and when we update the data just need to sync it in outsystems.

I didn't understand clearly what you said above.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.