cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

HELP NEEDED: GETING DATA FROM API

I have to pull a data from a websource that provides a webAPI to downlood the data, here's a tamplate:

 

https://hq.appsflyer.com/export/com.greatapp/partners_report/v5?api_token=xxxx
&from=2018-04-09&to=2018-05-09&media_source=googleadwords_int

 

The problem is that, i need to insert a data range on this link, as you can see in the line "from=2018-04-09&to=2018-05-09".

This data will be used to make reports from a certain date up to today's date. But i need to do it without having to change the url everyday.

 

Is there any way of doing this using DAX?

 

Here is an example of a pull:

Sem título.png

I would like the data from July ( 2020-07-01 ) until this date. How to do that?

3 REPLIES 3
Super User II
Super User II

Hi @badluckmath 

You can create two parametrs FromDate and ToDate for the same and use it in the example to pull 

for example 

= csv.Dcoument(web.Contents("https://hq.appsflyer.com/export/com.greatapp/partners_report/v5?api_token=xxxx&from="&FromDate&"&to="&ToDate&"&media_source=googleadwords_int"))





Hope it resolves your issue? 
Please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos, Press the thumbs up button!!👍
Regards,
Pranit

I need the date in the format yyyy-mm-dd, how would this be?

 

FORMAT(TODAY(), "YYYY-MM-DD") is not working for me, see how it looks:

 

"....from=2020-07-01&to="& FORMAT(TODAY(), "YYYY-MM-DD")&"&additional_fields=keyword_id,store_reinstall,...."

@badluckmath

Replace the date range text with the following text. If you created a parameter. replace #date(2020,7,1) with the parameter name

= ".... from=" & Date.ToText(#date(2020,7,1),"YYYY-MM-DD")& "&to=" & Date.ToText(Date.From(DateTime.FixedLocalNow()), "YYYY-MM-DD")


Result

.... from-2020-07-01-to-2020-09-20

________________________

If my answer was helpful, consider Accepting it as the solution to help other members find it

Click the Thumbs-Up icon if you like this answer 🙂

Youtube Linkedin





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors