NOT ABLE TO PASS THE RESPONSE OF CALL1 in CALL2 URL

[Aditya_R]

Hello Everyone,

We were actually having a requirement where we have 2 URL's . The first URL is used to generate the sid which is valid till 1 hour and that sid is passed in 2nd URL, to recon accounts in IGA. In postman the first call is the POST call and the second call is the GET call.

I am attaching the ImportAccountENTJSON

{
"accountParams": {
"connection": "acctAuth",
"showLogs": true,
"createUsers": false,
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"accountThresholdValue": 100,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "URL 1 to generate sid",
"httpHeaders": {
"Authorization": "bearer",
"Accept": "*/*"
},
"httpParams": "search= | XYZ.csv",
"httpContentType": "text/plain",
"httpMethod": "POST"
}

},
"call2": {
"callOrder": 1,
"stageNumber": 0,
"http": {
"url": "URL to fetch accounts<sid from call1> URL",
"httpHeaders": {
"Authorization": "bearer",
"Accept": "*/*"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"inputParams": {
"dependentCall": true
},
"listField": "results",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "userPrincipalName~#~char",
"name": "userPrincipalName~#~char",
"customproperty11": "last_usage~#~char"
},
"disableDeletedAccounts": false
}
}
}
}

POSTMAN - POST CALL BODY (CALL 1)

search= | ABC.csv

response - 

<?xml version="1.0" encoding="UTF-8"?>

<response>

    <sid>1234567890</sid>

</response>

POSTMAN CALL 2 ( GET)

"results": [

        {

            "last_usage": "2024-07-03",

            "userPrincipalName": "name_upn_of_the_user"

        },

When we run the importjob to import account for the above attached json we are getting this error 

Cannot invoke method trim() on null object

Can you please suggest few inputs on this issue ??

[NM]

Hi @Aditya_R , colstopropmapoing is required in accountentparam

[Aditya_R]

Hi @NM We had given colstopropmapping in the call1, But sid will be created under AccountID Keyfield and that will be imported in endpoint and there will be unnecessary entries coming in to account tab in the endpoint. We tried that approach but it did not work too.

[rushikeshvartak]

Share that json with colsToPropsMap

[Aditya_R]

{
"accountParams": {
"connection": "acctAuth",
"createUsers": true,
"adminName": "admin",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"deleteLinks": false,
"accountThresholdValue": 30,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": false,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "URL to fetch sid",
"httpHeaders": {
"Authorization": "",
"Content-Type": "application/json"
},
"httpParams": "search=abc.csv",
"httpContentType": "application/json",
"httpMethod": "POST"
},
"listField": "response",
"keyField": "accountID",
"colsToPropsMap": {
"accountID":"sid~#~char",
"name": "sid~#~char"
},
"disableDeletedAccounts": true
},
"call2": {
"callOrder": 1,
"stageNumber": 1,
"http": {
"url": "URL{accountName}/results?output_mode=json",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "",
"Accept": "application/json"
},
"inputParams": {
"dependentCall": true
},
"httpContentType": "application/json",
"listField": "results",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "userPrincipalName~#~char",
"name": "userPrincipalName~#~char",
"customproperty11": "last_usage~#~char"
}
}
}
}
}
}

We were able to get sid from call1 can you please guide us on what to pass in call2 URL ?

[rushikeshvartak]

Please share postman screenshot and curl command [Refer https://codingnconcepts.com/postman/how-to-generate-curl-command-from-postman/ ]



⚠️‼️‼️Do not upload any attachments that contain sensitive information, such as IP Addresses, URLs, Company/Employee Names, Email Addresses, etc.‼️‼️⚠️

[Aditya_R]

POST sid call

[rushikeshvartak]

Try below

"listField": "results",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "{accountName}~#~char",
"name": "{accountName}~#~char",
"customproperty11": "last_usage~#~char"

[Aditya_R]

GET Accounts CALL

[NM]

Yes ..why haven't you defined the same in connection json??