Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

ImportAccountEntJSON not fetching

Arsath_Ahmed
New Contributor III
New Contributor III

Hi,

 

We tried REST API for Salesforce connect.ImportAccountEntJSOn is not fetching from target.

 

Job error - Error - to Import Data correctly: Error in getting
the system names configured on the cloud server

 

ImportAccountENTJSON

{
    "accountParams": {
      "connection": "acctAuth",
      "processingType": "SequentialAndIterative",
      "call": {
        "call1": {
          "callOrder": 0,
          "stageNumber": 0,
          "http": {
            "url": "${connection.testname}",
            "httpHeaders": {
              "Authorization": "${access_token}",
              "Accept": "application/json"
            },
            "httpContentType": "application/json",
            "httpMethod": "GET"
          },
          "listField": "users",
          "keyField": "accountID",
          "statusConfig": {
            "active": "true",
            "inactive": "false"
          },
          "colsToPropsMap": {
            "accountID": "id~#~char",
            "name": "email~#~char",
            "displayName": "name~#~char",
            "customproperty2": "email~#~char",
            "customproperty3": "created_at~#~char",
            "customproperty4": "updated_at~#~char",
            "customproperty5": "role~#~char",
            "status": "active~#~char",
            "customproperty6": "last_login_at~#~char",
            "customproperty7": "custom_role_id~#~char",
            "customproperty8": "default_group_id~#~char",
            "customproperty9": "created_at~#~char",
            "customproperty10": "updated_at~#~char",
            "customproperty11": "suspended~#~char",
            "customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
          },
          "pagination": {
            "nextUrl": {
              "nextUrlPath": "${response.completeResponseMap.next_page}"
            }
          }
        }
      },
      "acctEntMappings": {
        "Role": {
          "listPath": "",
          "idPath": "custom_role_id",
          "keyField": "entitlementID"
        }
      }
    },
    "entitlementParams": {
      "connection": "acctAuth",
      "processingType": "SequentialAndIterative",
      "entTypes": {
        "Group": {
          "entTypeOrder": 0,
          "entTypeLabels": {
            "customproperty1": "Deleted",
            "customproperty2": "CreatedAt",
            "customproperty3": "UpdatedAt"
          },
          "call": {
            "call1": {
              "callOrder": 0,
              "stageNumber": 0,
              "http": {
                "url": "https://xxx/api/v2/groups",
                "httpHeaders": {
                  "Authorization": "${access_token}",
                  "Accept": "application/json"
                },
                "httpContentType": "application/json",
                "httpMethod": "GET"
              },
              "listField": "groups",
              "keyField": "entitlementID",
              "colsToPropsMap": {
                "entitlementID": "id~#~char",
                "entitlement_value": "name~#~char",
                "customproperty1": "deleted~#~char",
                "customproperty2": "created_at~#~char",
                "customproperty3": "updated_at~#~char"
              },
              "pagination": {
                "nextUrl": {
                  "nextUrlPath": "${response.completeResponseMap.next_page}"
                }
              },
              "disableDeletedEntitlements": true
            }
          }
        },
        "Role": {
          "entTypeOrder": 1,
          "entTypeLabels": {
            "customproperty1": "Description",
            "customproperty2": "CreatedAt",
            "customproperty3": "UpdatedAt"
          },
          "call": {
            "call1": {
              "callOrder": 0,
              "stageNumber": 0,
              "http": {
                "url": "https://xxx/api/v2/custom_roles.json",
                "httpHeaders": {
                  "Authorization": "${access_token}",
                  "Accept": "application/json"
                },
                "httpContentType": "application/json",
                "httpMethod": "GET"
              },
              "listField": "custom_roles",
              "keyField": "entitlementID",
              "colsToPropsMap": {
                "entitlementID": "id~#~char",
                "entitlement_value": "name~#~char",
                "customproperty1": "description~#~char",
                "customproperty2": "created_at~#~char",
                "customproperty3": "updated_at~#~char"
              },
              "pagination": {
                "nextUrl": {
                  "nextUrlPath": "${response.completeResponseMap.next_page}"
                }
              },
              "disableDeletedEntitlements": true
            }
          }
        }
      }
    },
    "acctEntParams": {
      "connection": "acctAuth",
      "entTypes": {
        "Group": {
          "call": {
            "call1": {
              "callOrder": 0,
              "stageNumber": 0,
              "processingType": "httpEntToAcct",
              "http": {
                "httpHeaders": {
                  "Authorization": "${access_token}"
                },
                "url": "https://xxx/api/v2/groups/${id}/memberships.json",
                "httpContentType": "application/x-www-form-urlencoded",
                "httpMethod": "GET"
              },
              "listField": "group_memberships",
              "entKeyField": "entitlementID",
              "acctIdPath": "user_id",
              "acctKeyField": "accountID",
              "pagination": {
                "nextUrl": {
                  "nextUrlPath": "${response.completeResponseMap.next_page}"
                }
              }
            }
          }
        },
        "Role": {
          "call": {
            "call1": {
              "callOrder": 0,
              "stageNumber": 0,
              "processingType": "acctToEntMapping"
            }
          }
        }
      }
    }
  }
8 REPLIES 8

Manu269
All-Star
All-Star

Can you share the details when tested via postman?

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Arsath_Ahmed
New Contributor III
New Contributor III

May I know which postman request. Is it the Endpoint URL test

Yes Run Accounts GET url from POSTMAN and share output


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

Manu269
All-Star
All-Star

Can you validate invoking above api via postman brings in result.

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Arsath_Ahmed
New Contributor III
New Contributor III

Hi slfce.jpg

 

 

Your API is not working from application side. Please work with application team to make api working . Check what all parameters are required, once its fixed an working from postman you can try from saviynt 


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

The endpoint URL is working.

 

But when attached to parameters for REST connector it throws NO URL existssls12.jpg

Manu269
All-Star
All-Star

Your API is not providing correct result from target application side.

Try involving application owner and crosscheck the payload URL

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.