Forum Discussion
No columns found
I am using Web.Contents and I have the below Invoked Custom Function. It says no columns found when I expand the Invoked Custom Function. What am I doing wrong.
let a = (northing as number, easting as number) =>
let Source = Json.Document(Web.Contents( "http://www.bgs.ac.uk/data/webservices/CoordConvert_LL_BNG.cfc?method=BNGtoLatLng",
[ Query= [ easting=Text.From(easting), northing=Text.From(northing) ] ] ) )
in Source
in a
Hi Anonymous ,
Glad you have resolved it. 😉 You could accept your answer as solution. Others who have the same questions will benefit from this thread. Thanks!!
7 Replies
Hi Anonymous ,
Did you try the query with hardcoded values instead? If that worked, you have to use a tool like Fiddler to see what query both of your versions actually send to the interweb and compare them.
If you cannot solve the problem by yourself, please post the code that both queries returned here in the post so that I can follow up.
If even the hardcoded version didn't work, you have to find another means that creates a valid query to get the string to compare against. A tool like Postman could help you with it.I couldn't get it to fail. What values are you passing to the function?
