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.
In your CSVFormatter, you’re using ‘$Username’ as one of the header and the resulting output is a column of empty strings. I assume that’s what you’re seeing to, yes? Note, that it’s blank because there is no property named ‘Username’ in the input document. There is a property named ‘userId’, though.
So, if you change the header to ‘$userId’, you should see data coming out of the CSVFormatter. If you want to change the name of the property, you’ll need to use a Mapper snap, like so:
I’m wondering if you were expecting the order of the list of headers in the CSVFormatter to correspond to the order of the columns in the preview? Is that right? Or, perhaps, I’m reading too much into this…
Oh hmmmmm yes I understand. What was throwing me off is that if you validate the pipeline than at every snap, like after the JSON splitter, if you click the green output doc in the snap connector on the right it shows the correct output , but the CSV formatter’s green doc looks totally wrong (even after I fix the headers), so after it didn’t work the first time, I never checked the actual CSV file again:
I’ll keep a note to myself not to trust what the formatters display.
Thank you so much!! You’re a hero.
