Parin
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Extract data from Json to CSV File
Hi All, I have a JSON file and i am trying to extract specific data and copy it in a csv file. The sample structure is given below and from this structure i want to extract only the value part from each attribute: Like “value”: “B12345678” “value”: “Test” in the CSV file. Sample Structure: [ { “uri”: “entities/Uar9IVr”, “createdTime”: 1579160841170, “updatedTime”: 1579694894814, “attributes”: { “HCOID”: [ { “type”: “configuration/entityTypes/HCO/attributes/HCOID”, “ov”: true, “value”: “B12345678”, “uri”: “entities/Uar9IVr/attributes/HCOID/1OAQhar5j” } ], “Name”: [ { “type”: “configuration/entityTypes/HCO/attributes/Name”, “ov”: true, “value”: “Test”, “uri”: “entities/Uar9IVr/attributes/Name/1OAQZvp6V” } ] } ] I am also attaching the entire structure for better understanding of the structure. Can anyone help me with a sample snap solution for this kind of structure. FlattenJson.txt (6.1 KB)5.7KViews0likes2CommentsRe: Create JSON from CSV file
Hi Alchemiz, Thank you for the sample snap and your assumption is correct but this is not the exact structure that i am looking for. The different records are part of same array like in case of fname. I have attached a smaple json for mutiple records which i need to create. Also is there a way we can use JSON Generator snap which can use csv file data and convert it into JSON as i looking for something more dynamic.SampleJSON.txt (1.9 KB)4.2KViews0likes1CommentCreate JSON from CSV file
Hi, I am new to snaplogic and want to create a JSON structure from a CSV file. CSV file data “Name”,“AddressLine1” “Test1234”,“122 Test St” The structure i need is very specific like: [ { “attributes”: { “Name”: [ { “value”: “Test1234” } ], “Addresses”: [ { “value”: { “AddressLine1”: [ { “value”: “122 Test St” } ] } }] }] Can someone help with a sample pipeline to create Json from CSV data6KViews0likes4Comments