Hello experts,
We are trying to import accounts,
This is the first call, POST method and the url is https://xyz-it-ops-search.abc.az.net/services/search/jobs/ and in body raw we should pass
search= | inputlookup ad_signin_logs.csv so we will be getting the SId in response
And that SID we need to pass in another GET call and url is https://xyz-it-ops-search.abc.az.net/services/search/jobs/ SID/results?output_mode=json
curl for GET call
curl --location --request GET 'https://xyz-it-ops-search.abc.az.net/services/search/jobs/ SID/results?output_mode=json' \
--header 'Accept: application/json' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic hWdJlJGlnbmluTG9ncw==' \
--data 'search= | inputlookup ad_signin_logs.csv'
curl for POST call
curl --location 'https://xyz-it-ops-search.abc.az.net/services/search/jobs/ ' \
--header 'Accept: application/json' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic hWdJlJGlnbmluTG9ncw==' \
--data 'search= | inputlookup ad_signin_logs.csv'
currently using json
{
"accountParams": {
"connection": "acctAuth",
"showLogs": true,
"createUsers": false,
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"accountThresholdValue": 100,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://xyz-it-ops-search.abc.az.net/services/search/jobs/ SID/results?output_mode=json",
"httpHeaders": {
"Authorization": "Basic hWdJlJGlnbmluTG9ncw==",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField":"results",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "userPrincipalName~#~char",
"name": "userPrincipalName~#~char",
"customproperty11": "last_usage~#~char"
},
"disableDeletedAccounts": true
}
}
}
}
Please let me how can we achieve this, thanks in advance
Tried with below json
{
"accountParams": {
"connection": "acctAuth",
"showLogs": true,
"createUsers": false,
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"accountThresholdValue": 100,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false
},
"call": [
{
"callOrder": 0,
"name": "call1",
"connection": "acctAuth",
"showResponse": true,
"url": "https://xab/services/search/jobs",
"httpMethod": "POST",
"httpParams": "search=%20%7C%20inputlookup ad_signin_logs.csv",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"successResponses": {
"statusCode": [
201,
200
]
}
},
{
"call2": {
"callOrder": 1,
"stageNumber": 1,
"http": {
"url": "https://xacg.net/services/search/jobs/${response.call1}/results?output_mode=json",
"httpHeaders": {
"Authorization": "Basic nOkB6dXlnbmluTG9ncw==",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "results",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "userPrincipalName~#~char",
"name": "userPrincipalName~#~char",
"customproperty11": "last_usage~#~char"
},
"disableDeletedAccounts": true
}
}
]
}
}
job is failing with this error
