OAuth2.0 Custom Connector TestConnection Issue

paulalmond91 — Mon, 20 Apr 2020 17:24:10 GMT

I've tested a working connector with PowerBI desktop and published this to service but I am facing an issue where the Data Source configuration in the Gateway won't store the OAuth access_token.
I following the guidance regarding TestConnection found here: https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md#implementing-testconnection-for-gateway-support

The issue I am facing is that I click Edit Credentials when configuring a Data Source on the gateway - the OAuth flow start and I click to Allow access but it just takes me back to the popup below (with Add being greyed out).

Here is my VS code:

[DataSource.Kind="AdministrateGraphQL", Publish="AdministrateGraphQL.UI"] shared AdministrateGraph = (query as text) => let apiToken = "Bearer " & Extension.CurrentCredential()[access_token], Source = Web.Contents("https://api.getadministrate.com/graphql", [Headers=[ #"Method"="POST", #"Content-Type"="application/json", #"Authorization"=apiToken ], Content=Text.ToBinary(query) ]), Output = Json.Document(Source) in Output; [DataSource.Kind="AdministrateGraphQL"] shared TestAdministrateGraph = (query as text) => let apiToken = "Bearer " & Extension.CurrentCredential()[access_token], Source = Web.Contents("https://api.getadministrate.com/graphql", [Headers=[ #"Method"="POST", #"Content-Type"="application/json", #"Authorization"=apiToken ], Content=Text.ToBinary(query) ]), Output = Json.Document(Source) in Output; // Data Source Kind description AdministrateGraphQL = [ TestConnection = (dataSourcePath) => { "AdministrateGraph", dataSourcePath }, Authentication = [ OAuth = [ StartLogin=StartLogin, FinishLogin=FinishLogin, Refresh=Refresh ] ], Label = Extension.LoadString("Administrate GraphQL Connector") ];

Is anyone able to highlight why this isn't working?

Re: OAuth2.0 Custom Connector TestConnection Issue

paulalmond91 — Thu, 23 Apr 2020 11:28:17 GMT

Anyone have any thoughts?

Re: OAuth2.0 Custom Connector TestConnection Issue

davidvincentret — Thu, 04 Jun 2020 09:56:20 GMT

Hello,

I am working on developping an Oauth2 connector like you but I'm currently not succeeding, would it be possible to see how you've set up your StarLogin and FinishLogin functions ? I'm struggling with these two functions because I don't need any authorize URL to access my toke, I just need to request the token url with some credentials and I get it, no exampe works like this online

Otherwise sorry, I can't help you that much ahah

topic OAuth2.0 Custom Connector TestConnection Issue in Developer

OAuth2.0 Custom Connector TestConnection Issue

Re: OAuth2.0 Custom Connector TestConnection Issue

Re: OAuth2.0 Custom Connector TestConnection Issue