Zoho CRM API to Oower BI custom connector

Zoho CRM API to Oower BI custom connector

Hello everyone,

I've been struggling with this for a few days now , I hope I can get some help here.

I want to create a custom connector for Power BI that imports data from Zoho CRM.

Te OAuth 2.0 part of the code is working properly. The connector connects successfully to Zoho CRM but then it prompts this error: [DataFormatError] We couldn't parse your query string as it was improperly formatted

The code I'm using:

  2. // This file contains your Data Connector logic
  3. section Zoho_Connector___V1.1;

  5. // TODO: add your client id and secret to the embedded files

  7. client_id = "XXXXXX";

  9. client_secret = "XXXXXX";

  11. redirect_uri = "https://oauth.powerbi.com/views/oauthredirect.html";

  13. windowWidth = 800;

  15. windowHeight = 800;

  17. //Oauth base url for

  19. OAuthBaseUrl = "https://accounts.zoho.eu/oauth/v2/auth?";


  22. [DataSource.Kind="Zoho_Connector___V1.1", Publish="Zoho_Connector___V1.1.Publish"]
  23. shared Zoho_Connector___V1.1.Contents = () =>
  24. let

  26. navTable = Web.Contents("https://www.zohoapis.eu/crm/v2/Leads")

  28. in

  30. navTable;


  33. // Data Source Kind description
  34. Zoho_Connector___V1.1 = [
  35. Authentication = [
  36. // enable both OAuth and Key based auth

  38. OAuth = [

  40. StartLogin = StartLogin,

  42. FinishLogin = FinishLogin,

  44. Refresh=Refresh

  46. ]

  48. ],
  49. Label = Extension.LoadString("DataSourceLabel")
  50. ];

  52. // Data Source UI publishing description
  53. Zoho_Connector___V1.1.Publish = [
  54.     Beta = true,
  55.     Category = "Other",
  56.     ButtonText = { Extension.LoadString("ButtonTitle"), Extension.LoadString("ButtonHelp") },
  57.     LearnMoreUrl = "https://powerbi.microsoft.com/",
  58.     SourceImage = Zoho_Connector___V1.1.Icons,
  59.     SourceTypeImage = Zoho_Connector___V1.1.Icons
  60. ];

  62. // OAuth2 flow definition

  64. //


  67. // Start Login thorugh OAUTH
  68. StartLogin = (resourceUrl, state, display) =>

  70. let

  72. AuthorizeUrl = OAuthBaseUrl & Uri.BuildQueryString([

  74. scope = "ZohoCRM.modules.all",

  76. client_id = client_id,

  78. redirect_uri = redirect_uri,

  80. response_type = "code",

  82. state = state,

  84. access_type = "online"])

  86. in

  88. [

  90. LoginUri = AuthorizeUrl,

  92. CallbackUri = redirect_uri,

  94. WindowHeight = windowHeight,

  96. WindowWidth = windowWidth,

  98. Context = null

  100. ];

  102. // Finish Login through OAUTH

  104. FinishLogin = (context, callbackUri, state) =>

  106. let

  108. Parts = Uri.Parts(callbackUri)[Query]

  110. in

  112. TokenMethod(Parts[code], "authorization_code");



  116. TokenMethod = (code, grant_type) =>

  118. let

  120. Response = Web.Contents("https://accounts.zoho.eu/oauth/v2/token", [

  122. Content = Text.ToBinary(Uri.BuildQueryString([

  124. grant_type = "authorization_code",

  126. client_id = client_id,

  128. client_secret = client_secret,

  130. redirect_uri = redirect_uri,

  132. code = code
  133. ]
  134. )),

  136. Headers=[#"Content-type" = "application/x-www-form-urlencoded",#"Accept" = "application/json"]]),

  138. Parts = Json.Document(Response)

  140. in

  142. Parts;



  146. Refresh = (resourceUrl, refresh_token) => TokenMethod(refresh_token, "refresh_token");


  149. Zoho_Connector___V1.1.Icons = [
  150.     Icon16 = { Extension.Contents("Zoho_Connector___V1.116.png"), Extension.Contents("Zoho_Connector___V1.120.png"), Extension.Contents("Zoho_Connector___V1.124.png"), Extension.Contents("Zoho_Connector___V1.132.png") },
  151.     Icon32 = { Extension.Contents("Zoho_Connector___V1.132.png"), Extension.Contents("Zoho_Connector___V1.140.png"), Extension.Contents("Zoho_Connector___V1.148.png"), Extension.Contents("Zoho_Connector___V1.164.png") }
  152. ];

Any ideas about what I'm doing wrong?

Thanks