custom function

[kentan2608]

I have created a custom Function in Power BI as follow:

let
CallAPI= (
URL as text,
Token as text
) as any =>
let

WebResponse = Web.Contents(URL&"?UIN="&Token)
in
WebResponse

in
CallAPI

And then I try to call the above function in another Query:

let
Source = CallAPI("xyz.test.org.sg/.../getdetails", Paranric)

in
Source

note: Paranric is a parameter 

However, I got an Expression error: The name "CallAPI" wasn't recognized. Make sure it's spelled correctly.

----

Anyone can advise what is the problem? 

Thanks.

Tags:

[v-jiascu-msft]

@kentan2608

Hi,

It seems that you used the wrong function name. As we can see in the image below. The function name is “FuncTest” (in the red square). The name “CallAPI” (in the yellow square) is used internal to call itself. Maybe something like “This” in java. I can’t find an official explanation. It looks like this. If you name your function with the same name, that could be easy to use.

 

Best Regards

Dale

[v-jiascu-msft]

@kentan2608

Hi,

Could you tell me if this worked? What else can I do for you?

Best Regards!

Dale