Power Query custom connector for XML API RRS feed

  • Question

  • I would like to create a custom connector for XML API.

    The immediate challenge is the authentication. I need to POST 5 values (sender_id, sender_password, user_name, user_password, database) as XML, then extract the sesson_id from the response (for use in additional actions).

    It's not apparent from the documentation, how I can make use of the authentication options for my purposes. UsernamePassword would work for 4 of the 5, if I can supply it twice.  Then, I would need to find a way to specify the database , perhaps as a custom setting.

    Any suggestions on how to approach this would be appreciated.
    Sunday, June 21, 2020 2:25 AM


All replies

  • Hi Craig,

    this might be a better place to ask this question: https://github.com/microsoft/DataConnectors/issues

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Saturday, June 27, 2020 2:44 PM
  • Juse use the Web connector:


        Source = Xml.Tables(Web.Contents("https://www.ncaa.com/news/football/fbs/rss.xml")),
        #"Changed Type" = Table.TransformColumnTypes(Source,{{"Attribute:version", type number}}),
        #"Expanded channel" = Table.ExpandTableColumn(#"Changed Type", "channel", {"title", "link", "description", "language", "item"}, {"channel.title", "channel.link", "channel.description", "channel.language", "channel.item"}),
        #"Expanded http://www.w3.org/XML/1998/namespace" = Table.ExpandTableColumn(#"Expanded channel", "http://www.w3.org/XML/1998/namespace", {"Attribute:base"}, {"http://www.w3.org/XML/1998/namespace.Attribute:base"}),
        #"Expanded channel.item" = Table.ExpandTableColumn(#"Expanded http://www.w3.org/XML/1998/namespace", "channel.item", {"title", "link", "description"}, {"channel.item.title", "channel.item.link", "channel.item.description"})
        #"Expanded channel.item"
    Saturday, June 27, 2020 2:47 PM
  • Thanks for your response.

    I understand how to get data from a web-services call.  What I don't understand is how to pass multiple sets of credentials to a web-service.

    Thursday, July 2, 2020 12:50 PM
  • Thanks for the recommendation: Multiple sets of credentials #315.
    Thursday, July 2, 2020 1:07 PM