Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.
This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

REST Account Import

JohnLawson
Regular Contributor
Regular Contributor

‎07/27/2022 09:37 AM

I'm trying to import accounts via REST but before it gets very far, I get:

Error - to Import Data correctly: No content to
map due to end-of-input at [Source: ; line: 1,
column: 0]

Does this have to do with the Connection JSON or the ImportUser JSON?

 

Here is the full stack:

2022-07-27T15:52:49.03442627Z stdout F com.fasterxml.jackson.databind.JsonMappingException: No content to map due to end-of-input
2022-07-27, 10:52 am
ecm-worker
2022-07-27T15:52:49.034435971Z stdout F at com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:270)
2022-07-27, 10:52 am
ecm-worker
2022-07-27T15:52:49.034438771Z stdout F at com.fasterxml.jackson.databind.ObjectMapper._initForReading(ObjectMapper.java:3854)
2022-07-27, 10:52 am
ecm-worker
2022-07-27T15:52:49.034449771Z stdout F at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:3799)
2022-07-27, 10:52 am
ecm-worker
2022-07-27T15:52:49.034453271Z stdout F at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:2877)
2022-07-27, 10:52 am
ecm-worker
2022-07-27T15:52:49.034457571Z stdout F at com.saviynt.provisoning.rest.RestProvisioningService.initializeConnectionForImport(RestProvisioningService.groovy:1863)
2022-07-27, 10:52 am
ecm-worker
2022-07-27T15:52:49.034462871Z stdout F at com.saviynt.provisoning.rest.RestProvisioningService.doImport(RestProvisioningService.groovy:121)
2022-07-27, 10:52 am
ecm-worker
2022-07-27T15:52:49.034467472Z stdout F at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:227)

 

Labels:
0 Kudos
16 REPLIES 16

sahajranajee
Saviynt Employee
Saviynt Employee

‎07/28/2022 12:27 AM

Hi @JohnLawson ,

Could you please share the import JSON being used?


Regards,
Sahaj Ranajee
Sr. Product Specialist
0 Kudos

JohnLawson
Regular Contributor
Regular Contributor
In response to sahajranajee

‎07/28/2022 06:25 AM 

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty7",
"activeStatus": [
"true"
],
"deleteLinks": true,
"accountThresholdValue": 20,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": false,
"deleteAccEntForActiveAccounts": false
},
"call": {
"call1": {
    "callOrder": 0,
    "stageNumber": 0,
    "http": {
    "url": "https://XXXX/integrations/v1/Users?$top=500",
    "httpHeaders": {
    "Authorization": "${access_token}",
    "X-IN8-TENANT-PREFIX": "XXXX",
    "Ocp-Apim-Subscription-Key": "XXXX"
    },
    "httpMethod": "GET",
    "httpContentType": "application/json"
    },
    "makeProcessingStatus": true
},
"call2": {
    "callOrder": 1,
    "stageNumber": 1,
    "http": {
    "url": "${response?.headers?.Location?}",
    "httpHeaders": {
    "Authorization": "${access_token}",
	"X-IN8-TENANT-PREFIX": "XXX",
    "Ocp-Apim-Subscription-Key": "XXXXX"
    },
    "httpMethod": "GET",
    "httpContentType": "application/json"
    },
    "inputParams": {
    "dependentCall": true
    },
    "listField": "value",
    "keyField": "accountID",
    "nextApiKeyField": "accountID",
    "colsToPropsMap": {
    "status": "IsActive~#~bool",
    "accountID": "DisplayUserId~#~string",
    "validthrough": "EndDate~#~date"
    }
}
},

"pagination": {
    "offset": {
      "offsetParam": "Offset",
      "batchParam": "Max",
      "batchSize": 500,
      "totalCountPath": "total_count"
    },
    "nextUrl": {
      "nextUrlPath": "${response?.body?.size()>0?'https://XXX/integrations/v1/Users?$top=500&$skip=' + Math.addExact(total_count,500):null}"
    }
  }
}
}
0 Kudos

JohnLawson
Regular Contributor
Regular Contributor
In response to JohnLawson

‎07/28/2022 06:29 AM

The API is a bit weird in that a call has to be made first using the URI params, it then returns a Location header with the link for the next call that will then return the data.

0 Kudos

JohnLawson
Regular Contributor
Regular Contributor
In response to sahajranajee

‎08/02/2022 08:30 AM

Any thoughts?

0 Kudos

rushikeshvartak
All-Star
All-Star
In response to JohnLawson

‎08/02/2022 08:00 PM

What is end application name? 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.
0 Kudos

JohnLawson
Regular Contributor
Regular Contributor
In response to rushikeshvartak

‎08/03/2022 09:39 AM

It is a specialty software called InEight

0 Kudos

rushikeshvartak
All-Star
All-Star

‎07/28/2022 02:21 AM

A simple fix could be Content-Type: application/json

"httpContentType":"application/json"


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.
0 Kudos

ranudeepreddy
New Contributor II
New Contributor II

‎08/04/2022 12:05 PM

Have you checked that are you using right Job?

Can you confirm that you didn't use this JSON in User Import/any thing?

Confirm that you are using this as Account Import JSON and running Account Import Job.

0 Kudos

JohnLawson
Regular Contributor
Regular Contributor
In response to ranudeepreddy

‎08/04/2022 01:50 PM

That was indeed part of the issue. I had it in the user import not account import.

0 Kudos

JohnLawson
Regular Contributor
Regular Contributor

‎08/04/2022 01:50 PM

Now I am getting the following error:

DEBUG rest.RestProvisioningService  - Exception in persistAccounts try2 :
java.lang.NullPointerException: Cannot invoke method trim() on null object
0 Kudos

rushikeshvartak
All-Star
All-Star
In response to JohnLawson

‎08/04/2022 01:51 PM - edited ‎08/04/2022 01:52 PM

Can you share accounimport json & api response


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.
0 Kudos

JohnLawson
Regular Contributor
Regular Contributor
In response to rushikeshvartak

‎08/04/2022 01:57 PM

The accountimport json is in an above comment and here are the logs showing a 202 response:

DEBUG rest.RestProvisioningService  -
DEBUG rest.RestProvisioningService  - pullObjectsByRest - responseStatusCode ::202
DEBUG rest.RestProvisioningService  - Entered getResponseHeaders method
DEBUG rest.RestProvisioningService  - responseError : null
DEBUG rest.RestProvisioningService  - isAuthError: false
DEBUG rest.RestProvisioningService  - pullObjectsByRest - responseMap.size : 0
DEBUG rest.RestProvisioningService  - pullObjectsByRest - objectList.size : 1
DEBUG rest.RestProvisioningService  - Inside importAccountsFull:persistAccounts, pptTypeSep : ~#~
DEBUG rest.RestProvisioningService  - Exception in persistAccounts try2 :
stdout F java.lang.NullPointerException: Cannot invoke method trim() on null object
stdout F at com.saviynt.provisoning.rest.RestProvisioningService.persistAccounts(RestProvisioningService.groovy:4733)
stdout F at com.saviynt.provisoning.rest.RestProvisioningService.processAccountsByPagination(RestProvisioningService.groovy:4080)
stdout F at com.saviynt.provisoning.rest.RestProvisioningService.processAccounts(RestProvisioningService.groovy:3987)
stdout F at com.saviynt.provisoning.rest.RestProvisioningService$_processAccountsFinal_closure11_closure78.doCall(RestProvisioningService.groovy:1635)
stdout F at com.saviynt.provisoning.rest.RestProvisioningService$_processAccountsFinal_closure11.doCall(RestProvisioningService.groovy:1631)
stdout F at com.saviynt.provisoning.rest.RestProvisioningService.processAccountsFinal(RestProvisioningService.groovy:1630)
stdout F at com.saviynt.provisoning.rest.RestProvisioningService.processAccountsFullBySequentialAndIterative(RestProvisioningService.groovy:1592)
stdout F at com.saviynt.provisoning.rest.RestProvisioningService.importAccountsFull(RestProvisioningService.groovy:1423)
stdout F at com.saviynt.provisoning.rest.RestProvisioningService.doImport(RestProvisioningService.groovy:137)
stdout F at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:227)
stdout F at ApplicationDataImportJob.execute(ApplicationDataImportJob.groovy:206)
stdout F at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
0 Kudos

rushikeshvartak
All-Star
All-Star
In response to JohnLawson

‎08/04/2022 01:54 PM

Add this is colsToPropsMap

"name": "DisplayUserId~#~string",


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.
0 Kudos

JohnLawson
Regular Contributor
Regular Contributor
In response to rushikeshvartak

‎08/04/2022 02:58 PM

Still getting:
Error - to Import Data correctly: Cannot invoke
method trim() on null object

0 Kudos

rushikeshvartak
All-Star
All-Star
In response to JohnLawson

‎08/04/2022 08:09 PM - edited ‎08/04/2022 08:10 PM

 

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty7",
"activeStatus": [
"true"
],
"deleteLinks": true,
"accountThresholdValue": 20,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": false,
"deleteAccEntForActiveAccounts": false
},
"call": {
"call1": {
    "callOrder": 0,
    "stageNumber": 0,
    "http": {
    "url": "https://XXXX/integrations/v1/Users?$top=500",
    "httpHeaders": {
    "Authorization": "${access_token}",
    "X-IN8-TENANT-PREFIX": "XXXX",
    "Ocp-Apim-Subscription-Key": "XXXX"
    },
    "httpMethod": "GET",
    "httpContentType": "application/json"
    },
    "makeProcessingStatus": true
},
"call2": {
    "callOrder": 1,
    "stageNumber": 1,
    "http": {
    "url": "${response?.headers?.Location?}",
    "httpHeaders": {
    "Authorization": "${access_token}",
	"X-IN8-TENANT-PREFIX": "XXX",
    "Ocp-Apim-Subscription-Key": "XXXXX"
    },
    "httpMethod": "GET",
    "httpContentType": "application/json"
    },
    "inputParams": {
    "dependentCall": true
    },
    "listField": "value",
    "keyField": "accountID",
    "nextApiKeyField": "accountID",
    "colsToPropsMap": {
   "name": "DisplayUserId~#~char",
    "accountID": "DisplayUserId~#~char"
    }
}
},

"pagination": {
    "offset": {
      "offsetParam": "Offset",
      "batchParam": "Max",
      "batchSize": 500,
      "totalCountPath": "total_count"
    },
    "nextUrl": {
      "nextUrlPath": "${response?.body?.size()>0?'https://XXX/integrations/v1/Users?$top=500&$skip=' + Math.addExact(total_count,500):null}"
    }
  }
}
}

 

 

This is changed

"name": "DisplayUserId~#~char",
"accountID": "DisplayUserId~#~char"

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.
0 Kudos

JohnLawson
Regular Contributor
Regular Contributor
In response to rushikeshvartak

‎08/05/2022 06:56 AM

So I tried that but it still gave the trim error. Working backwards from that I hardcoded some values and removed the first call which seems to be the issue. I was able to get a success (but no accounts) using:


{
  "accountParams": {
    "connection": "userAuth",
    "processingType": "SequentialAndIterative",
    "statusAndThresholdConfig": {
      "statusColumn": "customproperty7",
      "activeStatus": [
        "true"
      ],
      "deleteLinks": true,
      "accountThresholdValue": 20,
      "correlateInactiveAccounts": false,
      "inactivateAccountsNotInFile": false,
      "deleteAccEntForActiveAccounts": false
    },
    "call": {
      "call1": {
        "callOrder": 1,
        "stageNumber": 1,
        "http": {
          "url": "https://XXX.hds.ineight.comXXX",
          "httpHeaders": {
            "Authorization": "Bearer XXX",
            "X-IN8-TENANT-PREFIX": "XXX",
            "Ocp-Apim-Subscription-Key": "XXX"
          },
          "httpMethod": "GET",
          "httpContentType": "application/json"
        },
        "inputParams": {
          "dependentCall": true
        },
        "listField": "value",
        "keyField": "accountID",
        "nextApiKeyField": "accountID",
        "colsToPropsMap": {
          "accountID": "SourceSystemId~#~char"
        }
      }
    }
  }
}

 

I can't figure out what is wrong with the first call that is causing the trim error. The only thing I can think would be ${response.headers.get('Location')} but I tried removing that and still got the trim error. Am I doing the 2 call format correctly?

0 Kudos
Copyright © 2024 Khoros, LLC