Does anybody have working examples of how to use PowerShell's Invoke-RestMethod -Method POST to add data to an InfluxDB?
This query works correctly to GET data from the database: # Construct the URI. $uri = "http://metrics-data.monitoring.capsbaitshop:8086/query?db=dns_resolution_metrics&q=SELECT `"zone`", `"value`", `"host`", `"account`" FROM `"count_ns`" WHERE `"zone`" = '172.20.0.0" # Invoke REST GET. Invoke-RestMethod -Method GET -Uri $uri This should be the reciprocal invocation to POST data: # This does not explicitly fail but does not work. # Construct a time stamp. $timeStampNanoSecs = [long] ((New-TimeSpan -Start (Get-Date -Date '1970-01-01') -End ((Get-Date).ToUniversalTime())).TotalSeconds * 1E9) # Define fake data. $hostName = '172.20.0.0' $account = 'NotARealAccount' $zone = 'NotARealZone' $value = 4 # Create a URI. $uri = 'http://metrics-data.monitoring.capsbaitshop:8086/write?db=dns_resolution_metrics' # Create BODY content. $postParams = "count_ns,host=$hostName,account=$account,zone=$zone value=$value" # Invoke REST POST. Invoke-RestMethod -Method POST -Uri $uri -Body $postParams Does anybody see what I'm doing wrong here? It is not a credential issue as this InfluxDB instance is currently purposefully wide open. This curl invocation works correctly, but for simplicity, I would like to get this all working on PowerShell. $dataBinary = "count_ns,host=$hostName,account=$account,zone=$zone value=$value" .\curl.exe -i -X POST 'http://metrics-data.monitoring.capsbaitshop:8086/write?db=dns_resolution_metrics' --data-binary $dataBinary The curl documentation <https://curl.haxx.se/docs/manpage.html> suggests that the --data-binary behavior is a no-op: --data-binary <data> (HTTP) This posts data exactly as specified with no extra processing whatsoever. -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/87cafe22-dbda-4346-abc1-fbaf77cf929d%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
