Keenio extracted data shows columns shuffled everytime

[Sifar]

Hi,

I am pulling Keenio extracted data (email data from sendgrid) for 2 years with all column headers, into a google spreadsheet with the help of IMPORTJSON. I have created pivots and formulae in columns that reference the extracted data. Keen IO refreshes this data everyday, but everytime the column headers order changes, thereby resulting in my formulae and pivots not working correctly. Is there a way to resolve this keen io behaviour so that everytime the column headers fall into the same sequence and my formulae and pivots work properly?

[Sifar]

Below i am using the Keenio Extraction API with IMPORTJSON AppScript to pull in the enriched SendGrid Email events data.

[Ricky Vidrio]

Hey Sifar,

Thank you for reaching out. Unfortunately, Keen IO doesn't have something out of the box that can resolve this. This is an excellent feature that we’d be happy to put on our product backlog to investigate in the future. In the mean time, here are some links on how to accomplish this.

Stackoverflow:https://stackoverflow.com/questions/33001490/python-re-ordering-columns-in-a-csv

Ruby: https://stackoverflow.com/questions/22886857/how-do-you-rearrange-the-order-of-columns-in-a-csv-file

Thanks for your feedback,

	Ricky Vidrio Director of Customer Success
	E: ri...@keen.io P: 415-342-9740
	keen.io