Import json data

InfluxDB 2
1

I want to import the data below, to influxdb 2.
Beginner friendly way - please :slight_smile:
I use node-red

msg.payload : Object

object

total: 24

filters: “{“PriceArea”:“DK1”}”

sort: “HourDK ASC”

dataset: “Elspotprices”

records: array[24]

[0 … 9]

0: object

HourDK: “2022-10-04T00:00:00”

SpotPriceDKK: 1527.97998

1: object

HourDK: “2022-10-04T01:00:00”

SpotPriceDKK: 1402.390015

2: object

3: object

4: object

5: object

6: object

7: object

8: object

9: object

[10 … 19]

[20 … 23]

2

Hi @tollehenrik,
Welcome to the community! The best way to do this is via telegraf. Here is a great blog to get you started: How to Parse JSON with Telegraf into InfluxDB Cloud | InfluxData