Delete influxdb data using timestamp

delete-data-influxdb.sh

curl -vkG 'https://<influxdb_url>/query?db=<DATABASE>&epoch=ns' \
-u *****:******** \
--data-urlencode "q=SELECT * FROM jenkins_data WHERE prefix='hero'" |\
jq -r "(.results[0].series[0].values[][0])" > delete_timestamps.txt
 

for i in $(cat delete_timestamps.txt); do
  echo $i;
  curl -G 'https://<influxdb_url>/query?db=<DATABASE>=ns' \
    -u ****:******** \
    --data-urlencode "q=DELETE FROM jenkins_data WHERE time=$i";
done