I'm trying to import data from this api endpoint: http://data.chesapeakebay.net/api.csv/WaterQuality - I know the normal workflow uses the text to columns tool where I add that URL in the url column and then have the download tool configured correctly I believe (Basic tab is looking at the url column and payload tab is doing a GET with the Compose Query String/Body field selected). When I add a browse tool at the end of it, I get an error in the two columns that are created (DownloadData and DownloadHeaders) like it's not even reading the API. If I add a json parse tool betweeen the download and browse tools, the workflow is run but the fields output null data in the columns. I'm wondering what I'm doing wrong or the right process for importing data from this API is. Any help is much appreciated! Thank you!
I attached the simple workflow I started with the json parse tool so all the fields are nulled out in the Browse tool.
