Dynamic Rest API

[jitpbi]

Hi,

I am getting data for my report from the below rest API:

http://186.14.7.4:10000/ZA/v1/MH200_B65/GUIAl/Equipment 

I am building this sample report on the dataset where a deafult date from and to selected:

Now, my requirement is when user select a date from the slicer then it must take the data directly from the source based on the input parameter "start date" and "end date". This is the manadatory requirement from the client which i have to implement.

I need the any possible soultion by which this can be done. I read from few links that we can pass the date parameters to the URL like 

http://186.14.7.4:10000/ZA/v1/MH200_B65/GUIAl/Equipment/request?startdate = " " &&enddate = " "

But i am not able to understand this properly. Please suggest how to achieve this as this is a must for me.

Thanks

[Greg_Deckler]

@jitpbi - Not sure it is supported today but it does look like some form of this is coming:

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave2/power-bi/end-user-editing-que...

[jitpbi]

Hi,

I came through a post which suggest the solution something like this:

let

Source = Json.Document(Web.Contents(http://186.14.7.4:10000/ZA/v1/MH200_B65/GUIAl/Equipment?startTime=2020-08-20&endTime=2020-08-21)),

sd = Date.ToText(StartDate,"MM-dd-YYYY"),
ed = Date.ToText(EndDate,"MM-dd-YYYY"),

url = http://186.14.7.4:10000/ZA/v1/MH200_B65/GUIAl/Equipment?startTime= "& sd &" &endTime="& ed &"

in 

    sd

Please suggest on this.

Thanks

[v-easonf-msft · Accepted solution]

Hi , @jitpbi 

You can  check if the solutions  in  these related posts help.

https://community.powerbi.com/t5/Power-Query/Rest-API-Dynamic-Date-Query/m-p/956246

https://community.powerbi.com/t5/Desktop/How-to-pass-a-dynamic-date-parameter-in-the-json-api-in-pow...

Best Regards,
Community Support Team _ Eason

[amitchandak]

@jitpbi , I doubt that is possible.

@Greg_Deckler  , @parry2k , @ImkeF  , Any suggestion on this.