actually I'm a Java EE developer and I want to access a SharePoint Webserver by using the SharePoint REST service. Thereby, my goal is to read the data from the lists and save them into a database (yes, logically, it would be better to use a database instead of SharePoint lists, but unfortunately, I don't decide this). My problem is that I am thinking too much the JPA way with POJOs and Services. Therefore, I am stuck and kindly ask for help. I've managed to successfully receive data as a JSON object, but unlike when receiving a JSON object from the front end, this object is full of additional data, e.g. RoleAssignments, FieldValuesAsText, etc. Furthermore, both the German umlauts and special characters are escaped, which makes things even more difficult than I thought. Last but not least, the object seems to also contain hidden fields like "modified" or "created" which shouldn't be stored into the database.
-Is it possible to use POJOs or do I manually have to extract the data from the received JSON object?
-Is it possible to tell SharePoint to export the data to Excel by using REST, so that this file will be received, stored on the Computer and afterwards be imported (by using e.g. the Java Excel API), such that I can avoid dealing with the JSON object?
Any help is really much appreciated!