Since you want the data in a SQL database anyway, you could automate this easily by extending the FoE Helper addon.
The code below will collect all Battlefield related data and writes it to a webservice, which in turn writes the json data into a simple database table. You could then read out the json data and process it at a later time. I use this method to create all kinds of statistics that the FoE helper addon does not provide.
Search FoE helper sourcecode for FoEproxy.addHandler to see more examples.
My code:
FoEproxy.addHandler('BattlefieldService', 'all', (data, postData) => {
json = JSON.stringify(data.responseData);
fetch('https://your_webservice.herokuapp.com/dbwrite/', {
method: 'POST',
headers:{
'Content-Type': 'application/x-www-form-urlencoded'
},
body: new URLSearchParams({
'requestclass': data.requestClass,
'requestmethod': data.requestMethod,
'responsedata': json
})
});
return;
});
