topic Re: Custom Data Connector Navigation Table Functions in Developer

Custom Data Connector Navigation Table Functions

Anonymous — Tue, 22 Jan 2019 14:17:08 GMT

I am creating a custom data connector and am currently working on the navigation table. I am writing this using the sdk in visual studio.

I am attempting to have a function in my navigation table that will take in user inputs to search through a larger table with their specified conditions. While I have found evidence that this is possible https://github.com/Microsoft/DataConnectors/tree/master/samples/TripPin/1-OData and https://github.com/Microsoft/DataConnectors/tree/master/samples/OpenApiSample they both seem to import their naviagtion tables in through metadata returned from their queires which is not an option for me.

Despite my best efforts I am yet to find anywhere that actually shows how to do this. I have tried simply putting a function that requires arguments in my navigation table but with no luck as it gives me an error that it is expecting parameters (which makes sense, but I need the user to enter them). I have even looked through the json metadata returned by some of the queries in the above examples with the closest I could find to anything was a value in the functions section setting IsComposable="true".

Any help or direction to a source which can help me would be greatly appreciated.

Re: Custom Data Connector Navigation Table Functions

Anonymous — Fri, 17 May 2019 14:48:51 GMT

Hello, did you find a solution? I'm struggling with a similar problem.
Cheers.

Re: Custom Data Connector Navigation Table Functions

Anonymous — Mon, 22 Jul 2019 15:49:34 GMT

I managed to get it close but not perfect, I am back to looking for a way to do this again. I will let you know if I miraculously do make an progress

Re: Custom Data Connector Navigation Table Functions

Anonymous — Mon, 22 Jul 2019 15:52:15 GMT

Hi, i also made a workaround for my case. If you're interested, when you try it again, i can try to help.

Cheers.

CAOP

Re: Custom Data Connector Navigation Table Functions

sboptimal — Sat, 30 May 2020 10:00:55 GMT

I see you managed to get some sort of solution to this problem. I wonder if you would be able to provide some pointers in how you solved it.

I am having the same issue for a custom connector i am working on. I have a number of functions that take different parameters and i would like to expose them via the navigation table. I can get it to work if they don't require parameters from the user but i can't work out how to allow them to enter anything. If i mock up something that auto-generates the Navigation table they appear as expected but unfortunately this isn't really an option for what i need to do.

Re: Custom Data Connector Navigation Table Functions

Anonymous — Wed, 10 Mar 2021 11:02:39 GMT

I'm facing similar issue - trying to create and expose custom function through visual studio custom connector code (to be shown in the navigator in power bi desktop), but not being able to do it. This is easily done through Power BI desktop, though.

Re: Custom Data Connector Navigation Table Functions

gooduling — Sun, 13 Jun 2021 23:15:06 GMT

Hi, I've founs the example of using functions in Navigation here https://github.com/microsoft/DataConnectors/issues/30

Re: Custom Data Connector Navigation Table Functions

gooduling — Sun, 13 Jun 2021 23:16:02 GMT

Hi Yuval, have you found the solution?