Hi There,
(Please see latest comment for current situation).
Got an issue building my first ever custom connector, wondered if folk here may be able to help? Here's my .pq file (no option to select M as a code sample when submitting, so have submitted as HTML).
// This file contains your Data Connector logic
section Zoho_Recruit;
urlPath = "candidates";
//oauth values
client_id = "xx";
client_secret = "xx";
redirect_uri = "https://oauth.powerbi.com/views/oauthredirect.html";
authorize_uri = "https://accounts.zoho.eu/oauth/v2/auth";
token_uri = "https://accounts.zoho.eu/oauth/v2/token";
// Login modal window dimensions
windowWidth = 1200;
windowHeight = 1000;
[DataSource.Kind="Zoho_Recruit", Publish="Zoho_Recruit.Publish"]
shared Zoho_Recruit.Contents = (url as text) =>
let
source = Json.Document(Web.Contents(url & urlPath))
in
source;
// Data Source Kind description
Zoho_Recruit = [
TestConnection = (dataSourcePath) => { "Zoho_Recruit.Contents", dataSourcePath },
Authentication = [
OAuth = [
StartLogin = StartLogin,
FinishLogin = FinishLogin
]
],
Label = Extension.LoadString("DataSourceLabel")
];
// Data Source UI publishing description
Zoho_Recruit.Publish = [
Beta = true,
Category = "Other",
ButtonText = { Extension.LoadString("ButtonTitle"), Extension.LoadString("ButtonHelp") },
LearnMoreUrl = "https://powerbi.microsoft.com/",
SourceImage = Zoho_Recruit.Icons,
SourceTypeImage = Zoho_Recruit.Icons
];
// StartLogin
StartLogin = (dataSourcePath, state, display) =>
let
AuthorizeUrl = authorize_uri & "?" & Uri.BuildQueryString([
response_type = "code",
client_id = client_id,
redirect_uri = redirect_uri,
state = state,
scope = "ZohoRecruit.modules.ALL"
])
in
[
LoginUri = authorize_uri,
CallbackUri = redirect_uri,
WindowHeight = windowHeight,
WindowWidth = windowWidth,
Context = null
];
FinishLogin = (context, callbackUri, state) =>
let
// parse the full callbackUri, and extract the Query string
parts = Uri.Parts(callbackUri)[Query],
// if the query string contains an "error" field, raise an error
// otherwise call TokenMethod to exchange our code for an access_token
result = if (Record.HasFields(parts, {"error", "error_description"})) then
error Error.Record(parts[error], parts[error_description], parts)
else
TokenMethod("authorization_code", "code", parts[code])
in
result;
TokenMethod = (grantType,tokenField,code) =>
let
queryString = [
grant_type = "authorization_code",
redirect_uri = redirect_uri,
client_id = client_id,
client_secret = client_secret
],
queryWithCode = Record.AddField(queryString, tokenField, code),
tokenResponse = Web.Contents(token_uri, [
Content = Text.ToBinary(Uri.BuildQueryString(queryWithCode)),
Headers=[
#"Content-type" = "application/x-www-form-urlencoded",
#"Accept" = "application/json"
],
ManualStatusHandling = {400}
]),
body = Json.Document(tokenResponse),
result = if (Record.HasFields(body, {"error", "error_description"})) then
error Error.Record(body[error], body[error_description], body)
else
body
in
result;
Zoho_Recruit.Icons = [
Icon16 = { Extension.Contents("Zoho_Recruit16.png"), Extension.Contents("Zoho_Recruit20.png"), Extension.Contents("Zoho_Recruit24.png"), Extension.Contents("Zoho_Recruit32.png") },
Icon32 = { Extension.Contents("Zoho_Recruit32.png"), Extension.Contents("Zoho_Recruit40.png"), Extension.Contents("Zoho_Recruit48.png"), Extension.Contents("Zoho_Recruit64.png") }
];
Whether run in Visual Studio, or in PBI desktop, after having successfully authenticated and given the app rights to the scope that's defined in the code, I get the issue below:
Zoho API documentation here:
https://www.zoho.com/recruit/developer-guide/apiv2/oauth-overview.html
https://www.zoho.com/accounts/protocol/oauth/web-apps/authorization.html
Clearly, response_type is defined in the code, so I'm not sure what I'm missing. There may well be some pretty rookie errors in here, so please be gentle! 😉
I also have a follow up question, which is how does one obfuscate the Client_ID and Client_Secret values when building custom connectors? There is an obvious security concern around having these values stored as open text either within a .mez file which can be reverse engineered, or a text file that has the same frailties.
Thanks,
clno1
