NASA FIRMS data ingestion
Hello Knime community, I have a problem I hope someone can help with. I am trying to incorporate NASA FIRMS VIIRS into my geospatial analysis but am struggling with the API call.
The GET request node connects to NASA FIRMS and extracts the data I need, but I cannot figure out how to get the CSV writer to format the data correctly. When I write the API response to a csv and open it in Excel I get a single cell with the headings separated by comas, as well as multiple rows of data.
Using the text to column function in excel somehow deletes the data but keeps the headers. In the subsequent rows I get the remaining data (image and file attached here).
Can anyone recommend a better way to make this API call / format th CSV within Knime (avoiding manual data manipulation in Excel). Would it be better to manage this (writing to a db for example)?
I am very new to Knime but am determined not to use anything else if I can avoid it.
