Forum Discussion

hlombard's avatar
hlombard
Frequent Visitor
9 years ago
Solved

Passing dynamic date parameters to Web query

I am able to pull data for a date range from our web service. I use a web query with the following string:   https://reports.xxxxxxxx.net/generate.py/ProcessedTxnsRecon.csv?StartDate=20170701&EndDa...
Need Help
  • ImkeF's avatar
    ImkeF
    9 years ago

    = Csv.Document(Web.Contents("https://reports.xxxxx.net/generate.py/ProcessedTxnsRecon.csv?StartDate="&Text.Combine(List.Transform(Record.FieldValues(Date.ToRecord(Date.From(DateTime.LocalNow()))), each Text.PadStart(Text.From(_), 2, "0")))&"&EndDate="&Text.Combine(List.Transform(Record.FieldValues(Date.ToRecord(Date.AddMonths(Date.From(DateTime.LocalNow()),-MonthParameter))), each Text.PadStart(Text.From(_), 2, "0")))& ""),[Delimiter=",", Columns=43, Encoding=1252, QuoteStyle=QuoteStyle.None])

     

    with

panipat1990's avatar
panipat1990
Helper III
8 years ago

Dear Team,

 

How to apply these codes. i am not understanding how to apply.Kindly help me for resolving.it's very urgent

panipat1990's avatar
panipat1990
Helper III
8 years ago

Hi Imke,

 

Kindly tell me how to apply these code on table.

 

First of all how to make Max date of FACT_table

Then How to apply it Parameter and how to restrict in fact table through parameter.kindly help me