02/21/2023 02:10 AM
Hi ,
I am trying to import data for a REST connector and i am facing error while importing.
INFO: Account Name is null, record not saved. I tried multiple combimnations of ListField but not able to solve the issue.
Postman response is
{
"schemas": [
"urn:ietf:params:scim:api:messages:2.0:ListResponse"
],
"totalResults": 501,
"startIndex": 1,
"itemsPerPage": 501,
"Resources": [
{
"schemas": [
"urn:ietf:params:scim:schemas:core:2.0:User"
],
"emails": [
{
"value": "testuser@abc.com",
"primary": true
}
],
"meta": {
"created": "2019-07-25T02:24:00",
"location": "https://mixpanel.com/api/app/scim/v2/Users/user-1791049",
"resourceType": "User"
},
"displayName": "test P",
"name": {
"givenName": "test",
"familyName": "P"
},
"active": true,
"id": "user-1791049",
"userName": "testuser@abc.com"
},
]
}
and my Importaccount json is :
{
"accountParams":{
"connection":"acctAuth",
"processingType":"SequentialAndIterative",
"call":{
"call1":{
"callOrder":0,
"listField":"schemas",
"keyField":"accountID",
"makeProcessingStatus":true,
"http":{
"url":"https://mixpanel.com/api/app/scim/v2/Users",
"httpMethod":"GET",
"httpContentType":"application/json",
"httpHeaders":{
"Authorization":"Bearer <token>",
"Accept":"application/json"
}
},
"colsToPropsMap":{
"accountID":"id~#~char",
"name":"username~#~char",
"status":"active~#~char"
}
}
}
}
}
Help me in understanding how to define Listfiled for the connector
02/21/2023 12:40 PM
In order to fetch the userName, you can define "listField":"Resources" since the value of username is defined under Resources.
You can also use any online tool to view your postman response in order to identify the list field value which holds the user information.