REST connector Domino Application ImportAccountentjson not working.

[DG1811]

Hi Team,
We are trying to integrate DOMINO application using REST CONNECTOR where we are trying to pull the data. Below is the response sample for the API. 

Accounts:
[
{
"@href": "/names.nsf/api/data/collections/unid/0686D95C5D48DCC0852561C6006B4D96/unid/7D4401A278EA2C758525851C005F7449",
"@link": {
"rel": "document",
"href": "/names.nsf/api/data/documents/unid/7D4401A278EA2C758525851C005F7449"
},
"@entryid": "5000-7D4401A278EA2C758525851C005F7449",
"@unid": "7D4401A278EA2C758525851C005F7449",
"@noteid": "CDB6",
"@position": "5000",
"@read": true,
"@siblings": 5968,
"@form": "Person",
"$1": "ABCD/object",
"$0": "AB",
"$2": "",
"$3": "CD",
"$4": "AB.CD@domain.com",
"Comment": "",
"ShortName": "e852ji0"
}
]

Entitlement:

[
{
"@href": "/names.nsf/api/data/collections/unid/4A170FAEE3E022AF852561C20069B845/unid/8BFDB57947CFE08585257B05006F7B06",
"@link": {
"rel": "document",
"href": "/names.nsf/api/data/documents/unid/8BFDB57947CFE08585257B05006F7B06"
},
"@entryid": "358-8BFDB57947CFE08585257B05006F7B06",
"@unid": "8BFDB57947CFE08585257B05006F7B06",
"@noteid": "3C2E",
"@position": "358",
"@read": true,
"@siblings": 358,
"@form": "Group",
"$1": "UDC Request Analyst",
"ListDescription": "UDC Request. mgmintranet/it/udc.nsf",
"Members": [
"CN=12324 56y75/O=object",
"CN=12334 12112/O=object"
]
}
]

Here for account we have two call to pull data from the documnets also. 

Attached is the json that we have wrote. Now the problem is we are getting the data but there are around 5000 entries but in one go we had pulled around 100 users and now using pagination now we are trying to pull all the records and the job is running since last 15hours, we can see data in the logs but the accounts are still not created and it keeps running. 

Please verify if the json looks good to pull the data or not. 

Thanks

[rushikeshvartak]

Refer JSON from https://docs.saviyntcloud.com/bundle/Domino-v2022x/page/Content/Understanding-the-Integration-Betwee... 

[DG1811]

Hi @rushikeshvartak ,

We have referred the SAME json, still we are facing the issue. The job finally stopped with failure and gave the below error. 

[rushikeshvartak]

Could you kindly provide a detailed snapshot of the information extracted from the logs, encompassing errors and other pertinent functionality details encountered during the execution of this process? Your assistance in furnishing this information would greatly aid in the analysis and resolution of any issues .



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

[Sachin]

@rushikeshvartak  I have attached the logs and it is from time the Import Account  job was running.

Thank you.

[DG1811]

Hi ,
We are now trying to pull the data only for accounts. And we are successfull to pull it using the below json.

{
"accountParams":{
"connection":"acctAuth",
"processingType":"SequentialAndIterative",
"call":{
"call1":{
"callOrder":0,
"stageNumber":0,
"keyField":"accountID",
"makeProcessingStatus":true,
"disableDeletedAccounts":false,
"http":{
"url":"http://xxxxxxxxxxxxxxxxxxxx/names.nsf/api/data/collections/unid/0686D95C5D48DCC0852561C6006B4D96?for...",
"httpMethod":"GET",
"httpContentType":"application/json",
"httpHeaders":{
"Authorization":"${access_token}"
}
},
"colsToPropsMap":{
"accountID":"@unid~#~char",
"customproperty1":"@unid~#~char",
"name":"@unid~#~char"
},
"pagination": {
"page": {
"pageSizeParam": "count",
"pageSize": 100,
"pageRecordCount": 100,
"pageNumberParam": "page",
"totalCountPath": 1000,
"firstPageNumber": 0
}
}
},
"call2":{
"callOrder":1,
"stageNumber":3,
"keyField":"accountID",
"listField":"",
"nextApiKeyField":"customproperty1",
"makeProcessingStatus":false,
"disableDeletedAccounts":false,
"http":{
"url":"http://xxxxxxxxxxxxxxxxxxx/names.nsf/api/data/documents/unid/${account.accountID}",
"httpMethod":"GET",
"httpContentType":"application/json",
"httpHeaders":{
"Authorization":"${access_token}"
}
},
"inputParams":{
"dependentCall":true
},
"colsToPropsMap":{
"name":"ShortName~#~char",
"customproperty1":"Owner~#~char",
"customproperty2":"#CONST#FullName~#~listAsString",
"accountID":"@unid~#~char",
"customproperty3":"#CONST#FirstName~#~char",
"customproperty4":"LastName~#~char",
"customproperty5":"ShortName~#~char",
"customproperty6":"InternetAddress~#~char",
"customproperty7":"#CONST#FullName~#~char",
"customproperty9":"@noteid~#~char"
},
"pagination": {
"page": {
"pageSizeParam": "count",
"pageSize": 100,
"pageRecordCount": 100,
"pageNumberParam": "page",
"totalCountPath": 1000,
"firstPageNumber": 0
}
}
}
}
}
}

Pagination is not working. But whenever we hardcode the "firstPageNumber":  <value> with the desired page, it returns the account list. Please help us with the pagination so that we can get the details. There are 59 pages.

Also in the response we do not have any pagination mentioned. 

Thanks

[DG1811]

Hi,
We tried the same way to pull the entitlements also, but the present entitlements goes inactive  once we run the import for second page and further. I think this is due to the threshold value not set, please suggest. 

Thanks

[DG1811]

Hi @rushikeshvartak ,

Any update on the pagination part.

thanks