# Upload from influx db
**URL:** https://forum.sensor.community/t/upload-from-influx-db/4463
**Category:** FAQ
**Created:** [February 25, 2025, 4:36pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463 "2025-02-25T16:36:41Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@Tanja](https://forum.sensor.community/u/Tanja)
#### Post date: [February 25, 2025, 4:36pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/1 "2025-02-25T16:36:41Z")
is there already a solution for just pushing the data from influx to your servers? we have also a lot of historical data, would it be also possible to send that to you?
---
### Author:  [@pjg](https://forum.sensor.community/u/pjg)
#### Post date: [February 25, 2025, 6:57pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/3 "2025-02-25T18:57:56Z")
What kind of data do you have ?
Which sensor(s)?
Which time span ?
---
### Author:  [@Tanja](https://forum.sensor.community/u/Tanja)
#### Post date: [February 25, 2025, 7:53pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/4 "2025-02-25T19:53:18Z")
i have a SDS011 with a bme280, i fed them directly into my influxdb, i started logging 2023-02-15, still doing so. these are the fields i have:
```auto
time BME280_humidity BME280_pressure BME280_temperature SDS_P1 SDS_P2 interval max_micro min_micro node samples signal
```
---
### Author:  [@pjg](https://forum.sensor.community/u/pjg)
#### Post date: [February 26, 2025, 5:42am UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/5 "2025-02-26T05:42:44Z")
For collecting the data from the beginning I don’t know.
But for current data, you just have to forward from influx db to SC API with POST requests:
> **[APIs](https://github.com/opendata-stuttgart/meta/wiki/APIs)**
>
> Opendata Stuttgart organisiert und reguliert. Contribute to opendata-stuttgart/meta development by creating an account on GitHub.
Prepare everything for the SC API and also the Madavi API (2 requests) and then I will help you to finalize the requests because there is a small thing to take care of.
---
### Author:  [@Tanja](https://forum.sensor.community/u/Tanja)
#### Post date: [February 27, 2025, 2:52pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/6 "2025-02-27T14:52:45Z")
hmmm, thank you very much. i found this page in english. i was hoping someone already built such a forwarder tool. but i guess, i have to do it then. will take some time, being swamped with other stuff. but i will have come back to this.
---
### Author:  [@pjg](https://forum.sensor.community/u/pjg)
#### Post date: [February 27, 2025, 4:35pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/7 "2025-02-27T16:35:32Z")
Hi,
These are normal POST requests with headers and data as json.
---
### Author:  [@Tanja](https://forum.sensor.community/u/Tanja)
#### Post date: [February 27, 2025, 4:39pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/8 "2025-02-27T16:39:47Z")
sure, sounds easy enough, i just hoped someone already had this done.
---
### Author:  [@pjg](https://forum.sensor.community/u/pjg)
#### Post date: [February 27, 2025, 4:45pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/9 "2025-02-27T16:45:41Z")
A lot of people are doing it currently. Actually I found everything in my notes:
**SC server:**
url: [https://api.sensor.community/v1/push-sensor-data/](https://api.sensor.community/v1/push-sensor-data/)
method: POST
content\_type: ‘application/json’
headers:
X-Pin: 1
X-Sensor: Board ID
```auto
{
"software_version": "",
"sensordatavalues":[
{"value_type":"P1","value":""},
{"value_type":"P2","value":""}
]
}
```
url: [https://api.sensor.community/v1/push-sensor-data/](https://api.sensor.community/v1/push-sensor-data/)
method: POST
content\_type: ‘application/json’
headers:
X-Pin: 11
X-Sensor: Board ID
```auto
{
"software_version": "",
"sensordatavalues":[
{"value_type":"temperature","value":""},
{"value_type":"pressure","value":""},
{"value_type":"humidity","value":""}
]
}
```
**Madavi server:**
url: [https://api-rrd.madavi.de/data.php](https://api-rrd.madavi.de/data.php)
method: POST
content\_type: ‘application/json’
headers:
X-Pin: 1
X-Sensor: Board ID
```auto
{
"software_version": "",
"sensordatavalues":[
{"value_type":"SDS_P1","value":""},
{"value_type":"SDS_P2","value":""}
]
}
```
url: [https://api-rrd.madavi.de/data.php](https://api-rrd.madavi.de/data.php)
method: POST
content\_type: ‘application/json’
headers:
X-Pin: 11
X-Sensor: Board ID
```auto
{
"software_version": "",
"sensordatavalues":[
{"value_type":"BME280_temperature","value":""},
{"value_type":"BME280_pressure","value":""},
{"value_type":"BME280_humidity","value":""}
]
}
```
The problem is the Board ID.
There is no InfluxDB-…
@ricki-z An idea ?
---
### Author:  [@Tanja](https://forum.sensor.community/u/Tanja)
#### Post date: [February 28, 2025, 7:17pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/10 "2025-02-28T19:17:18Z")
thanks for sharing your awesome notes! \<3
why cannot i use the original board id from the device that dumps to my influx?
---
### Author:  [@pjg](https://forum.sensor.community/u/pjg)
#### Post date: [February 28, 2025, 9:40pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/11 "2025-02-28T21:40:42Z")
Yes you can! Is it an esp ?
---
### Author:  [@Tanja](https://forum.sensor.community/u/Tanja)
#### Post date: [March 7, 2025, 2:02am UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/12 "2025-03-07T02:02:18Z")
yes. padding to 20 chars.
---
### Author:  [@Tanja](https://forum.sensor.community/u/Tanja)
#### Post date: [March 7, 2025, 2:44am UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/13 "2025-03-07T02:44:49Z")
three questions:
1. the “values” in the json payload, do they have to be strings, or can they be floats?
2. the software\_version, don’t really know, is N/A, null, or something else acceptable?
3. the boardid, would that be ''esp8266-1234567" or only the numbered part “1234567”?
apart from these details i think i have a first draft that might work (the boardid needs to be set correctly, and the request.posts uncommented, but otherwise i’d give it a try):
```python
#!/usr/bin/env python
from influxdb import InfluxDBClient
import time, requests, datetime
boardid = 'esp8266-1234567'
lastseen=None
def push(d):
global lastseen
# [{'time': '2025-03-07T02:00:54.099740Z', 'BME280_humidity': 73.43, 'BME280_pressure': 101565.53, 'BME280_temperature': 6.63, 'SDS_P1': 13.2, 'SDS_P2': 8.0, 'interval': 10000.0, 'max_micro': 1137.0, 'min_micro': 23.0, 'node': 'esp8266-1234567', 'samples': 416113.0, 'signal': -93.0}]
ts = datetime.datetime.fromisoformat(d['time'][:-1]).replace(tzinfo=datetime.timezone.utc)
if ts == lastseen: return
now = datetime.datetime.now(datetime.timezone.utc)
if(ts",
"sensordatavalues":[
{"value_type":"P1","value":d['SDS_P1']},
{"value_type":"P2","value":d['SDS_P2']}]}
headers = { 'X-Pin': 1, 'X-Sensor': boardid }
#requests.post('https://api.sensor.community/v1/push-sensor-data/', json=data, headers = headers)
data = { "software_version": "",
"sensordatavalues":[
{"value_type":"SDS_P1","value":d['SDS_P1']},
{"value_type":"SDS_P2","value":d['SDS_P1']}]}
#requests.post('https://api-rrd.madavi.de/data.php', json=data, headers=headers)
#
headers = { 'X-Pin': 11, 'X-Sensor': boardid }
data = { "software_version": "",
"sensordatavalues":[
{"value_type":"temperature","value":d['BME280_temperature']},
{"value_type":"pressure","value":d['BME280_pressure']},
{"value_type":"humidity","value":d['BME280_humidity']}]}
#requests.post('https://api.sensor.community/v1/push-sensor-data/', json=data, headers = headers)
data = { "software_version": "",
"sensordatavalues":[
{"value_type":"BME280_temperature","value":d['BME280_temperature']},
{"value_type":"BME280_pressure","value":d['BME280_pressure']},
{"value_type":"BME280_humidity","value":d['BME280_humidity']}]}
#requests.post('https://api-rrd.madavi.de/data.php', json=data, headers=headers)
# Create an InfluxDB client
client = InfluxDBClient(database="sensors")
# Monitor new values in a loop
try:
while True:
rs = client.query('select * from feinstaub ORDER BY time DESC LIMIT 1')
last = list(rs.get_points())[0]
push(last)
time.sleep(10) # Adjust the sleep time as needed
except KeyboardInterrupt:
print("Monitoring stopped.")
# Close the client
client.close()
```
---
### Author:  [@pjg](https://forum.sensor.community/u/pjg)
#### Post date: [March 7, 2025, 7:18am UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/14 "2025-03-07T07:18:55Z")
_the “values” in the json payload, do they have to be strings, or can they be floats?_
String mit . in “”
_the software\_version, don’t really know, is N/A, null, or something else acceptable?_
You can put what you want
_the boardid, would that be ''esp8266-1234567" or only the numbered part “1234567”?_
@ricki-z I can’t remember…
---
### Author:  [@Tanja](https://forum.sensor.community/u/Tanja)
#### Post date: [March 7, 2025, 2:26pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/15 "2025-03-07T14:26:49Z")
looks like it is ‘eps8266-1234567’ looking at the source:
```c
./airrohr-firmware/airrohr-firmware.ino: http.addHeader(F("X-Sensor"), String(F(SENSOR_BASENAME)) + esp_chipid);
```
---
### Author:  [@Tanja](https://forum.sensor.community/u/Tanja)
#### Post date: [March 7, 2025, 3:44pm UTC](https://forum.sensor.community/t/upload-from-influx-db/4463/16 "2025-03-07T15:44:38Z")
so got this running, and on api-rrd.madavi i see data being processed.
thank you for all the help. if anyone needs it, this is my final script
```python
#!/usr/bin/env python
from influxdb import InfluxDBClient
import time, requests, datetime, json
boardid = 'esp8266-1234567'
lastseen=None
def push(d):
global lastseen
# [{'time': '2025-03-07T02:00:54.099740Z', 'BME280_humidity': 73.43, 'BME280_pressure': 101565.53, 'BME280_temperature': 6.63, 'SDS_P1': 13.2, 'SDS_P2': 8.0, 'interval': 10000.0, 'max_micro': 1137.0, 'min_micro': 23.0, 'node': 'esp8266-1234567', 'samples': 416113.0, 'signal': -93.0}]
if d['node'] != boardid: return
ts = datetime.datetime.fromisoformat(d['time'][:-1]).replace(tzinfo=datetime.timezone.utc)
if ts == lastseen: return
now = datetime.datetime.now(datetime.timezone.utc)
if(ts