How to create Concur Linked Service for Azure Data Factory

I am trying to create a Concur Linked Service in Azure Data Factory. I'm not sure what urls to use for the "Host" and "Base URL" attributes. I was able to retrieve a Bearer token using POSTMAN (url: https://www-us2.api.concursolutions.com/oauth2/v0/token, grant_type = password) so I know my User name/password and Client ID/secret are valid. In the Linked Service I've tried Host: www-us2.api.concursolutions.com/oauth2/v0/token Base URL: www-us2.api.concursolutions.com but I get the following error message: ERROR [HY000] [Microsoft][Concur] (60) API Connection Failed (Unauthorized Access). Check credentials. HTTP Response code: 403

1 answer

ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee

2024-02-07T14:49:25.76+00:00

Hi Jason Pranter (PDX Contractor), Thank you for posting query in Microsoft Q&A Platform. host is the endpoint of the concur server. Example, implementation.concursolutions.com and its mandatory field. baseURL is the URL of your concur's authorization and its mandatory field for OAuth_2.0_Bearer authentication.

Kindly consider rechecking host and baseURL accordingly. This documentation has complete details of all fields of concur connector linked service.

Hope this helps. Please let me know how it goes.

Please consider hitting Accept Answer button. Accepted answers help community as well.
Please sign in to rate this answer.

1 person found this answer helpful.
Jason Pranter (PDX Contractor) 0 Reputation points

2024-02-07T20:18:26.7433333+00:00

@ShaikMaheer-MSFT I'm aware of the documentation but I'm still not clear as to what URL I should use for host and baseURL. Does "www-us2.api.concursolutions.com/oauth2/v0/token" seem appropriate for baseURL?

ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee

2024-02-13T05:33:44.09+00:00

Hi Jason Pranter (PDX Contractor), The base URL of Concur’s authorization URL is specific to your organization’s Concur account. You can typically find this information in the Concur developer documentation or by contacting your Concur administrator or IT department. Hope this helps.

---Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.

Greg 0 Reputation points

2024-02-16T16:31:13.7633333+00:00

Working a similar challenge with the Linked Service where the data returns successfully for Expenses in Postman, however, nothing via the Concur Linked Service. Concur support recommend "V2" of the Concur Linked Service for Azure Data Factory. My current version is marked 'Preview'. Is there a v2, perhaps within a specific Azure Region such as US West 3 or something?

James Keeley 1 Reputation point

2024-02-16T16:59:05.1333333+00:00

@ShaikMaheer-MSFT we were able to connect to the Concur Linked Service after a couple calls with Concur support and MS support but we are having issues getting data back from Concur. When we use the same credentials in Postman we get data back, but not using the Linked Service. It looks like we are also missing some of the tables available in Concur, aren't seeing the same items available as we do when using a different tool (cdata). I spoke with Concur support again this morning and they indicated that there is a newer version (v2 specifically) of the Concur Linked Service available. If that's the case, how can we get a copy of that version so we can move away from the preview version we are currently using?

ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee

2024-02-20T05:16:38.4133333+00:00

Hi Jason Pranter (PDX Contractor), Thank you for details. This helps. As its currently in preview state, the API versions update behind the scenes may happen slowly. I hope soon linked service backend logic will be changed to point to new API version.
Between, i forwarded this feedback to internal team as well. Thank you.
Sign in to comment

Share via

How to create Concur Linked Service for Azure Data Factory

1 answer