Issues with Concur Linked Server
Andrew Rosson
0
Reputation points
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
}
}
}
}