hi,
im trying to parse data from my influxdb bucket into tulip via a connector.
however the data comes back in csv format from influxdb and when i try to pull a output, i get this error “Unexpected token , in JSON at position 0”
the body of my test results look like this:
is there a way to change it from csv to json or how do i do this?
i know i can probably just write a script that gets the info from the bucket and then push it to a tulip table and read it from there, but just wondering if its possible via the connector
Defaulting back to plain text is an indication that we fail to parse the response into the desired format. In this case, it looks like influx is returning CSV data (much like this example). This appears to be the Annotated CSV format.
This appears to be the only format that influx supports.
Short of adding some sort of middleware that is parsing this payload into a more standard json or xml format, I don’t think there is a good path to be able to ingest this data into Tulip today. I will add a feature request for us to evaluate adding support for this as a response decoding type.
Pete
ninja edit - it does look like the v1 endpoint supports json response type, and that should be compatible with Tulip