- TLC Home Home
- Discussions Discussions
- Documentation Documentation
- Knowledge Base Knowledge Base
- Education Education
- Blog Blog
- Support Desk Support Desk
Has anyone got any experience or advice on parsing the JSON objects from EventStore?
I need to find the events that correspond to particular Adobe Analytics calls on a certain date in amongst the 14Gig of data. I've spent some time looking at JSON > DB parsers but haven't had much luck in getting them to accept the data format as it comes.
Ideally I want something to loop through the files and extract rows if they have a particular propery in them, and then save that data into something else (a CSV would be OK at this point).
Solved! Go to Solution.
I reckon a PowerShell script is the way forward on this... Must be easier than doing something in JS and processing millions of lines of data.
I'd recommend you look into jq. It has a learning curve (although not too bad). Any other tools I tried didn't scale up to large files very well. jq can search and transform JSON data, and can transform it into CSV as output.
And here is the best tutorial I found (although there are a few and you may prefer a different one)
05-10-2019 06:30 AM - edited 05-10-2019 06:30 AM
That's exactly what I'm looking for!
I see this is already answered, however if anyone is doing more data work of this nature, i highly recommend Alteryx. It's a real enabler and we have been setting up all sorts of extracts and smart integrations.
Copyright All Rights Reserved © 2008-2023