Forum Discussion

THEG72's avatar
THEG72
Helper V
8 years ago
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...
Need Help
  • miguel's avatar
    miguel
    8 years ago

    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"))
THEG72's avatar
THEG72
Helper V
8 years ago

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.

 

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • THEG72's avatar
    THEG72
    Helper V
    8 years ago

    Anonymous

     

    Glad you got it solved..Yes the URL has to be all text.