google spreadsheet logging loraWAN data works with strange character for payload raw and decoded

Question

Hi Squix,

I followed your blog on using the http dataintegration with your description how to log into a google spread sheet.

Works fine except the payload formats are strange

payload raw:           01B9                          in google spreadsheet:               Abk=

payload decoded:

{
  "voltage": 11.97                                       in google spreadsheet:               �
}

do you have any idea?

btw the process further works very good, like it.

Felix

below the google result

jsonData.app_id

jsonData.dev_id

jsonData.hardware_serial

jsonData.port

jsonData.counter

jsonData.payload_raw

jsonData.payload_decoded

jsonData.metadata.time

jsonData.metadata.frequency

jsonData.metadata.modulation

jsonData.metadata.data_rate

 

arduinolorahat1

voltage_sensor

70B3D57EF0006B4C

1

21883

Abk=

�

2017-09-30T20:11:31.194226064Z

868100000

LORA

SF7BW125

Answer 1

My first guess was that the payload was base64 encoded and needed some decoding. A quick test with this tool proved otherwise: https://www.base64decode.org/

So right now I'm not really sure what is happening... Maybe someone else has an idea?