Comments (5)
I recreated a new token and still have an incomplete bucket list.
This is necessarily a problem to the API https://eu-central-1-1.aws.cloud2.influxdata.com/api/v2/
which does not make the link between the token and the authorized buckets
I made a ticket to influxData support to give me an answer
Thanks a lot for your help
from influxdb-gds-connector.
@dmeireles, thanks for using our connector.
It looks like that your token doesn't have permission to read from selected bucket. Could you please check the following queries:
- Query to Buckets:
curl "https://eu-central-1-1.aws.cloud2.influxdata.com/api/v2/query?org=YOUR_ORG" \
-H "Accept: application/csv" \
-H "Authorization: Token YOUR_TOKEN" \
-H "Content-type: application/vnd.flux" \
-d 'buckets() |> rename(columns: {"name": "_value"}) |> keep(columns: ["_value"]) |> sort(columns: ["_value"], desc: false)'
- Query to Measurements:
curl "https://eu-central-1-1.aws.cloud2.influxdata.com/api/v2/query?org=YOUR_ORG" \
-H "Accept: application/csv" \
-H "Authorization: Token YOUR_TOKEN" \
-H "Content-type: application/vnd.flux" \
-d 'import "influxdata/influxdb/v1"
v1.tagValues(
bucket: "YOUR_SELECTED_BUCKET",
tag: "_measurement",
predicate: (r) => true,
start: duration(v: uint(v: 1970-01-01) - uint(v: now()))
)'
- Query to Tags:
curl "https://eu-central-1-1.aws.cloud2.influxdata.com/api/v2/query?org=YOUR_ORG" \
-H "Accept: application/csv" \
-H "Authorization: Token YOUR_TOKEN" \
-H "Content-type: application/vnd.flux" \
-d 'import "influxdata/influxdb/v1"
v1.tagKeys(
bucket: "YOUR_SELECTED_BUCKET",
predicate: (r) => r._measurement == "YOUR_SELECTED_MEASUREMENT",
start: duration(v: uint(v: 1970-01-01) - uint(v: now()))
)
|> filter(fn: (r) => r._value != "_start" and r._value != "_stop" and r._value != "_measurement" and r._value != "_field")'
- Query to Fields:
curl "https://eu-central-1-1.aws.cloud2.influxdata.com/api/v2/query?org=YOUR_ORG" \
-H "Accept: application/csv" \
-H "Authorization: Token YOUR_TOKEN" \
-H "Content-type: application/vnd.flux" \
-d 'from(bucket: "YOUR_SELECTED_BUCKET")
|> range(start: time(v: 1))
|> filter(fn: (r) => r["_measurement"] == "YOUR_SELECTED_MEASUREMENT")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> drop(columns: ["_start", "_stop", "_time", "_measurement"])
|> limit(n:1)'
Regards
from influxdb-gds-connector.
Hello,
Thank you for your reply.
I did the tests you asked me and I have the feeling that the buckets that contain _ in their name have not return for a few days (ex : test_pixxid or test_hsecaraibes in picture).
The other buckets are available in the result (ex : hsem1)
The result of the query for the list of buckets :
curl "https://eu-central-1-1.aws.cloud2.influxdata.com/api/v2/query?org=**************" \
-H "Accept: application/csv"
-H "Authorization: Token z*****************************************************3Eog=="
-H "Content-type: application/vnd.flux"
-d 'buckets() |> rename(columns: {"name": "_value"}) |> keep(columns: ["_value"]) |> sort(columns: ["_value"], desc: false)'
,result,table,_value
,_result,0,hsem1
Maybe you exclude names with underscore ?
The majority of my buckets are named ans, do you think you can revert to the previous operation?
Thank you
from influxdb-gds-connector.
Hello,
Thank you for your reply.
I did the tests you asked me and I have the feeling that the buckets that contain _ in their name have not return for a few days (ex : test_pixxid or test_hsecaraibes in picture).
The other buckets are available in the result (ex : hsem1)The result of the query for the list of buckets :
curl "https://eu-central-1-1.aws.cloud2.influxdata.com/api/v2/query?org=**************" \
-H "Accept: application/csv"
-H "Authorization: Token z*****************************************************3Eog=="
-H "Content-type: application/vnd.flux"
-d 'buckets() |> rename(columns: {"name": "_value"}) |> keep(columns: ["_value"]) |> sort(columns: ["_value"], desc: false)'
,result,table,_value
,_result,0,hsem1
The same query is also used for retrieving buckets in connector. As you see at your result output there is only bucket hsem1
. Try to generate new token.
Maybe you exclude names with underscore ?
No, there isn't this type of exclusion.
I ran test for a following token:
and results are correct:
curl "https://us-west-2-1.aws.cloud2.influxdata.com/api/v2/query?org=MY_ORG" \
-H "Accept: application/csv" \
-H "Authorization: Token MY_TOKEN" \
-H "Content-type: application/vnd.flux" \
-d 'buckets() |> rename(columns: {"name": "_value"}) |> keep(columns: ["_value"]) |> sort(columns: ["_value"], desc: false)'
,result,table,_value
,_result,0,github
,_result,0,test_underscore
from influxdb-gds-connector.
You are welcome
from influxdb-gds-connector.
Related Issues (16)
- Compatibility with InfluxDB 1.8.x
- InfluxDB Connector Issue HOT 2
- Error on measurments with a tag with different values HOT 4
- GDS Connector not found HOT 2
- Error when trying to add the connector HOT 1
- Publish connector as a Partner connector HOT 12
- Metric data type can not be changed back to it's original data type. HOT 2
- InfluxDB Connector Issue HOT 1
- Not an issue HOT 3
- Datasource cannot retrieve list of Buckets HOT 1
- InfluxDB Connector Issue HOT 1
- InfluxDB Beta is changing default port from 9999 to 8086 for the next release
- Metrics and Dimensions are imported around the wrong way HOT 7
- Improve error message
- InfluxDB Connector Issue HOT 34
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from influxdb-gds-connector.