Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

How to pass date variable in API poller GET request

Good evening,

Apologies if this has come up before but I have been searching forums and online and have drawn a blank on this one...!

I need to pass the current date (in iso utc format ie. YYYY-MM-DD) in a GET query in an API poller. The query looks something like this:

www.example.com/.../general

Essentially this will return all entries (items) for 'today'.

I've tested this works using postman using a pre-request variable (this works well):

---------------------
var moment = require('moment');

pm.environment.set('currentdate', moment().format(("YYYY-MM-DD")));

---------------------

But I am not sure how to do this using the Solarwinds API poller? I was thinking maybe I could use an initial GET request to the same API and use the date returned in the header as the date variable, but I would need to somehow convert or reformat this, as the date is returned in a different format (eg. Mon, 23 Sep 2024 21:04:56 GMT). Or maybe there is a public API I can use to return the date in the desired format, store that as a variable and then use that in the next GET request in the same API poller?

Anyway, I hope the above makes sense and apologies if I'm missing something obvious here. Any help and advice very much appreciated :-D

Cheers

Find more posts tagged with

Accepted answers

adam.beedell

I've got some options for you, and then there's script monitors

Option 1) if you hit "$" in an empty URL bar you can see the list of available macros (@solarwinds folks - this needs an obvious button), stuff like lastsync is a date string for around now, I dont think it's particularly easy to beat that OOTB. I dont think this works for you, but you could maybe find a way to place that string in an accessible property, and that could work.
Option 2) You can make a API call in the same poller to something that'll return a formatted date string, including solarwinds itself, you can then store that string as $(date) and use that.

Option 3) Custom script monitors I'm afraid

I expect there's a patch coming in this area but I'm not sure it's next up or anything

All comments

adam.beedell

Option 3) Custom script monitors I'm afraid

I expect there's a patch coming in this area but I'm not sure it's next up or anything

adam.beedell

eg:

chris.mcmorris

Thanks Adam - can you paste in this example query and I'll give it a look / try? Cheers

I think Option 2 is the best option and this is the road I had started down. I was thinking even of using some encoded SWQL that would return the current date in the format I need but..... I wasn't sure I could query SW and the other target API in the same API poller, as they use different settings / credentials etc? Or can I 'share' stored variables between API pollers?

Apologies if these are daft questions but I think I am almost there with this one! :-D

Cheers

adam.beedell

Start with
https://127.0.0.1:17774/SolarWinds/InformationService/v3/Json/Query?query=
Change the 4 to an 8 if you're on one of the last few versions of solarwinds

Then you want to write a SWQL query that produces a date, and then run it through https://www.url-encode-decode.com/ and paste the encoded result in

Ages back I made:

select top 1
case
when length(month(getutcdate())) = 1 AND length(day(getutcdate())) = 1 then concat('"',year(GETUTCDATE()),'-0',month(GETUTCDATE()),'-0',day(GETUTCDATE()),'T00:00:00.000Z"')
when length(month(getutcdate())) = 1 AND length(day(getutcdate())) = 2 then concat('"',year(GETUTCDATE()),'-0',month(GETUTCDATE()),'-',day(GETUTCDATE()),'T00:00:00.000Z"')
when length(month(getutcdate())) = 2 AND length(day(getutcdate())) = 1 then concat('"',year(GETUTCDATE()),'-',month(GETUTCDATE()),'-0',day(GETUTCDATE()),'T00:00:00.000Z"')
when length(month(getutcdate())) = 2 AND length(day(getutcdate())) = 2 then concat('"',year(GETUTCDATE()),'-',month(GETUTCDATE()),'-',day(GETUTCDATE()),'T00:00:00.000Z"')
else '***'
end
as [date] from
orion.nodes

Which was kinda silly and was complicated by getting a 1 or 2 digit return from something

For you you'd want to combine some functions from here: https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions

eg:

Select top 1 concat(DAY(GETUTCDATE()),'- DD (I think you get a single character in days 1-9)') as days from orion.nodes n

adam.beedell

Addressing the other questions: You can address multiple "sites" in one api poller yes, though it's a weird thing to do
You use the same credential if you do, which is a faff, and may put you into one of the other options (unless you use creds that dont use the cred section, but then they're probably unencrypted/stealable)

You can share variables between api pollers within the same poller, but not outside, unless you're using solarwinds to talk to solarwinds