How we Pass Start and End Date in REST API URL as parameter in Azure Data Factory

Question

Hi All,

we are using Microsoft API in Azure data factory copy activity example given below

https://management.azure.com/subscriptions/{/subscriptionsId}/providers/Microsoft.Consumption/usageDetails?$expand=meterDetails,additionalProperties&$filter=properties/usageEnd ge '2023-12-01' AND properties/usageEnd le '2023-12-31' &$top=30&api-version=2019-01-01

Here we can see two date Parameter 2023-12-01 and 2023-12-01, we need to replace this with variable adddays(utcnow(),-1) as start date and utcnow() as end date

please help

Answer 1

Hello @manish verma !

I can see you need to add Date parameters into your API Call to replace this with variable adddays(utcnow(),-1) as start date and utcnow() as end date

Use this for start

@{formatDateTime(adddays(utcnow(),-1), 'yyyy-MM-dd')}. This expression calculates the date one day before the current UTC date and formats it as 'yyyy-MM-dd'.

And ;

@{formatDateTime(utcnow(), 'yyyy-MM-dd')}. This expression gets the current UTC date and formats it as 'yyyy-MM-dd'.

At the end combined it should look like this:

https://management.azure.com/subscriptions/{/subscriptionsId}/providers/Microsoft.Consumption/usageDetails?$expand=meterDetails,additionalProperties&$filter=properties/usageEnd ge '@{formatDateTime(adddays(utcnow(),-1), 'yyyy-MM-dd')}' AND properties/usageEnd le '@{formatDateTime(utcnow(), 'yyyy-MM-dd')}' &$top=30&api-version=2019-01-01

Can you please try ? I have not been able to try this out so give it a go and kindly provide your feedback !

---

I hope this helps!

The answer or portions of it may have been assisted by AI Source: ChatGPT Subscription

Kindly mark the answer as Accepted and Upvote in case it helped!

Regards

Answer 2

Hello @manish verma !

I think it is usageDetail , please correct it and re try !

https://learn.microsoft.com/en-us/dotnet/api/microsoft.azure.management.consumption.models.usagedetail?view=azure-dotnet-legacy

Constructors

UsageDetail()	Initializes a new instance of the UsageDetail class.
UsageDetail(String, String, String, IDictionary<String,String>, String, String, Nullable<DateTime>, Nullable<DateTime>, String, String, String, String, Nullable<Decimal>, Nullable<Decimal>, Nullable<Decimal>, Nullable<Boolean>, String, MeterDetails, String, String, String, String, String, String, String, String)	Initializes a new instance of the UsageDetail class.