Skip to main content

Notifications

Power Automate - Using Connectors
Answered

HTTP authentication to Xero

(0) ShareShare
ReportReport
Posted on by 174

I am trying to use the HTTP action to connect to the Xero api using Client Certficate for their OAuth 1.0 authentication method.

Xero have private and public app options. I am using the Private app option.

I have used OpenSSL to produce the .cer and .pfx files and converted the .pfx file to base 64.

The Private app is registerd with Xero and I have a consumer key and token, even though the token is not needed for private app connections.

 

What I cant find anywhere is guidance on how to populate the fields in the HTTP action in Flow.

I.e. the headers, query and body.

 

At the moment I get an error to do with the password. "Could not load the certificate private key. Please check the authentication certificate password is correct and try again."

However I think the problem is bigger than that.

 

Any guidance would be greatly appreciated.

 

  • Verified answer
    JesseW Profile Picture
    JesseW 26 on at
    Re: HTTP authentication to Xero

    Cheers Martin. I will leverage our developers to look at building a custom connector like you have outlined below. Thanks again. 

  • Martin CPA Profile Picture
    Martin CPA 174 on at
    Re: HTTP authentication to Xero

    I had some guys write the code in c#, deploy it to our Azure logic app space. The code generated the header.

    Then I exported to flow to create the custom connector.

    The logic app had parameters: -

    -url

    -consumer key and secret

    -pfk password. (I had previously created an ssl cert using OpenSSL)

    Happy to provide details of guys I paid to write above code. It only took about an hour.

  • JesseW Profile Picture
    JesseW 26 on at
    Re: HTTP authentication to Xero

    Great thanks Martin,

     

    Did you happen to stumble across instructions on setting up logicapp to generate the authorisation header by chance? Is this the process you are referring to?

     

    https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-custom-api-authentication

  • Martin CPA Profile Picture
    Martin CPA 174 on at
    Re: HTTP authentication to Xero

    It turns out the it is not possible.

    For reference. 

    • Create a logicApp to generate the authorisation header for each of the GET, POST and PUT calls
      • Use parameters for URi and custom keys etc
    • Export to Flow as a custom connector
    • Pass parameters to Logic App to generate and return Authorization header string
    • Use HTTP call to retrieve json from Oauth 1.0 Xero source
  • JesseW Profile Picture
    JesseW 26 on at
    Re: HTTP authentication to Xero

    @MartinHutchcpa I have also come across the same issue of not being able to authenticate to the Xero API via MS Flow.

     

    None of the three authentication options within MS Flow look compatible with Xero.

     

    This is an example of the private app details generated within Xero:

    2019-01-25_14-35-50.png

     

    I can't seem to find a definitive answer on whether oauth 2.0 is backwards compatible or not?

     

    2019-01-25_14-36-57.png

  • Martin CPA Profile Picture
    Martin CPA 174 on at
    Re: HTTP authentication to Xero

    Thank you, but this does not address how to setup the authentication using Client Certficate.

  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: HTTP authentication to Xero

    Hi @MartinHutchcpa,

     

    It seems that you are trying to use the HTTP action to make requests with Microsoft Flow, please check the following blog for a reference:

    https://flow.microsoft.com/es-es/blog/http-card-tutorial/

    By the way, here is a blog on HTTP trigger for your reference:

    http://johnliu.net/blog/2018/10/microsoft-flow-http-trigger-request-trigger-and-you-probably-dont-want-to-use-it

    In addition, there is a request on new connector Xero, please feel free vote the idea at here:

    https://powerusers.microsoft.com/t5/Flow-Ideas/New-Connector-Xero/idi-p/8329

     

    Best regards,

    Mabel

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics