Solved

Dynamic unix timestamp in request URL for HTTP client origin

  • 4 November 2022
  • 1 reply
  • 115 views
HåkonD
Rank

The origin has a parameter ‘since’ that is a UNIX timestamp, which tells the API to give all records since the given timestamp. Looks something like https://……./v1/ssns?since=1667257200000. I would like this value to be dynamic. For example, if I set my pipeline to run once each day I would like the timestamp to give me only records from the last 24 hours.

I’ve tried variations of like ?since={time:dateTimeToMilliseconds(time:now())-86400000}, but I can’t find the right syntax. Is it possible to put this kind of statement in the resource URL that returns a unix timestamp integer? Or if not, any other way to do this?

icon

Best answer by saleempothiwala 4 November 2022, 19:53

View original

1 reply

saleempothiwala
Rank
Userlevel 4
Badge

@HåkonD 

 

You can use a simple Raw Data Source as origin to generate a single record. This can be your starting point. Next, add an Expression Evaluator to create a field with your date-time calculation. Let us call it calc_since. and also create a new field called http_url that creates the whole url for you as a field.

You can then add an HTTP client processor and pass ${record:value(‘/http_url’)} as the value for URL. This will pass on the URL. Also preview will give you a clear view of how your URL looks like.

Hope it helps.

Reply


Terms & Conditions