I have some JSON data that I will sometimes add things to. To keep things organised, I think it would be nice to have this in an external file.
So this is the data for example
Can I just make a mydata.json and load this into the server connect? If yes, how?
Other suggestions also welcome.
@sid I swear I have seen you mention this to someone once, but I might be mixing things…?
PS
It’s now in a set value which is taking a LOT of space
I am recollecting something around this as well, but not sure. 
You can use RunJS to set such data so that it does not look this weird.
Or you can create a custom extension which would read the files where you keep this JSON data.
I’d suggest it gets stored as JSON in your dB in a system table. Assuming your DB supports json/json columns.
That way it’s easily accessible, cached in redis and easily stored in the session by relevant users. A text file feels insecure and corrupitible
Thanks for the options guys 
will think about it a bit more
I agree with @scalaris, db would be the best way for me. This ensures that I can scale if I ever need to edit JSON data, but it’s on 100’s of servers
Personally I would not consider that huge in any way. Just a few simple set values.
Big question I guess is how often does the data change?
Personally I like to refresh API actions to ensure the data is up to date.
I have API Acions with dozens of set value steps and they are efficient. Remember set value is a memory based action which executes in milliseconds
For non-confidential data I personally store in public folder and then do an API Action to grab it. Reading from filesystem would be neat but maintaining schema would be tricky in a custom extension
