ImportJSON icon indicating copy to clipboard operation
ImportJSON copied to clipboard

Published 20 hours ago • verified publisher icon bradjasper

Not parsing NULL values correctly

Open seankirkconnell opened this issue 4 years ago • 0 comments

Hi there - the importJSON fuction is not parsing the NULL values correctly in this flight data API for Denver: http://aviation-edge.com/v2/public/timetable?key=33e556-819cf8&iataCode=den&type=departure

The fuction works properly for the Seatle API: http://aviation-edge.com/v2/public/timetable?key=33e556-819cf8&iataCode=sea&type=departure

In Seatle any of the 'Codeshared' columns that are null appear blank in the Google Sheets. In Denver if a 'Codeshared' column is blank, it pulls the codeshared value from the row above.

Any help with this would be much appreciated.

Thanks!

seankirkconnell avatar Jan 28 '20 18:01 seankirkconnell