ESA's CDF library written by Mark Taylor is already in Maven, and we also have long-term plans to integrate the two libraries. It might be productive to use it instead of the CDFJ library created at NASA/Goddard.

Some of the CDF files have records repeated, which is not allowed in HAPI and the verifier is catching it:

wget -O - 'http://localhost:8080/HapiServer/hapi/data?id=solo_L2_rpw-tnr-surv&parameters=Epoch&time.min=2023-09-20T00:00Z&time.max=2023-09-21T00:00Z'

I'm putting in code to cull repeated records.

• I also need to check that sufficient resolution is printed to represent the times precisely.

This dataset would return multiple repeat records:
String id= "availability/solo_L2_mag-rtn-normal";
String t= "2023-01-01T00:00Z/2023-01-03T00:00Z";

This is because the TAP response has both solo_L2_mag-rtn-normal and solo_L2_mag-rtn-normal-1-minute, and the TAP query uses "LIKE".

The code now checks that it is an exact match, but there is probably a better way to form the query.

How do I get the energies for a spectrogram?

https://soar.esac.esa.int/soar-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=json&QUERY=select%20*%20from%20soar.v_cdf_plot_metadata%20where%20logical_source%20=%20%27solo_L2_epd-het-south-rates%27

shows that I have a DEPEND_1 of "energy" but how do I request this?

The verifier caught where timetags are returned which are past the time.max:

wget -O - 'https://cottagesystems.com/server/esdc/hapi/data?id=solo_L2_rpw-tnr-surv&parameters=Epoch&time.min=2023-09-20T00:00Z&time.max=2023-09-21T00:00Z' | tail -3

returns:

2023-09-21T00:00:07.071Z
2023-09-21T00:00:03.035Z
2023-09-21T00:00:07.082Z

These should be clipped by the server.

Also I need to study which CDFs will need to have their timetags sorted.

It looks to me like five of the data sets do not have any CDF file granules.
solo_L2a_swa-eas1-nm3d-psd
"solo_L2_mag-rtn derived from LL data"
"solo_L2_mag-srf derived from LL data"
solo_L2a_swa-eas1-nm3d-def
solo_L2a_swa-eas1-nm3d-dnf

For example,

https://soar.esac.esa.int/soar-sl-tap/tap/sync?REQUEST=doQuery&LANG=ADQL&FORMAT=csv&QUERY=SELECT+TOP+1+begin_time,end_time,filename,data_item_id+FROM+v_sc_data_item+WHERE+data_item_id+LIKE+%27solo_L2a_swa-eas1-nm3d-psd%25%27+ORDER+BY+begin_time+ASC

returns no records.

I will resolve this by excluding these from the server, but this ticket is to make sure this is not an error elsewhere.

Jon Cook to check

• Where to put ESDC HAPI source code
• Fill values
• Descriptions of each parameter

I noticed a case where the name of a variable was "epoch " and then it had spaces after it.