Inserting Data into BigQuery w/ Temboo

Projects Programming
1

I usually use Temboo for my projects, and they’ve always worked like magic for me. But there seems to be a hiccup this time, and I haven’t been able to troubleshoot the issue.

I’m currently using a DHT22 sensor connected to an Arduino board that I want to capture data from and populate my Google BQ. However, one data pin returns two values; dht22.temp and dht22.humidity. What do i need to do to map the separate values from one pin to two different columns?

Thanks!

2

Hi there,

Thanks for using us, I work at Temboo and I’d be glad to help.

You will want to read the values of the temperature and humidity into variables. You can then edit your pinData variable to include these variables into the JSON string of pinData. Assuming temperature is stored in variable t and humidity is stored in variable h, you can do something like this:

String pinData = "{";
pinData += ""Temperature":" + String(t);
pinData += ",";
pinData += ""Humidity":" + String(h);
pinData += "}";

Hopefully this helps, but definitely reach out to us if you have questions or need more information,
Jasper