Hi Experts,
Please help me to resolve my issue.
I want to convert the following data returned in "Text" format into a list of dictionary/map and afterwards map these fields to a CDT.
{ "IPAddress": "111.101.1111.11", "StartDate": "2024/06/26", "StartTime": "23:24:49", "StartTimezone": "UTC", "EndDate": "2024/06/28", "EndTime": "17:38:12", "EndTimezone": "UTC" }& { "IPAddress": "111.111.1101.11", "StartDate": "2024/07/02", "StartTime": "02:52:07", "StartTimezone": "UTC" }& { "IPAddress": "111.111.1110.11", "StartDate": "2024/07/07", "StartTime": "18:10:37", "StartTimezone": "UTC", "EndDate": "2024/07/09", "EndTime": "03:50:30", "EndTimezone": "UTC" }& { "IPAddress": "111.111.1111.10", "StartDate": "2024/07/16", "StartTime": "07:36:39", "StartTimezone": "UTC", "EndDate": "2024/07/17", "EndTime": "23:01:19", "EndTimezone": "UTC" }
Appreciate your help!
Discussion posts and replies are publicly visible
Could your team help me on this case, can they try it from their end once this usecase. As this is a client requirement for me I need to figure out stuff.
When the keys don't match the fields of your record, it will return null, and if your record is multiple, it will return {}. First, check that the fields of the json you send as parameters are equal to those of the fields of your record.
SOLUTION : Once casting is done in expression rule dont't try to save it in the PV which has record type data type if you do so it will throw {} null in value. Instead, once casted try to store in PV which has map data type in it, and from map PV try to map it to your record type it will work .