Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
I have a situation where I'm calling into a Rest API with transactional data. I need to pass in a date/time as part of the API call...
apiUrl = "BASE-URL/transactions/search/recordsModifiedBetween?From="&LastSearchTime&"&To="&DateTime.LocalNow&"",
The goal is to log the time the last search ran and pass that as a parameter into the query so that I only get modified records from the API during a specific window of time. I need to implement this across 100 or so calls, so updating the Parameter manually isn't an option.
Any thoughts would be greatly appreciated.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |