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

It returns the object, then you right click it and return the output to a Json format to get the original code shown below.

 

 

= Json.Document(Web.Contents(DataLocation & SelectCompanyURI & "/Contact/Supplier/?api-version=v2"))

I have the following Parameters defined:

DataLocation "http://localhost:8080/AccountRight/"  (Text Based List of Values Manually entered)

SelectCompanyURI  "d2c78098-1f9c-4334-aee9-27349b3ed6a4'" (Text Based List of Values manually entered)

 

The Datalocation api endpoint return the path required for each company file resource when you initially browse the list, convert it to a table and you can see the path required for the Web Contents code.

 

If i select the path and either Drill Down or Add as A query, how can i add this to the web.contents code line? I think I am missing some quotes maybe?


The code below returns an error, I assume i have the syntax incorrect

DataFormat.Error: Invalid URI: The hostname could not be parsed. Details: URIPath&/Contact/Supplier/?api-version=v2

, 

 

Json.Document(Web.Contents("URIPath&/Contact/Supplier/?api-version=v2"))

This line does work

http://localhost:8080/AccountRight/d2c78098-1f9c-4334-aee9-27349b3ed6a4/Contact/Supplier/?api-version=v2

 

 

URI Path http://localhost:8080/AccountRight/d2c78098-1f9c-4334-aee9-27349b3ed6a4

 

 

Thanks

 

 

miguel's avatar
miguel
Community Admin
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"))
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    M language - Web.Content error : &amp

    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=&amp and replaces the url ...&... to ...&amp....
    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
    • 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