bkayser / newrelicr Goto Github PK

Hi,

I was trying to use the function "nrdb_query" as described in https://github.com/bkayser/NewRelicR/blob/a0755cfc003ec5e62883d3c6e57e702473cb55d2/R/nrdb_api.R.

However, I keep receiving the NRQL syntax error and I cannot seem to resolve it. Could you please advise? Is there anything I need to keep in mind when defining the function inputs?

Here is the query:
nrdb_query(account_id='xxx',api_key='xxx',nrql_query="select count(*) from PageView facet name")

The account_id I took from the NR Insights URL (e.g. https://insights.newrelic.com/accounts/<account_id>/) and I generated the api_key as described in https://docs.newrelic.com/docs/insights/new-relic-insights/adding-querying-data/querying-your-data-remotely#register.

Many thanks in advance.

Best regards,
David