Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
3 years ago

windsor.ai API / date question

Hello all,   i dont know if someone has experience with windsor.ai but I have one date question concerning the windsor.ai API:   I use windsor.ai to import Bing Ads data into Power BI via the cre...
Need Help
artemus's avatar
artemus
Microsoft Employee
3 years ago

You can do this like:

"https://somewebsite.example/a/b/c?start=" & DateTimeZone.ToText(DateTimeZone.FixedUtcNow() - #duration(365 * 3, 0, 0, 0), [Format = "yyyy-MM-dd", Culture = ""]) & "&foo=bar"

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
3 years ago

Hi Artemus,

 

thanks for your reply. Something with the Format seems to be not ok:

 

Expected Token: Comma:

 

 

My whole query looks like:

 

= Csv.Document(Web.Contents("https://connectors.windsor.ai/all?api_key=[your API key] & DateTimeZone.ToText(DateTimeZone.FixedUtcNow() - #duration(365 * 3, 0, 0, 0), [Format = "yyyy-MM-dd", Culture = ""]) & fields=account_name,campaign,clicks,spend,impressions,date,adnetwork_conversions,&_renderer=csv"),[Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.None])