Forum Discussion
Cannot Apply operator Text and List Conversion required? or syntax error with Parameter usages
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"))
Hi THEG72,
In your scenario, what will Web.Contents() return without Json.Document?
Web.Contents("http://localhost:8080/AccountRight/" & SelectCompany & "/Contact/Supplier/?api-version=v2")Thanks,
Xi Jin.
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
,
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