BUG - Thruster files not available via the SPICE query API

[mhairifin]

Description of the issue

The thruster/small forces files are not queryable via the SPICE query API. I would expect them to be available under the file_type thruster, as in the expected SPICE file list.

Steps to reproduce the issue

https://api.imap-mission.com/spice-query?start_time=799242457&end_time=899242957&type=thruster

No files are returned.

https://api.imap-mission.com/spice-query?start_time=799242457&end_time=899242957

No thruster/small forces files are returned in this batch, and I would expect to see some.

Expected behavior (What should happen)

The available thruster files should be listed in the query API, so as to be downloadable via imap-data-access

Actual behavior (What does happen)

No small forces/thruster files are listed in the query API

Code Snippet:

Code

Additional notes, affected areas, and suggested fixes

No response

[maxinelasp]

@tech337 @subagonsouth Not a critical blocker for now, but I want to put it on your radar

[maxinelasp]

It looks like we don't have this file in the expected format right now, so this may get resolved once we receive that data. It sounds like SDC members are talking this over with the MOC.

[maxinelasp]

IMAP-Science-Operations-Center/imap-data-access#277

Should hopefully be fixed now!

[greglucas]

This is a critical issue that we need to look into and fix. We do have these files in s3, but not being returned from our APIs.

We need to figure out if it is in the Database, the sds api code needs to be updated or something else.

[tech3371]

I am working on this. We need to create table and API similar to spin and repoint. I will have PR up soon either today or Monday.

[greglucas]

I'm going to reopen this because the PR doesn't quite work how the initial request was expecting, rather it adds another endpoint. I think we should figure out what we need to do to route spin/repoint/thruster (non-spice) files through the normal SPICE query route.

This page has a "spin", "repoint", "thruster" option, and the url above has type=thruster in the query.
https://dev.imap-mission.com/data/spice/download

We should look into intercepting that and pointing to the proper table with the data depending on the type if that is necessary. It would be nice to have the same entry point and be able to list all files requested given the type.