Forum Discussion

yebenesPW's avatar
yebenesPW
Frequent Visitor
3 years ago

Setting a scheduled refresh on a Dynamic Data

Hey everyone, 

 

I need to program a schedule but i use dynamic data so i need to use Relative Paths, when i try to do that with the code under i got the error 

 

 

Expression.Error: Se han pasado 3 argumentos a una función que espera entre 1 y 2.
Detalles:
    Pattern=
    Arguments=[List]

 

 

The param url contains something like this "730214/runs/3246632"

 

 

let
    content = "{
		""method"": ""post"",
		   ""body"": {}
	}",

    Origen =  Json.Document(Web.Contents( "https://test.com/test/",
    [RelativePath = url & "/reports/cookie-privacy"], 
    [Headers=[#"content-type"="application/json", Authorization="Bearer " &#"GetToken"()], 
    Content=Text.ToBinary(content)])),
    #"Convertido en tabla" = Record.ToTable(Origen)
in
    #"Convertido en tabla"

 

 

Thanks for your help

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi yebenesPW  I don't understand the need for "url" in the relativepath.  What does url contain?  It is possible that Power is generating the following web call?

     

    https://test.com/test/https://test.com/test//reports/cookie-privacy

     

    This would look better

     

    let
    content = "{
		""method"": ""post"",
		   ""body"": {}
	}",
    url = "https://test.com/test",
    Origen =  Json.Document(Web.Contents( url,
    [
       RelativePath = "/reports/cookie-privacy", 
       Headers=[#"content-type"="application/json", Authorization="Bearer " &#"GetToken"()], 
       Content=Text.ToBinary(content)
    ]
   )
  ),
    #"Convertido en tabla" = Record.ToTable(Origen)
in
    #"Convertido en tabla"