I know that I can set up a JSON feed that makes certain data from my industry-specific database software available in real-time. I know that I can set up ZOHO to schedule a regular "call" on this JSON feed, and I've been able to successfully import data this way, tested it a few times.

It seems the JSON file my software gives me contains a "legend" that ZOHO reads as the first X rows of the data set. (X = the number of columns in the data set). However, Zoho does not seem to read this as a legend, and does not correctly name the columns. I can skip the first X columns, which takes the legend data out of my

No matter what I do in the import, the column names do not work, and if I rename the columns, subsequent "Refetch" fails (and I'm assuming this would mean scheduled pulls would fail also). Though the dashboards and auto-analysis functions seem very powerful, not being able to name the columns makes reading those reports very difficult!

How can I get ZOHO to recognize the legend, or, how can I rename columns and still be able to have the data set update automatically?