We have a requirement to fetch the ID of the orchestrator account and pass it to the second API, the Delete/Remove Account API.
However, we are not getting a sample of how we can include the ID in the call1 and pass it to the call2 URL to delete the account.
Note: We cannot store the value in the Accounts or User tables.
Connection JSON we are using:
1. The first authentication method is used to add or remove access from an Azure group.
2. The second authentication method is used to remove an account.
{
"authentications": {
"userAuth": {
"authType": "oauth2",
"url": "https://login.microsoftonline.com/tenant id/oauth2/token",
"httpMethod": "POST",
"httpParams": {
"grant_type": "client_credentials",
"client_secret": "ABC",
"client_id": "XYZ",
"resource": "https://graph.microsoft.com/"
},
"httpHeaders": {
"contentType": "application/x-www-form-urlencoded"
},
"httpContentType": "application/x-www-form-urlencoded",
"properties": {},
"expiryError": "ExpiredAuthenticationToken",
"authError": [
"InvalidAuthenticationToken",
"AuthenticationFailed"
],
"retryFailureStatusCode": [403, 401, 500],
"timeOutError": "Read timed out",
"errorPath": "error.code",
"maxRefreshTryCount": 5,
"tokenResponsePath": "access_token",
"tokenType": "Bearer",
"accessToken": "Bearer eyJ0eXAiOiJKV1QiLCJub25jZSZO7I5Bfqi9-0LGoeFRVPlpB3r4T7hI82KoPiaznhYm65vdKIJW8x8rnmkt9YSEFN01UCTwlDJCtig",
"apiRateLimitConfig": {
"retryAfterCalls": 100,
"retryWaitSeconds": 60
}
},
"userAuth1": {
"authType": "oauth2",
"url": "https://ABC/identity_/connect/token",
"httpMethod": "POST",
"httpParams": {
"grant_type": "client_credentials",
"client_secret": "ABCD",
"client_id": "EFGH",
"scope": "OR.Users OR.Users. Read OR.Users.Write"
},
"httpHeaders": {
"Content-Type": "application/x-www-form-urlencoded"
},
"httpContentType": "application/x-www-form-urlencoded",
"properties": {},
"expiryError": "ExpiredAuthenticationToken",
"authError": [
"InvalidAuthenticationToken",
"AuthenticationFailed"
],
"retryFailureStatusCode": [403, 401, 500],
"timeOutError": "Read timed out",
"errorPath": "odata~dot#error.code",
"maxRefreshTryCount": 3,
"tokenResponsePath": "access_token",
"tokenType": "Bearer",
"accessToken": "Bearer RTAxNjEDK8GggKeIBOBLjyvPhqM846WZ8U9Rodmn2O5YCRQb8A0kq__BOR2AXe48sm1TSJOapPXAcWH6-tiP0Qg",
"retryAfterCalls": 100,
"retryWaitSeconds": 60
}
}
}
Remove Account Json:
{
"call": [{
"name": "call1",
"connection": "userAuth1",
"url": "https://ABC/Development/Users?%24filter=UserName%20eq%20%27${user.secondaryEmail}%27",
"httpMethod": "GET",
"listField": "value",
"keyField": "name",
"colsToPropsMap": {
"name": "UserName~#~char",
"customproperty7": "Id~#~char"
},
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/json",
"successResponses": {
"statusCode": [200, 201, 204]
}
}, {
"name": "call2",
"connection": "userAuth1",
"url": "https://XYZ/orchestrator_/Users(${account.customproperty7})",
"httpMethod": "DELETE",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/json",
"successResponses": {
"statusCode": [200, 201, 204]
}
}]
}
However, we are getting the below error when we are removing the account:
"message":"Invalid OData query options.","errorCode":999,"traceId":"00-3d92e3c1573edb4f9dd3218feaca9ec9-71a0d0c81eca0a58-00","statusCode":400,"description":null,"status":"Failed"
Please let us know how we can achieve this.
