AllenNeuralDynamics / aind-metadata-service

Service to retrieve Labtracks/Sharepoint info using a REST API

MIT License

3 stars 1 forks source link

Extract TARS identifiers from LabTracks RO injections and join with TARS metadata #193

Closed mekhlakapoor closed 2 months ago

mekhlakapoor commented 7 months ago

User story

As a user, I want Labtracks procedures to include injection materials information.

Acceptance criteria

[x] Given field in LAS tracking injection, map to injection procedure.
[ ] Given some field in LAS tracking injection materials, query tars.
[ ] Given tars response, integrate viral material object back into procedure model.

Sprint Ready Checklist

[ ] 1. Acceptance criteria defined
[ ] 2. Team understands acceptance criteria
[ ] 3. Team has defined solution / steps to satisfy acceptance criteria
[ ] 4. Acceptance criteria is verifiable / testable
[ ] 5. External / 3rd Party dependencies identified
[ ] 6. Ticket is prioritized and sized

Notes

Add any helpful notes here.

mekhlakapoor commented 7 months ago

the injection materials info and injection volume are put in a comment section in the TASK_TABLE in LAS. I pulled a random sample of comments, and there is no pattern that these comments follow. We'll need LAS to track this in a dedicated field, or parse it out of the comment (only idea I have is to look for "VT.." in the comment, might not be very reliable). What do you think @dyf @saskiad @jtyoung84

jtyoung84 commented 7 months ago

Can you post some examples in Teams?

mekhlakapoor commented 7 months ago

Blocked because we need this info to be stored in a more reliable field in LAS. In talks

mekhlakapoor commented 5 months ago

LAS is going to add fields to the request form in sharepoint instead of Labtracks. Once they do, we'll need to add an endpoint to pull from the sharepoint

mekhlakapoor commented 3 months ago

Blocked: Need to add access to NSP sharepoint to our credentials or create new sharepoint credentials