REST API code

#1

I had this saved before NR One, but I have list it. There was a document that contained all the API code to write NRQL commands and run via linux servers.
Ex:
spaces = %20
, = %2C

Changing this code
select DaysToExpiration,ExpirationDate,Url,SupportGroup FROM SSLCertificateCheck where DaysToExpiration <= 15 ORDER BY DaysToExpiration since 24 hours ago limit 1000

to this.
“https://insights-api.newrelic.com/v1/accounts/752702/query?nrql=SELECT%20DaysToExpiration%2CExpirationDate%2CUrl%2CSupportGroup%20FROM%20SSLCertificateCheck%20WHERE%20DaysToExpiration%20<%3D%2015%20ORDER%20BY%20DaysToExpiration%20since%2024%20hours%20ago%20limit%201000”

looking for the table that has all the changes needed.
If you can push me in the correct direction (URL) it would be greatly appreciated.

Thanks in advance

#2

Where do I find the conversion data dictionary that tells me in curl commands
that space = %20
, = %2C
etc…
I have wasted an entire day looking for this document but there has been nothing. I stumbled on this in the past, but I lost my uri.
Trying to create new curl commands to query data etc…

#3

Hi, @ron.hansen: https://www.w3schools.com/tags/ref_urlencode.ASP

1 Like