Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
11/21/2023
12:41 AM
- last edited on
11/22/2023
05:29 AM
by
Sunil
Hi Team ,
below is the Api response :
{
"data": [
{
"report_header": {
"c3": {
"name": "PROJECT_NUMBER",
"type": "java.lang.String"
},
"c4": {
"name": "GROUP_ID",
"type": "java.lang.Integer"
},
"c5": {
"name": "GROUP_NAME",
"type": "java.lang.String"
},
"c6": {
"name": "ISTEMPLATE",
"type": "java.lang.Boolean"
},
"c7": {
"name": "PROJECT_STAUTUS",
"type": "java.lang.Integer"
},
"c1": {
"name": "PROJECT_ID",
"type": "java.lang.Integer"
},
"c2": {
"name": "PROJECT_NAME",
"type": "java.lang.String"
}
},
"report_row": [
{
"c1": "1,071 ",
"c2": "Part B- Peterhead 400kV GIS",
"c3": "2226GB50043",
"c4": "1,000,661 ",
"c5": "PEC",
"c6": "false",
"c7": "1 "
},
{
"c1": "1,071 ",
"c2": "Part B- Peterhead 400kV GIS",
"c3": "2226GB50043",
"c4": "1,000,661 ",
"c5": "PEC",
"c6": "false",
"c7": "1 "
}
]
}
]
}
JSON :
"entitlementParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Group": {
"entTypeOrder": 1,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://<hotsname>/ws/rest/service/v1/data/udr/get",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpParams": "{\"reportname\":\"PROJECT_GROUPS\"}",
"httpMethod": "POST"
},
"listField": "data.report_row",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "c1~#~char",
"entitlement_value": "c2~#~char",
"customproperty1": "c3~#~char",
"customproperty2": "c4~#~char",
"customproperty3": "c5~#~char",
"customproperty4": "c7~#~char"
},
"successResponses": {
"statusCode": [
200
]
},
"unsuccessResponses": {
"statusCode": [
500,
401,
403
]
}
}
}
}
}
}
Error :
[quartzScheduler_Worker-11] DEBUG rest.RestProvisioningService - batchDetailsMap size: 3
2023-11-21/07:23:49.861 [{}] [quartzScheduler_Worker-11] DEBUG rest.RestProvisioningService - isBatchFailDueToDeadlock: false
2023-11-21/07:23:49.861 [{}] [quartzScheduler_Worker-11] DEBUG rest.RestProvisioningService - isBatchFailDueToDuplicate: false
2023-11-21/07:23:49.861 [{}] [quartzScheduler_Worker-11] DEBUG rest.RestProvisioningService - INFO ErEx: importAccessFull:persistObjects : Data truncation: Data too long for column 'ENTITLEMENTID' at row 1
Hi Team ,
Any update on this.
Hi Team ,
Please look into this , getting escalations due to delay.
[This message has been edited by moderator to merge reply comment]
Solved! Go to Solution.
11/22/2023 10:02 AM
Can you try with below and see if it works
"listField": "data[0].report_row",
12/22/2023 01:47 AM
@IAM-Vaibhav , is your problem resolved?? I have same issue.
12/22/2023 01:50 AM
@SB , your provided solution is working thanks.