I am getting an error from Telegraf when I send information from Particle through the webhook. I publish the following in my Photon’s firmware: int c=10; String data=String::format("{ \"tags\" : {\"id\": \"%s\", \"location\": \"%s\"}, \"values\": {\"capacity\": %d}}", "test", "myLoc", c); Particle.…

ScruffR, I did escape the embedded double quotes in the string I’m publishing. Anyway, it still gives the same error even after I put in the reformatted code you provided. Which JSON is being sent to Telegraf? Is it the JSON in the form of the string I’m publishing in the firmware: {"data":"{ \"t…

Seeing the same problem here. @pique did you ever try the test button in the particle console? That is failing for me, so I’ve not actually tried generating data on particle device yet.

I’d not rely on the result of the TEST button since it only sends a “blank” request to the server which would be refused by most hosts.

added some instrumentation to telegraf and this is what is coming in: {"measurement":"templogger","data":"{\"tags\":{\"id\":\"bec\"},\"values\":{\"temp\":77.54000092,\"hum\":54.60058594}}"} So data is looking like a string instead of a json object, hence the warning: json: cannot unmarshal string…

If I print out what the device is sending, I see: {"tags":{"id":"bec"},"values":{"temp":77.5039978,"hum":52.69042969}} So not sure where the escaping of " characters is happening. It appears that data is always sent as a string ( Publish/Subscribe and JSON data in events ), so its puzzling to me ho…

cbrake, Yeah, I still haven’t been able to figure it out. You’re right–I think it has to do with the data being sent as a String, not a JSON object that can be parsed correctly. Hopefully we can get some advice soon.

[image] cbrake: Its not obvious to me how to instruct the particle cloud to send JSON that looks like: There might be a misconception with escaped characters. When you construct a string (in C/C++, JAVA, ...) that contains double quotes you just write "...\"..." to instruct the compiler not …

ScruffR, It seems like I am making the same mistake as cbrake. The actual JSON that is being published has a mix of escaped quotes and regular quotes. As you said, some double quotes are escaped and others aren’t, causing the JSON to not be unmarshaled: {"data":"{ \"tags\" : {\"id\": \"test\", \"l…

In a custom JSON you should use the nested fields of {{{PARTICLE_EVENT_VALUE}}} to create your own custom JSON. Currently there seems to be an issue with webhook management, so I can’t setup a test webhook to manufacture a showcase.

InfluxDB/Telegraf Webhook JSON error

Firmware

ScruffR June 26, 2018, 5:27am 2

You need to escape embedded double quotes in strings (which wasn't shown before reformatting).
I've reformatted your code to make the escaped symbols show up correctly.

See here on how to do that

Topic		Replies	Views
Particle telegraf and influxDB webhook documentation not so clear Cloud	5	570	July 25, 2023
InfluxDB Webhooks Hell Integrations	17	2359	July 28, 2020
Webhook posting as form-data Troubleshooting	8	1765	March 9, 2019
Webhook not parsing data JSON Troubleshooting	12	1993	April 19, 2018
Webhooks & Parse.com Firmware	36	7477	October 21, 2015

InfluxDB/Telegraf Webhook JSON error

Related topics