I'm completely stuck trying to write JSON to CSV - it's been 4 days. Can anyone help?
I’m brand new to Snaplogic and this is probably really easy - sorry in advance! But I’ve been stuck on this since Thursday, and it’s now Tuesday… please help me. As a whole, I have this: In more detail: I have a JSON splitter, which has an output of the JSON I want to write to a CSV. And, if I preview the output in table view, it looks exactly like the CSV I want (I had an image here, but new users can only put one - sorry!). Previewing in JSON shows that it’s, well, JSON. After that, I have a CSV formatter, but I don’t have anything configured in it. Should I? The output view for this is more or less empty, so this clearly isn’t correct. I’ve tried JSON formatters and a million other things here. I just don’t know. Then I have my file writer (and as a bonus, I want only some of the fields from the JSON to be written to the CSV file). I can do it in Python: # Call the API r = requests.get(url_to_call, headers = headers) json_to_write = r.json() # Open a file for writing outfile = open(file_name,'w') writer=csv.writer(outfile) # Write CSV Header Row writer.writerow(["Id", "FirstName", "LastName"]) # Loop through each line of the JSON; print key values needed for x in json_to_write: writer.writerow([x["Id"], x["FirstName"], x["LastName"]]) I found this post on turning JSON to CSV by @dmiller and this post on writing a Twitter Query to a file, but as far as I can tell, those are just “use these snaps” without showing how the snaps are configured, and I’ve tried those configurations of snaps. I’m so lost. Any help appreciated.
Flatten JSON files into CSV files
Created by @schelluri The pipeline pattern flattens a JSON file, which has multiple objects, and turns it into a CSV file. Configuration Sources: JSON Generator Targets: CSV file Snaps used: JSON Generator, JSON Formatter, JSON Parser, Script, CSV Formatter, File Writer Downloads MS_Flatten_Script.slp (31.4 KB)
JSON Object Diff
Is there a way to easily show what key values do not match between two JSON objects? If I have two objects with the same keys, can I output just the keys and values that do not match between the two objects? I am looking for a way to do this without having to create an equality expression for each key.
Remove emply/null value fields from JSON
Can you help me to remove empty/null value fields from a JSON structure? Kindly suggest pipeline design suggestion or expression language for the below expected results. Thanks! Input: { “INVOICE”: { “TITLE”: “Test”, “DESCRIPTION”: “Test124”, “VERSION”: “”, “IRN”: “”, “TRANDTLS”: { “TAXSCH”: “”, “SUPTYP”: “B2B”, “REGREV”: “”, “IGSTONINTRA”: “N” }, “NOTES”: { “ID”: “”, “TEXT”: “” } } } Expected Output { “INVOICE”: { “TITLE”: “Test”, “DESCRIPTION”: “Test124”, “TRANDTLS”: { “SUPTYP”: “B2B”, “IGSTONINTRA”: “N” } } }
How to bring API JSON text into REST Post Snap?
Hi all, I am trying to use a JSON file to feed in the body of a response that is working in Postman with curl code like this: In SnapLogic I added the raw body in a JSON generator and want to feed that into a REST Post Snap. My pipeline looks like this: With no headers nor queries in Postman, only the JSON/raw body and the service URL, I retrieve results with no issues. However, with Snaplogic I am not receiving output. Has anyone done this? I am told I cannot incorporate the credentials into the headers, it must be in the body…but how do I reconcile this with SnapLogic? No one on my team has worked on something externalized that has functioned in this way. Thanks!
Create 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 data