Creating a Xero Oauth2.0 Custom Connector

[365-Assist]

I am new to creating custom connectors and need some help creating a connector for Xero. I was able to connect using Postman but can't seem to get the settings correct on the Power Platform Custom Connector.

Can someone tell me what the parameters should be for the Security tab. No matter what I try will not connect to Xero.

When I try to Test the connection get error 500

[danny90]

Has anybody achieved consolidated way to create this connector? either by flow or custom connector? i really need to create one and i cant see any clear answers.. some people have it working with a connector but not sure how the refresh process will work after the 60 days. some people are struggling with the flow type because of it refreshing so often or not returning the token.. has anybody got this working consistently?

[s1hl3_ukuvuma]

Forget the Custom Connector.

1. Get a Refresh Token via Postman.

2. Create a SharePoint List as per below and add the Refresh Token from Postman:

3. Create an Instant flow as per below:

- The Get Item is the SharePoint List you created that keeps the refresh token:

4. Next step is sending the HTTP request copy this as is and add the variables as per previous actions:

5. Parse JSON: The Content will be the body from HTTP,

Schema here:

{

    "type": "object",

    "properties": {

        "id_token": {

            "type": "string"

        },

        "access_token": {

            "type": "string"

        },

        "expires_in": {

            "type": "integer"

        },

        "token_type": {

            "type": "string"

        },

        "refresh_token": {

            "type": "string"

        },

        "scope": {

            "type": "string"

        }

    }

}

6. Initialize the New Access Tokens and New Refresh Tokens, and pass the values from the Parse JSON as per below:

7. Update the SharePoint List Refresh and Access Tokens with the New Tokens:

 . You can modify the trigger to occur every 20 minutes so the Access and Refresh Tokens can be updated:

9. Flow in full:

Good luck please let me know how it goes.
~ Sihle

[danny90]

Thanks Sihle, i really appreciate you taking the time to explain! im going to give it a go this evening.

i take it that because this is refreshing every 20 mins, i wont need to renew the connection every 60 days?

and once ive set this up.. how on earth do i make requests to the endpoints to retrieve data from the xero tennant, like a list of customers for example.

Thanks,

Dan

[danny90]

Got that working mate - with only 1 failed test because of a spelling mistake!! Absolutely fantastic! Thankyou.

Now I need to work out how to re authorise every 60 days in an intuitive way; and

Get the info I need and get it into my app. I presume this will be done with a collection of some sort 🤔

thanks!

dan

[s1hl3_ukuvuma]

That is great news man, I am glad it worked.

[danny90]

thanks @s1hl3_ukuvuma 

I've gone one step further now and stored the access/refresh tokens, tennant id and client id/secret in environment variables and im really pleased with how this works.

so am i right thinking that because this is running every 20 minuets - it wont ever expire? the access token lasts for 30 minuets and the refresh token lasts for 60 days but if this flow is constantly refreshing.. the connection should remain live?

[s1hl3_ukuvuma]

Correct I have been using mine for months and never expires.

[danny90]

@s1hl3_ukuvuma you're an absolute legend! thankyou so much