Forum Discussion
TO pass variable value dynamically in WEB URL Data Factory
I have a pipeline where i request a TOKEN authentication followed by fetching values using the TOKEN from third party application. my WEB URL settings looks like below: @concat('https://myapp/api/...
Hey bro, do like this: Set variable start with
@div(sub(ticks(concat(formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd'), 'T00:00:00.0000000Z')), ticks('1970-01-01T00:00:00.0000000Z')), 10000),
and set variable end with
@div(sub(ticks(concat(formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd'), 'T23:59:59.0000000Z')), ticks('1970-01-01T00:00:00.0000000Z')), 10000).
I guess that what you want is converting the timestamp into standard ticks(The number of milliseconds passed since 1970-01-01). But the ADF built-in function ticks returns the number of nanoseconds passed since 0000-01-01, so you need do some processing after getting it.