Question

7
Views
Mahesh Puppala (MaheshP48)
Evoke Technologies

Evoke Technologies
IN
MaheshP48 Member since 2021 1 post
Evoke Technologies
Posted: 3 weeks 2 days ago
Last activity: 2 weeks 3 days ago
Posted: 6 Jul 2021 14:13 EDT
Last activity: 12 Jul 2021 9:59 EDT

DateSet JSON File reading not working properly

Hello All,

I have requirement to read JSON file using DATASET. I am not able to read the below structure 

Hello All,

I have requirement to read JSON file using DATASET. I am not able to read the below structure 

{     "type": "array",     "CustomerInfo" : [       {          "CifNbr" : "1",          "ClientID" : "C10",          "NamePrefix" : "Mrs",          "FullName" : "Mahesh Puppala",          "PrimaryIDType" : "Mahesh123",          "Gender" : "Male",          "MaritalStatus" : "Married",          "Age":"30",          "CustomerID" : "C1",          "FirstName" : "Mahesh",          "LastName" : "Puppala",          "Address" : [             {                "AddressID" : "1",                "Address1" : "1-13",                "CustomerID" : "C1",                "City" : "Hyderabad",                "pyCountry" : "IN",                "PIN" : "500085",                "State" : "TS",                 "AddressType" : "Permanent"             }          ]       }

 

But , If I remove "CustomerInfo" and {} braces from first lines it is working. Could you please help me in resolving these and what exactly the JSON structure we can use.

***Edited by Moderator Marissa to change type from Pega Academy to Product, update Product details and Platform Capability tags****
Pega Platform Data Integration