Forum Discussion

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
9 years ago
Solved

Connect Power BI Desktop to insightly

Hello,   It doesn't seem possible to connect Power BI Desktop to Insightly although there's a content pack for Power BI Service. Is there a workaround, if we need to build a data model and/or add ...
Need Help
  • webportal's avatar
    webportal
    9 years ago

    Figured out I had to Base64 encode the API Key.

     

    This worked so far with some limitations:

     

    let
    Source = Json.Document(Web.Contents("https://api.insight.ly/v2.2/Contacts", [Headers=[Authorization="Basic ***********", ContentType="application/json"]])),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded {0}" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"CONTACT_ID", "SALUTATION", "FIRST_NAME", "LAST_NAME", "BACKGROUND", "IMAGE_URL", "DEFAULT_LINKED_ORGANISATION", "OWNER_USER_ID", "DATE_CREATED_UTC", "DATE_UPDATED_UTC", "VISIBLE_TO", "VISIBLE_TEAM_ID", "VISIBLE_USER_IDS", "CUSTOMFIELDS", "ADDRESSES", "CONTACTINFOS", "DATES", "TAGS", "LINKS", "CONTACTLINKS", "CAN_EDIT", "CAN_DELETE", "SOCIAL_LINKEDIN", "SOCIAL_FACEBOOK", "SOCIAL_TWITTER", "ASSISTANT_NAME"}, {"CONTACT_ID", "SALUTATION", "FIRST_NAME", "LAST_NAME", "BACKGROUND", "IMAGE_URL", "DEFAULT_LINKED_ORGANISATION", "OWNER_USER_ID", "DATE_CREATED_UTC", "DATE_UPDATED_UTC", "VISIBLE_TO", "VISIBLE_TEAM_ID", "VISIBLE_USER_IDS", "CUSTOMFIELDS", "ADDRESSES", "CONTACTINFOS", "DATES", "TAGS", "LINKS", "CONTACTLINKS", "CAN_EDIT", "CAN_DELETE", "SOCIAL_LINKEDIN", "SOCIAL_FACEBOOK", "SOCIAL_TWITTER", "ASSISTANT_NAME"})
in
    #"Expanded {0}"
webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
9 years ago

Anonymous I sure did!

 

As to your question, I can't figure out how to add the APIKeyName in the Advanced Editor in the thread you refer. It's not there.

 

Can you elaborate how to do that?

 

This is exactly what I'm doing:

let
    Source = Json.Document(Web.Contents("https://api.insight.ly/v2.1/contacts", [Headers = [#"Content-Type"="application/json", #"Authorization"="Basic <my_API_KEY>"]]))
in 
     Source

The error message I get is: "It's only possible to specify a API Key when a API Key Name is supplied."

 

Thanks for your help!

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
9 years ago

Also tried the following code with the same error:

 

let
    Source = Json.Document(Web.Contents("https://api.insight.ly/v2.2/", [Headers = [#"Content-Type"="application/json", #"ApiKeyName"="Contacts", #"Authorization"="Basic *********************"]]))
in 
     Source
  • webportal's avatar
    webportal
    Icon for Impactful Individual rankImpactful Individual
    9 years ago

    Figured out I had to Base64 encode the API Key.

     

    This worked so far with some limitations:

     

    let
    Source = Json.Document(Web.Contents("https://api.insight.ly/v2.2/Contacts", [Headers=[Authorization="Basic ***********", ContentType="application/json"]])),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded {0}" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"CONTACT_ID", "SALUTATION", "FIRST_NAME", "LAST_NAME", "BACKGROUND", "IMAGE_URL", "DEFAULT_LINKED_ORGANISATION", "OWNER_USER_ID", "DATE_CREATED_UTC", "DATE_UPDATED_UTC", "VISIBLE_TO", "VISIBLE_TEAM_ID", "VISIBLE_USER_IDS", "CUSTOMFIELDS", "ADDRESSES", "CONTACTINFOS", "DATES", "TAGS", "LINKS", "CONTACTLINKS", "CAN_EDIT", "CAN_DELETE", "SOCIAL_LINKEDIN", "SOCIAL_FACEBOOK", "SOCIAL_TWITTER", "ASSISTANT_NAME"}, {"CONTACT_ID", "SALUTATION", "FIRST_NAME", "LAST_NAME", "BACKGROUND", "IMAGE_URL", "DEFAULT_LINKED_ORGANISATION", "OWNER_USER_ID", "DATE_CREATED_UTC", "DATE_UPDATED_UTC", "VISIBLE_TO", "VISIBLE_TEAM_ID", "VISIBLE_USER_IDS", "CUSTOMFIELDS", "ADDRESSES", "CONTACTINFOS", "DATES", "TAGS", "LINKS", "CONTACTLINKS", "CAN_EDIT", "CAN_DELETE", "SOCIAL_LINKEDIN", "SOCIAL_FACEBOOK", "SOCIAL_TWITTER", "ASSISTANT_NAME"})
in
    #"Expanded {0}"
  • VictorBreelle's avatar
    VictorBreelle
    Regular Visitor
    9 years ago

    Hi There, 

     

    i tried to configurate a new blank request for extract data from Incwo, 

     

    i validated it but nothing happen, how im suppose to send the request for grab the data ?

     

    i used this request =

     

    "let#(lf) Source = Json.Document(Web.Contents(""https://www.incwo.com/512***/contacts/8415791.xml"", [Headers = [#""Content-Type""=""application/json"", #""Authorization""=""Basic <512***>""]]))#(lf)in #(lf) source #(lf)"

     

     

    Is correct request ?

     

    Thanks :)