Issues with Concur Linked Server

Andrew Rosson 0 Reputation points
2023-04-07T16:51:04.65+00:00

When Configuring The Concur Linked server I get this Error

ERROR [HY000] [Microsoft][Concur] (61) API Connection Failed. Bad Request. HTTP Response code: 400 ERROR [HY000] [Microsoft][Concur] (61) API Connection Failed. Bad Request. HTTP Response code: 400 Activity ID: 30f84985-dcf2-48e0-88da-b398153cbb61

I have verified the Client ID,Client Secret, Host URL, Access Url. Still not working.
I have verified in Postman with OAuth 2.0 Bearer token and I am able to generate the token fine.
Am I doing something wrong here?

{ 
"name":"ConcurLinkedService", 
"properties":{
"type":"Concur",
"typeProperties":{
"connectionProperties":{
"host":"us.api.concursolutions.com",
"baseUrl":"https://us.api.concursolutions.com/oauth2/v0/token",
"authenticationType":"OAuth_2.0_Bearer",
"clientId":"MyClientID",
"clientSecret":{
                    "type": "SecureString",
                    "value": "MyClientSecret"
                },
"username":"MyUsername",
"password":{
                    "type": "SecureString",
                    "value": "Mypassword"
                },
"useEncryptedEndpoints":true,
"useHostVerification":true,
"usePeerVerification":true
}
}
}
}
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,583 questions
{count} votes