Hello,
I have developped a custom connector which works fine - as long as I define my function parameters as optional parameters.
As soon as I change to parameters to required, I get an "Unexpected Exception": "[DataFormat.Error] We found extra characters at the end of JSON input".
My Details:
Definiton of main function of the custom connector, which works perfectly fine:
[DataSource.Kind="MS_Power_BI_Ungerboeck", Publish="MS_Power_BI_Ungerboeck.Publish"]
shared MS_Power_BI_Ungerboeck.Contents = (optional apiUser as text, optional apiKey as text, optional apiSecret as text, optional apiUrl as text, optional apiTimeout as number) =>
Change the first parameter (or all) to required and the error occurs:
[DataSource.Kind="MS_Power_BI_Ungerboeck", Publish="MS_Power_BI_Ungerboeck.Publish"]
shared MS_Power_BI_Ungerboeck.Contents = (apiUser as text, optional apiKey as text, optional apiSecret as text, optional apiUrl as text, optional apiTimeout as number) =>
The test function which I use for testing the custom connector looks like this:
// Use this file to write queries to test your data connector
let
result = MS_Power_BI_Ungerboeck.Contents("POWBI","ab430fcb-144f-45e1-ab54-447bd22aac5e","d68d7c9f-564e-378f-a14b-b2c0586c68da","https://hostname.mydomain.com/api/v1/Accounts/10?search=AccountCode%20eq'SMITH'",10)
in
result
The only change which makes it work or creates the error is to have one or none required parameters:
it works fine when all parameters are declared as optional.
It fails when at least one parameter is required.
I checked lots of examples and documentation about function parameters, but could not find the reason for that.
Any help is highly appreaciated.
Thank,
Thomas
