REST Google Apps Import Account Access JSON

 {

  "accountParams": {

    "connection": "userAuth",

    "processingType": "SequentialAndIterative",

    "statusAndThresholdConfig": {

      "statusColumn": "customproperty21",

      "activeStatus": [

        "false"

      ],

      "deleteLinks": true,

      "accountThresholdValue": 100,

      "correlateInactiveAccounts": true,

      "inactivateAccountsNotInFile": false,

      "deleteAccEntForActiveAccounts": true

    },

    "call": {

      "call1": {

        "callOrder": 0,

        "stageNumber": 0,

        "http": {

          "url": "https://admin.googleapis.com/admin/directory/v1/users?projection=full&customer=C01cjfwbp",

          "httpHeaders": {

            "Authorization": "${access_token}"

          },

          "httpContentType": "application/json",

          "httpMethod": "GET"

        },

        "listField": "users",

        "keyField": "accountID",

        "colsToPropsMap": {

          "accountID": "id~#~char",

          "name": "primaryEmail~#~char",

          "displayname": "name.fullName~#~char",

          "status": "suspended~#~char",

          "customproperty6": "creationTime~#~char",

          "customproperty15": "lastLoginTime~#~char",

          "customproperty4": "customerId~#~char",

          "customproperty5": "deletionTime~#~char",

          "customproperty30": "primaryEmail~#~char",

          "customproperty8": "externalIds~#~char",

          "customproperty9": "includeInGlobalAddressList~#~char",

          "customproperty10": "ipWhitelisted~#~char",

          "customproperty11": "isAdmin~#~boolean",

          "customproperty12": "isDelegatedAdmin~#~char",

          "customproperty13": "isMailboxSetup~#~char",

          "customproperty14": "kind~#~char",

          "customproperty16": "notes~#~char",

          "customproperty17": "orgUnitPath~#~char",

          "customproperty21": "suspended~#~char",

          "customproperty22": "suspensionReason~#~char",

          "customproperty23": "websites~#~char",

          "customproperty36": "customSchemas.BXS_Extra.SSOEMPID~#~char",

          "customproperty27": "name.givenName~#~char",

          "customproperty28": "name.familyName~#~char"

        },

        "pagination": {

          "nextUrl": {

            "nextUrlPath": "${response?.completeResponseMap?.nextPageToken ? 'https://admin.googleapis.com/admin/directory/v1/users?projection=full&customer=C01cjfwbp&pageToken=' + response.completeResponseMap.nextPageToken : null}"

          }

        }

      }

    }

  },

  "entitlementParams": {

    "processingType": "SequentialAndIterative",

    "entTypes": {

      "GoogleGroup": {

        "entTypeOrder": 0,

        "call": {

          "call1": {

            "connection": "userAuth",

            "callOrder": 0,

            "stageNumber": 0,

            "http": {

              "httpHeaders": {

                "Authorization": "${access_token}"

              },

              "url": "https://admin.googleapis.com/admin/directory/v1/groups?customer=C01cjfwbp",

              "httpContentType": "application/json",

              "httpMethod": "GET"

            },

            "listField": "groups",

            "keyField": "entitlementID",

            "colsToPropsMap": {

              "entitlementID": "id~#~char",

              "entitlement_value": "email~#~char",

              "displayname": "name~#~char",

              "customproperty1": "directMembersCount~#~char"

            },

            "pagination": {

              "nextUrl": {

                "nextUrlPath": "${response?.completeResponseMap?.nextPageToken ? 'https://admin.googleapis.com/admin/directory/v1/groups?customer=C01cjfwbp&pageToken=' + response.completeResponseMap.nextPageToken : null}"

              }

            }

          }

        }

      }

    }

  },

  "acctEntParams": {

    "connection": "userAuth",

    "entTypes": {

      "GoogleGroup": {

        "call": {

          "call1": {

            "callOrder": 0,

            "stageNumber": 0,

            "processingType": "httpEntToAcct",

            "http": {

              "httpHeaders": {

                "Authorization": "${access_token}"

              },

              "url": "https://admin.googleapis.com/admin/directory/v1/groups/${id}/members",

              "httpContentType": "application/x-www-form-urlencoded",

              "httpMethod": "GET"

            },

            "listField": "members",

            "entKeyField": "entitlementID",

            "acctIdPath": "id",

            "acctKeyField": "accountID",

            "pagination": {

              "nextUrl": {

                "nextUrlPath": "${response?.completeResponseMap?.nextPageToken ? 

'https://admin.googleapis.com/admin/directory/v1/groups/'+id+'/members?pageToken='+

response.completeResponseMap.nextPageToken : null}"

              }

            }

          }

        }

      }

    }

  }

}


Comments

Post a Comment

Popular posts from this blog

Enhanced Query - To Update Account Status and Name

select accountkey as accounts__primarykey, 'SUSPENDED FROM IMPORT SERVICE' as accounts__status, CONCAT(name,'-Deleted on-', DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s'))as accounts__name from accounts where endpointkey=527 and name='CN=INRVCH,OU=User Accounts Vista,OU=User Accounts,OU=User Directory,DC=asia-pac,DC=xx,DC=com'  and status not in ('SUSPENDED FROM IMPORT SERVICE') limit 1;
Read more

Connection Config - STATUS_THRESHOLD_CONFIG

 {   "statusAndThresholdConfig": {    "inactivateAccountsNotInFile": true    "statusColumn":"userlock",    "activeStatus":["0","128","192"],     "accountThresholdValue": 500,     "deleteLinks": false,     "correlateInactiveAccounts": true,        } } ----------------------------------------------------------------------------- When account import run above STATUS_THRESHOLD_CONFIG is used to check. ----------------------------------- inactivateAccountsNotInFile  ==> True/false true ---> Account status 1/2 ( Active/Inactive) Day 1 --> 100 Accounts import Day 2 --> 90 Diff= 10  ( 90= Active , 10 Inactive)  ------------------------------------------------------------------------------ ----------------------------------- inactivateAccountsNotInFile  ==> True/false false ---> Account status 1/SFIS ( Active/SUSPENDED FROM IMPORT SERVICE.) Day 1 --> 100 Ac...
Read more

SQL - Connection table

 select EXTERNALCONNECTIONKEY,CONNECTIONDESCRIPTION,CONNECTIONNAME,CONNECTORMS,CREATEDBY,CREATEDON,CREDENTIALCHANGECONFIG,EMAILTEMPLATE,EXTERNALCONNECTIONTYPE,MSCONNECTORVERSION,NODE_MAC_ID,SSLCERTIFICATE,STATUS s,STATUSFORENABLEDISABLE,TEMPLATE_MANDATORYDATA,TEMPLATENAME,UPDATEDBY,UPDATEDON,VAULTCONFIG,VAULTCREDENTIALCONNECTION,CONNECTORTYPE  from externalconnection  SELECT   eh . connectionname ,         CASE           WHEN   eh . operation   =   'Remove'                AND   (   eh . newvalue   IS   NULL                       OR   eh . newvalue   =   ''   )   THEN   'ROLE_ADMIN'           ELSE   Conca...
Read more