Hello,
We are trying to obtain users and sku's from below ImportAcctEntJSON. We are getting users, entitlement type as SKU. However, SKU's are not coming in. Any suggestions on what could be missing?
{
"globalSettings": {
"dateFormat": "yyyy-MM-dd'T'HH:mm:ss'Z'"
},
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty5",
"activeStatus": [
"true"
],
"deleteLinks": "true",
"accountThresholdValue": 100
},
"call": {
"call1": {
"callOrder": 1,
"listField": "value",
"keyField": "accountID",
"http": {
"url": "https://graph.microsoft.com/v1.0/users?$select=givenname,surname,id,accountEnabled,displayname,userp...",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
}
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${(response?.completeResponseMap?.get('@odata.nextLink')==null)? null : response?.completeResponseMap?.get('@odata.nextLink')}"
}
},
"colsToPropsMap": {
"accountID": "id~#~char",
"customproperty5": "accountEnabled~#~char",
"customproperty1": "userType~#~char",
"displayName": "displayName~#~char",
"name": "userPrincipalName~#~char",
"customproperty2": "givenname~#~char",
"customproperty3": "surname~#~char",
"customproperty35": "usageLocation~#~char",
"customproperty38": "signInActivity.lastSignInDateTime~#~char",
"LASTLOGONDATE": "signInActivity.lastSignInDateTime~#~date"
}
}
}
},
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"SKU": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://graph.microsoft.com/v1.0/subscribedSkus",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "text/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "Rsp.Result",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "skuId~#~char",
"entitlement_value": "skuPartNumber~#~char"
},
"disableDeletedEntitlements": true
}
}
},
"acctEntParams": {
"processingType": "acctToEntMapping"
}
}
}
}
