Send JSON to database

Networking Solutions
1

Hello, I’m reading some watermeters with a TRB143 and M-bus and trying to send the data to a database through a php-script. My problem is that when the TRB is sending the JSON it also send a bounch of crap before the real JSON. Is there a way of getting rid of the not wanted data? I made the not wanted data bold.

Here is a example:

a:1:{s:11:“DataGroup_1”;a:1:{s:4:“data”;s:320:"[{
“MBusData”: {“SlaveInformation”: {
“SecondaryAddress”: “223363486E160102”,
“Id”: “22336348”,
“Manufacturer”: “ESN”,
“Version”: “1”,
“ProductName”: “”,
“Medium”: “Electricity”,
“AccessNumber”: “85”,
“Status”: “00”,
“Signature”: “0000”
},
“DataRecord”: [
{
“Value”: “402”,
“Timestamp”: “2026-01-21T16:09:07Z”
}]
}
}]";}}

kind regards 
Björn
3

Hi, Bjorn,

Since you are using a script, as you mention, my only suggestion here would be to use PHP to your own advantage and simply filter out the unwanted data that is being sent. We don’t provide support with said custom scripts, but I’m sure you’ll be able to figure this one out. As from the device itself - what you see is what you get in essence, I looked through and wasn’t really able to find an option that would allow you to disable or enable this. After some research, the bolded text looks to be a “PHP-serialized wrapper” that is being sent before your JSON payload.

Regards,
M.