The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello, I'm making a request in an API, but one of the parameters is the current date.
Currently, the query is done as follows.
let
body = Json.FromValue([
call = "****",
app_key = app_key,
app_secret = app_secret,
param = {
[
nPage = 1,
nRegPerPage = 300,
dDataPosicao="09/03/2023",
cDisplayAll = "N",
code_local_stock = 0
]
}
]),
header = [
#"Content-Type" = "application/json"
],
request = Json.Document(Web.Contents("https://*******************"), 1252)
in
request
I need dDataPosicao="09/03/2023", to update to the current date, in this format.
DateTime.ToText(DateTime.LocalNow(),"dd/MM/yyyy")