Forum Discussion
Solved
Cannot Apply operator Text and List Conversion required? or syntax error with Parameter usages
Hi Community I am trying to paremterise the file path for a json source, he data source for json source. I have above query which returns a list containing the file path of the data source as f...
Your formula is passing a static string:
Json.Document(Web.Contents("URIPath&/Contact/Supplier/?api-version=v2"))and I believe that you're going after something like:
Json.Document(Web.Contents(Text.From(URIPath)&"/Contact/Supplier/?api-version=v2"))
M language - Web.Content error : &
Hello,
It’s been 2 days I’m blocked, I can’t find the answers à forums.
My formula M langage is Web.Contents(« http://...&... »&[IDMaster]& « ....&... ») as Binary
This gives me an error message : Operator=& and replaces the url ...&... to ...&....
My goal is to view the images from that Dynamic URL using power query, power pivot and then power view.
It work with static url but not with a dynamic one
I’ve tried to add Text.From but I get the same error
Thank you in advance for you help
Claire
Anonymous
Hi, where are your quotes? you need to break up your URL with quotes for all text items in your URL.
If you post the full URL without parameters that might help see the problem...but for example, the statement should be similar to:
Web.Contents("http:/myweb/" & IDMASTER & PARAMETER2) . Also ensure your parameters are setup as text.
Hello THEG72,
I found the solution with the help of Mickael.
I needed to declare the filed IDMASTER as a string.
So the right code is : Web.contents("http://...."Text.From([IDMASTER])&"....jpg")
Thank you for your reply
Anonymous
Glad you got it solved..Yes the URL has to be all text.