and more in a single search tool across platforms. Read the announcement here. |
12/11/2022 09:22 AM
Hi,
We want to reconcile the account using the REST API we are getting the response below:
12/11/2022 04:11 PM
Keep listField blank share you json
12/11/2022 05:38 PM
Hi @rushikeshvartak,
Please find an attached response.
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "/LibraryStd/api/users?fields=id,name,abbreviation,description,dateCreated,dateModified",
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "",
"keyField": "accountID",
"colsToPropsMap": {
"accountID":"id~#~char",
"name":"name~#~char",
"customproperty1": "abbreviation~#~char",
"customproperty2": "description~#~char",
"createdon": "dateCreated~#~char",
"updatedate": "dateModified~#~char"
}
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Roles": {
"entTypeOrder": 0,
"entTypeLabels": {},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https:/LibraryStd/api/usergroups",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char"
}
}
}
}
}
},
"acctEntParams": {
"connection": "acctAuth",
"entTypes": {
"Roles": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpEntToAcct",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https:///LibraryStd/api/usergroups",
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "",
"entKeyField": "entitlementID",
"acctIdPath": "user_id",
"acctKeyField": "accountID"
}
}
},
"Roles": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "acctToEntMapping"
}
}
}
}
}
}
After using above json in ImportAccountEntJSON we are not getting any error in job log.
Please find below screenshot for more information.
Thank You,
Aditya Chadde
12/12/2022 09:57 AM
Hi,
Using the below connection JSON we are not getting any error after running the Account and Access import job but the accounts and entitlements are not getting imported.
Please find the below Json for more information:
Connection JSON:
{
"authentications": {
"acctAuth": {
"authType": "Basic",
"url": "/auth/login?password=&username=",
"httpMethod": "POST",
"httpParams": {},
"httpHeaders": {},
"httpContentType": "application/x-www-form-urlencoded",
"properties": {
"userName": "",
"password": ""
},
"authError": [
"The user session has expired, please reauthenticate",
"Invalid OAuth token Bearer"
],
"retryFailureStatusCode": [401, 403],
"errorPath": "message",
"maxRefreshTryCount": 5,
"tokenType": "Basic",
"accessToken": "Basic abcd"
}
}
}
AccountEntImportJson:
{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative"
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "name~#~char",
"customproperty1": "abbreviation~#~char",
"customproperty2": "description~#~char",
"createdon": "dateCreated~#~date",
"updatedate": "dateModified~#~date"
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Roles": {
"entTypeOrder": 0,
"entTypeLabels": {},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char"
}
}
}
}
}
},
"acctEntParams": {
"connection": "acctAuth",
"entTypes": {
"Roles": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpEntToAcct",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "",
"httpContentType": "application/x-www-form-urlencoded",
"httpMethod": "GET"
},
"listField": "items",
"entKeyField": "entitlementID",
"acctIdPath": "user_id",
"acctKeyField": "accountID"
}
}
}
}
}
}
Thank You,
Aditya Chadde
12/12/2022 11:29 AM
access_token is not sent from connectionJSON
https://saviynt.freshdesk.com/support/solutions/articles/43000521736-rest-connector-guide%C2%A0
12/12/2022 09:59 PM - edited 12/12/2022 11:04 PM
Hi @rushikeshvartak,
In Api we are not getting any token in response we are using it to create session. Please find below screenshot for more information.
API Architecture is different here first we need to send a post request from one URL by passing username and password as query parameters and then we need to use different API to get accounts, but we don't pass any token in the get accounts API.
We have tried using Basic Auth, OAuth both are not working please suggest us a way to achieve this.
Best Regards,
Aditya Chadde
12/12/2022 10:02 PM
Please remove confidential information from public forums
01/03/2023 03:18 AM
Hi,
We want to reconcile all accounts and entitlements form the target application using REST Connection.
In postman we are getting the "X-MSTR-AuthToken" in response header. Please find the attached Screenshot for more information.
How to create a connection JSON to get the access token from response header?
We have tried using Basic and OAuth2 Connection JSON format but it is not working.
If anyone worked on such requirements please share a connection JSON Format with us.
Best Regards,
Aditya Chadde
01/03/2023 04:44 AM
Does same needs to be passed for CRUD operations ?
01/03/2023 04:53 AM - edited 01/03/2023 04:54 AM
We are using DB Connector for CRUD operations. Just reconciling accounts and access using REST.
Best Regards,
Aditya Chadde
01/03/2023 04:55 AM
can you try using Postman and find if its required
01/03/2023 09:03 AM
In postman if we send post request by passing username and password in response no content is visible
but after sending the post request one session is created after this when we use get user API it will give the response. So, in postman it is token required but in saviynt it is not creating any session. It is showing error as below.
01/04/2023 09:14 AM
what is method type? it should PUT
01/04/2023 10:24 AM
In postman put method is not working, we are using post method to create session.